My Oracle Support Banner

Goldengate IE Abend- OGG-00868 Error Code 1291, Error Message: ORA-01291: Missing Logfile (Doc ID 2401892.1)

Last updated on JUNE 26, 2018

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

Customer's mount point filled up where Goldengate keeps its trail files, after cleanup starting Integrated Extract was encountering missing archive log:

2018-05-13 08:32:13 ERROR OGG-00868 Error code 1291, error message: ORA-01291: missing logfile
 (Missing Log File WAITING FOR DICTIONARY REDO: FILE +RECOC1/CDBPD2/ARCHIVELOG/2018_05_12/thread_1_seq_15378.118735.975916859, THREAD 1, SEQUENCE 15378,
SCN 0x0572.c2f70b8b. Read Position SCN: 1394.3270970253 (5990455380877)).
2018-05-13 08:32:13 ERROR OGG-01668 PROCESS ABENDING.



However the archivelogs  were present as seen here via RMAN below:

RMAN> RESTORE ARCHIVELOG FROM SEQUENCE 15378 UNTIL SEQUENCE 15390;
Starting restore at 13-MAY-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2431 device type=DISK
archived log for thread 1 with sequence 15378 is already on disk as file +RECOC1/CDBPD2/ARCHIVELOG/2018_05_12/thread_1_seq_15378.118735.975916859
archived log for thread 1 with sequence 15379 is already on disk as file +RECOC1/CDBPD2/ARCHIVELOG/2018_05_12/thread_1_seq_15379.118232.975919263
archived log for thread 1 with sequence 15380 is already on disk as file +RECOC1/CDBPD2/ARCHIVELOG/2018_05_12/thread_1_seq_15380.117694.975921673
archived log for thread 1 with sequence 15381 is already on disk as file +RECOC1/CDBPD2/ARCHIVELOG/2018_05_12/thread_1_seq_15381.116992.975925091
...

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.