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

Last updated on DECEMBER 02, 2019

Applies to:

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/<SID>/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/<SID>/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/<SID>/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/<SID>/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/<SID>/ARCHIVELOG/2018_05_12/thread_1_seq_15381.116992.975925091
...

Changes

Cause

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