GoldenGate Start Extract Command Failed with OGG-00868 ORA-01291: missing logfile

advertisements

_____________________________________________________________________________________________________________________

Error Description: 

GoldenGate start extract command getting abend and ggserr.log log shows the following error message.

2016-09-22 12:07:42  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, ext_pinf.prm:  Error code 1291, error message: ORA-01291: missing logfile
 (Missing Log File <unknown>. Read Position SCN: 0.34113731 (34113731)).
2016-09-22 12:07:42  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext_pinf.prm:  PROCESS ABENDING.

Solution Description: 

In this particular scenario there was archive log deletion happened in the primary database because of the space crunch issues. Some of the archive logs which is not applied in target replication site is also got deleted. Because of this reason the start extract process was failing with this error. You need to unregister the extract and re-register to solve the issue. Steps are mentioned below. 1. Connect to the database using ggsci.

GGSCI (Node 1 as ggs_owner@ONLINEDB2) 27> dblogin UserID ggs_owner@onlinedb password ggs_owner
Successfully logged into database.

2. Stop the extract. Mostly the extract might be already stopped.

GGSCI (Node 1 as ggs_owner@ONLINEDB2) 28> stop extract EXT_PINF
EXTRACT EXT_PINF is already stopped.

GGSCI (Node 1 as ggs_owner@ONLINEDB2) 29> info EXT_PINF

EXTRACT    EXT_PINF  Last Started 2016-08-03 06:51   Status ABENDED
Checkpoint Lag       96:49:38 (updated 970:40:30 ago)
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2016-08-09 00:40:01
                     SCN 0.34113731 (34113731)

3. Unregister the extract

GGSCI (Node 1 as ggs_owner@ONLINEDB2) 30> unregister extract EXT_PINF database;

2016-09-22 12:10:53  INFO    OGG-01750  Successfully unregistered EXTRACT EXT_PINF from database.

4. Re register the extract

GGSCI (Node 1 as ggs_owner@ONLINEDB2) 31> register extract EXT_PINF database;

2016-09-22 12:12:06  INFO    OGG-02003  Extract EXT_PINF successfully registered with database at SCN 66350791.

5. Strat the extract

GGSCI (Node 1 as ggs_owner@ONLINEDB2) 32> start extract EXT_PINF

Sending START request to MANAGER ...
EXTRACT EXT_PINF starting

GGSCI (Node 1 as ggs_owner@ONLINEDB2) 33> info extract EXT_PINF

EXTRACT    EXT_PINF  Last Started 2016-09-22 12:13   Status RUNNING
Checkpoint Lag       1067:33:11 (updated 00:00:04 ago)
Process ID           30514
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2016-08-09 00:40:01

                     SCN 0.34113731 (34113731)

_____________________________________________________________________________________________________________________

Website Stats