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:Oracle GoldenGate - Version 184.108.40.206.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/<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
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