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>