Oracle GoldenGate - Version 11.1.1.0.0 to 11.2.1.0.39 [Release 11.1.1 to 11.2]
How to reset the a GoldenGate trail sequence manually ?
SOLUTION
Steps to reset the sequence manually. This is resetting the trail file written by the pump. Instructions for resetting trails written by a log extract are similar and may be derived from the following information.
1)Stop the main extract
stop extract
2) Make sure that pump has read all the extract trail file generated by the main extract and is at the end of the last generated trail file and the lag is 0
SEND EXTRACT [pump_name], LOGEND
This should give the output as “YES”
3) Stop the pump
stop extract
4) Make sure that replicat has read all the extract trail file generated by the pump extract and is at the end of the last generated trail file and the lag is 0
SEND REPLICAT [replicat_name], LOGEND
This should give the output as “YES”
5)Stop the replicat
stop replicat
6) make a note of the the “info pump_name ,detail” output and “info replicat_name ,detail” as backup
7) backup all the trail files generated by the pump on the target server to a new folder and remove all the corresponding trail files on the target side and delete all the trail files generated by the pump on the target side ie for eg:- rm ./dirdat/el* on the target side (where replicat is running)
8) delete the rmttrail file of the pump extract
ex:- suppose the rmttrailfile name is ./dirdat/el
use ggsci> DELETE RMTTRAIL ./dirdat/el
9) Add back the rmttrail with the sequence 0 and rba 0
ex:- add rmttrail ./dirdat/el, megabytes 1000, seqno 0 , rba 0, extract test
10)make sure that the “info pump_name ,detail” output is showing trail file sequence as 0
11)start the extract
12) start the pump
13)point the replicat to the the first generated trail file by pump ie 0
alter replicat ,extseqno 0 , extrba 0
14) start the replicat
start replicat
NOTE:Manager PURGEOLDEXTRACTS USECHECKPOINTS may incorrectly purge sequences from 1000000 (1 million) as it deem to be sequence 0 and 1000001 to be 1, etc. on the target.
Starting in GoldenGate 12.1, we support trail sequences up to 9 digits instead of 6.
