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:

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

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). ALTER REPLICAT &lt

ALTER EXTRACT <ext_name>, EXTSEQNO <next_seq_no>, EXTRBA 0 START EXTRACT <ext_name> Check current sequence numbers: EXTRBA 0 START REPLICAT &lt

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: