STOP REPLICAT REP1 ALTER REPLICAT REP1, EXTSEQNO 6, EXTRBA 0 START REPLICAT REP1 Verify with:
ALTER EXTRACT <ext_name>, EXTSEQNO <next_seq_no>, EXTRBA 0 START EXTRACT <ext_name> Check current sequence numbers:
For :
ls -l /path/to/trail/dirdat/aa* If missing, check if older/newer files exist:
ERROR OGG-02870 Missing log file: dirdat/aa000001. 2.1 Identify Missing File From the error message, note the trail file name and path (e.g., dirdat/aa000001 ). 2.2 Verify File Existence Go to the GoldenGate dirrpt or trail directory:
ALTER EXTRACT <ext_name>, BEGIN NOW START EXTRACT <ext_name> Or use specific timestamp/SCN:
Ogg-02870 Missing - Log File
STOP REPLICAT REP1 ALTER REPLICAT REP1, EXTSEQNO 6, EXTRBA 0 START REPLICAT REP1 Verify with:
ALTER EXTRACT <ext_name>, EXTSEQNO <next_seq_no>, EXTRBA 0 START EXTRACT <ext_name> Check current sequence numbers: ogg-02870 missing log file
For :
ls -l /path/to/trail/dirdat/aa* If missing, check if older/newer files exist: STOP REPLICAT REP1 ALTER REPLICAT REP1, EXTSEQNO 6,
ERROR OGG-02870 Missing log file: dirdat/aa000001. 2.1 Identify Missing File From the error message, note the trail file name and path (e.g., dirdat/aa000001 ). 2.2 Verify File Existence Go to the GoldenGate dirrpt or trail directory: STOP REPLICAT REP1 ALTER REPLICAT REP1
ALTER EXTRACT <ext_name>, BEGIN NOW START EXTRACT <ext_name> Or use specific timestamp/SCN: