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

This error is related with the missing of Logfile ( Archived log ) for this extract process.

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

 2,326 views last month,  3 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply