Ogg-02870 Missing Log File 〈NEWEST - 2025〉

ALTER REPLICAT <rep_name>, EXTSEQNO <last_good_seqno>, EXTRBA 0 If Extract is missing local trail but source DB logs are available, reposition Extract:

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

For :

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/aa* If missing, check if older/newer files exist:

ALTER EXTRACT <ext_name>, EXTSEQNO <next_seq_no>, EXTRBA 0 START EXTRACT <ext_name> Check current sequence numbers: ogg-02870 missing log file

EXTTRAIL /path/to/trail, MEGABYTES 2000, ROLLOVERHOURS 12 Use tar or rsync to copy old trail files to a backup location before they are deleted. 4.3 Monitor Trail Disk Space Set up alerts when trail directory usage exceeds 80%. 4.4 Use PURGEOLDEXTRACTS Safely In ./GLOBALS or parameter file:

ls -l /path/to/trail/dirdat/ | head -20 In GGSCI:

STOP REPLICAT REP1 ALTER REPLICAT REP1, EXTSEQNO 6, EXTRBA 0 START REPLICAT REP1 Verify with: BEGIN NOW START EXTRACT &lt

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

INFO EXTRACT <pump_name>, SHOWCH INFO REPLICAT <rep_name>, SHOWCH If Replicat is ahead of available trails, roll back sequence:

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