My Oracle Support Banner

New Integrated Extract Abends Due To Missing Logfile (Doc ID 1633564.1)

Last updated on DECEMBER 20, 2018

Applies to:

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


After unregistering and recreating an integrated capture extract, extract abends due to trying to read SCN 0
2014-03-08 14:09:40  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, e4pmt2a3.prm:  Error code 1291, error message: ORA-01291: missing logfile
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 1682
ORA-06512: at "SYS.DBMS_CAPTURE_PROCESS", line 702
ORA-06512: at line 1
 (Missing Log File <unknown>. Read Position SCN 0).
2014-03-08 14:09:40  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, e4pmt2a3.prm:  PROCESS ABENDING.

why would logmnr be looking for scn 0
CAPTURE OGG$CAP_E4PMT2A3: Start SCN: 12080484120274 (0xb4f6f6d2.00000afc)
CAPTURE OGG$CAP_E4PMT2A3: First SCN: 12080484120274 (0xb4f6f6d2.00000afc)
CAPTURE OGG$CAP_E4PMT2A3: Required Checkpoint SCN: 0 (0x0000.00000000)
CAPTURE OGG$CAP_E4PMT2A3: Captured SCN: 12080484120274 (0xb4f6f6d2.00000afc)
CAPTURE OGG$CAP_E4PMT2A3: Applied SCN: 0 (0x0000.00000000)


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

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