Tuesday, April 12, 2016

ERROR OGG-01705 Input checkpoint position 119195676...

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...