Scenario:

There was a missing archive log error and we need to change the archive log location for integrated capture process in Goldengate.

Error :

ERROR OGG-00868 Error code 1291, error message: ORA-01291: missing logfile

(Missing Log File WAITING FOR DICTIONARY REDO. Read Position SCN: 0.46921993 (46921993)).

Solution:

If it is integrated, and facing issue with missing archive log file….

You can use 3) Register the archive logs for the capture process.

SQL> Alter database register logical logfile “/<path to logfile>/logfilename> for “OGG Capture

Reference :

https://www.ateam-oracle.com/oracle-goldengate-extract-recovery-missing-archivelogs

Recent Posts

Start typing and press Enter to search