Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Integrated extract Fails : 01291

Yash SrivastavaJul 27 2015 — edited Jul 28 2015

Hi

I`m getting below error- How to fix it.

2015-07-27 19:19:36  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, eappsqat.prm:  Error code 1291, error message: ORA-01291: missing logfile

(Missing Log File <unknown>. Read Position SCN: Not available).

2015-07-27 19:19:36  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, eappsqat.prm:  PROCESS ABENDING.

I have tried below options, but nothing seems to be working.

ALTER EXTRACT EAPPSQAT , TRANLOG , BEGIN 2015-07-24 4:00:00

ALTER EXTRACT EAPPSQAT , BEGIN NOW

GGSCI  4> info EAPPSQAT , showch

EXTRACT    EAPPSQAT  Initialized   2015-07-24 17:30   Status STOPPED

Checkpoint Lag       13:30:32 (updated 77:28:55 ago)

Log Read Checkpoint  Oracle Integrated Redo Logs

                     2015-07-24 04:00:00

                     SCN 0.0 (0)

Current Checkpoint Detail:

Read Checkpoint #1

  Oracle Integrated Redo Log

  Startup Checkpoint (starting position in the data source):

    Timestamp: 2015-07-24 04:00:00.000000

    SCN: Not available

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):

    Timestamp: 2015-07-24 04:00:00.000000

    SCN: Not available

  Current Checkpoint (position of last record read in the data source):

    Timestamp: 2015-07-24 04:00:00.000000

    SCN: Not available

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2015
Added on Jul 27 2015
1 comment
1,046 views