Missing Log File ((new)) | Ogg-02870

Use only if you can afford to lose the transactions in the missing file.

OGG-02028 Oracle GoldenGate Capture for Oracle, ext_scrr.prm

: In Integrated mode, the Extract may not be correctly registered with the database, causing it to lose track of the SCN (System Change Number) it needs to start from. Oracle Help Center Resolution Steps Restore the Log File

ls -l /path/to/trail/dirdat/ | head -20

For Integrated Extract, you may need to manually register the archive logs at the database level if they weren't picked up automatically:

: Enable the LOGRETENTION parameter in the Extract to ensure the database knows which logs are still needed for capture.

ls -la /path/to/archive/destination/

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

ALTER REPLICAT <rep_name>, EXTSEQNO <seq_no>, EXTRBA 0 START REPLICAT <rep_name>

ALTER EXTRACT <ext_name>, EXTSEQNO <next_seq_no>, EXTRBA 0 START EXTRACT <ext_name> ogg-02870 missing log file

: This often requires a fresh initial load to ensure data consistency between source and target. Skip Missing Logs

In GGSCI: