Ogg-02870 Missing Log File 【2026 Edition】

Then restart the Replicat/Extract:

INFO EXTRACT <extract_name> INFO REPLICAT <replicat_name> SEND EXTRACT <extract_name>, STATUS 3.1 Restore Missing Trail File (If Backed Up) If you have backup of the missing trail file (e.g., from archive or tape), restore it to the correct location and ensure proper permissions (same owner as GG process).

ls -l /path/to/trail/dirdat/ | head -20 In GGSCI: ogg-02870 missing log file

ALTER REPLICAT <rep_name>, EXTSEQNO <seq_no>, EXTRBA 0 START REPLICAT <rep_name> For (local or data pump) – if missing input trail:

ALTER EXTRACT <ext_name>, EXTSEQNO <next_seq_no>, EXTRBA 0 START EXTRACT <ext_name> Check current sequence numbers: Situation: Replicat REP1 fails with:

ALTER EXTRACT <ext_name>, BEGIN NOW START EXTRACT <ext_name> Or use specific timestamp/SCN:

START REPLICAT <rep_name> WARNING: Use only if you can afford to lose the transactions in the missing file. INFO REPLICAT &lt

PURGEOLDEXTRACTS /path/trail/dir/*, USECHECKPOINTS, MINKEEPDAYS 3 This keeps at least 3 days of trails. Situation: Replicat REP1 fails with: