Ogg-02870 Missing Log File Official

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

Then restart the Replicat/Extract:

INFO EXTRACT <pump_name>, SHOWCH INFO REPLICAT <rep_name>, SHOWCH If Replicat is ahead of available trails, roll back sequence: ogg-02870 missing log file

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

ls -l /path/to/trail/dirdat/ | head -20 In GGSCI: roll back sequence: START REPLICAT &lt

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

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