Look for the or Current Log Sequence Number .
: The OGG checkpoint file, which tracks the last processed System Change Number (SCN), may be corrupted or pointing to an invalid position.
typically occurs when a Replicat or Extract process cannot find a required trail file (e.g., dirdat/aa000001 ). Common causes: ogg-02870 missing log file
Sometimes the registration information in the database becomes stale. You may need to STOP , UNREGISTER , and then REGISTER the Extract again.
INFO REPLICAT REP1
Ensure checkpoints are advancing.
ERROR OGG-02870 Missing log file: dirdat/aa000001. Look for the or Current Log Sequence Number
If Extract is missing local trail but source DB logs are available, reposition Extract:
In your Extract parameter file, leverage: ogg-02870 missing log file
ls -l /path/to/trail/dirdat/ | head -20
Run the following in GGSCI: