Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replication stopped after removing trail files

LazyOraDBAApr 3 2013 — edited Apr 12 2013
Hi All,

OGG Schema replication was working fine but remote trail filesystem got filled.

So I removed remote trail files manually and performed initial load and encountered below error while starting extract.
ERROR   OGG-01496  Oracle GoldenGate Capture for Oracle, xxx.prm:  Failed to open target trail file /u/gg/trail/rt008256, at RBA 7456937.
2013-03-18 08:17:20  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, xxx.prm:  PROCESS ABENDING.
I started extract using this command.
 ALTER EXTRACT <group name>, ETROLLOVER 
Extract and replicat process are up and running but replication stopped. getting below info in logs:

Source Side:
INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, xxx.prm:  Rolling over remote file /u/gg/trail/rt010838.
Target Side:
INFO    OGG-01669  Oracle GoldenGate Collector:  Opening /u/gg/trail/rt010838 (byte -1, current EOF 0).
Now added this line in mgr for purging trail files.
PURGEOLDEXTRACTS /u/gg/trail/rt, USECHECKPOINTS, MINKEEPDAYS 2
unable to understand as to why replication stopped ??


Thanks & Regards,

Edited by: LazyDBA11g on Apr 11, 2013 10:46 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2013
Added on Apr 3 2013
1 comment
2,200 views