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

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

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)

Cause

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