Replicat Abended with following Error
ERROR OGG-01705 Input checkpoint position 119195676 for input trail file '/opt/app/ggs/trails/af000047' is greater than the size of the file (119194872). Please consult Oracle Knowledge Management Doc ID 1138409.1. for instructions.
Rootcause: Checkpoint is struck inside the trail and RBA keep on increasing and make Replicat Abended
Potential Fix: In-order to run fix replicat and avoid duplicate processing of records follow the steps as follows
From report File
A) 119195676 ( Check point Position on Trail )
B) 119194872 ( Size of the Trail )
In order to start Replicat We have to follow Formulae
Replicat RBA = (checkpoint position on Trail)-(Size of the Trail) + (RBA of the First record on next trail after the restart abended)
Procedure to get info about " (RBA of the First record on next trail after the restart abended)"
GGSCI (tnc63) 39> sh ls -ltr /opt/app/oval007p/ggs/trails/af*
-rw-r----- 1 ggs01 ggsoper 119194872 Apr 09 14:51 /opt/app/ggs/trails/af000047
-rw-r----- 1 ggs01 ggsoper 1980582 Apr 09 16:46 /opt/app/ggs/trails/af000048
./logdump
logdump> open /opt/app/ggs/trails/af000048
logdump> ghdr on
logdump> detail data
logdump> pos 0
logdump> n
2016/04/09 14:51:34.054.664 RestartAbend Len 0 RBA 1128
Name:
After Image: Partition 0 G s
Logdump>n
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 345 (x0159) IO Time : 2016/04/09 13:50:29.987.473
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 173237 AuditPos : 165583888
Continued : N (x00) RecCount : 1 (x01)
2016/04/09 13:50:29.987.473 Insert Len 345 RBA 1190
Name:
####
RBA= 119195676 - 119194872 + 1190 = 1994
Now Alter replicat with n+1 seq number and RBA
ggsci> alter repone, extseqno 48 extrba 1994
ggsci> start repone
Regards,
Nikhil Tatineni,
GoldenGate.
Querys to monitor RAC
following few Query's will help to find out culprits- Query to check long running transaction from last 8 hours Col Sid Fo...
-
syntax for skipping transaction # ggsci> start replicat skiptransaction GGSCI (red.gg.ora.com) 14> info all Program St...
-
scenario # trying to startup / shutdown database encountered with following error # ORA-24324: service handle not initialized ORA-243...
-
Today GoldenGate Extract abended on Servers During my initial investigation, goldengate error report says as follows 2016-02...