OGG-02870 Missing Log File WAITING FOR DICTIONARY REDO

Sometimes You can get ” OGG-02870 Missing Log File WAITING FOR DICTIONARY REDO” in Goldengate during start Extract Process.

OGG-02870 Missing Log File WAITING FOR DICTIONARY REDO

Details of error are as follows.

2021-02-08 12:24:55 ERROR OGG-02870 Missing Log File WAITING FOR DICTIONARY REDO. Read Position SCN: Unknown.

2021-02-08 12:24:55 ERROR OGG-01668 PROCESS ABENDING.

Missing Log File WAITING FOR DICTIONARY REDO. Read Position SCN: Unknown

ERROR OGG-00868 Error code 1291, error message: ORA-01291: missing logfile
(Missing Log File WAITING FOR DICTIONARY REDO. Read Position SCN: 2105.1138542438 (9042044700518)).

Customer as per below query using SCN mentioned in the OGG error restored and registered the archived log seqno 7432 using RMAN:

- select * from v$archived_log where first_change# >= 9042044700518 and deleted = 'YES';
- select * from dba_registered_archived_log where first_scn = 9042044700518

How can I get my Extract running again?

As seen below the recovery checkpoint was at archived log seqno 7431, where as customer restored archived log with seqno 7432:

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
  Thread #: 1
  Sequence #: 7431        <==============
  RBA: 2435876056
  Timestamp: 2021-02-08 16:34:35.000000
  SCN: 2105.1138541736 (9042044699816)
  Redo File: Not Available
 

Current Checkpoint (position of last record read in the data source):
Thread #: 0
Sequence #: 0
RBA: 0
Timestamp: 2021-02-08 16:36:25.000000
SCN: 2105.1138542438 (9042044700518)
Redo File: Not Available

To solve this error, Restore archived log with seqno 7431 helped restarting the extract.

RMAN> RESTORE ARCHIVELOG FROM SEQUENCE 7431 UNTIL SEQUENCE 7480;

Restart the OGG extract, it will work fine.

GGSCI> Start extract <OGG extract name>

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

Oracle Goldengate Tutorials for Beginners