Goldengate IE Abend- OGG-00868 Error Code 1291, Error Message: ORA-01291: Missing Logfile
Last updated on JUNE 26, 2018
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms