Please check ggerror.log file :--- LONG RUNNING TRANSACTION issue in Oracle GoldenGate
GGS WARNING 190 Oracle GoldenGate Capture for Oracle, extgrp1.prm: Long Running Transaction: XID 313.5.780269, Items 3, Extract EXTGRP1, Redo Thread 1, SCN 2912.2575963070 (12509520729022), Redo Seq #147217, Redo RBA 150735888.
To FIX:
*Monitor and see if the LRT will clear on its own. If a lag starts to happen and it reaches 30 minutes then perform the following step to skip the transaction.*
send extgrp1 skiptrans 313.5.780269
extgrp1:- GG extract process name
skiptrans:- keyword
313.5.780269:-- LRT
GGS WARNING 190 Oracle GoldenGate Capture for Oracle, extgrp1.prm: Long Running Transaction: XID 313.5.780269, Items 3, Extract EXTGRP1, Redo Thread 1, SCN 2912.2575963070 (12509520729022), Redo Seq #147217, Redo RBA 150735888.
To FIX:
*Monitor and see if the LRT will clear on its own. If a lag starts to happen and it reaches 30 minutes then perform the following step to skip the transaction.*
send extgrp1 skiptrans 313.5.780269
extgrp1:- GG extract process name
skiptrans:- keyword
313.5.780269:-- LRT
No comments:
Post a Comment