Wednesday, February 4, 2015

OGG-00868 Error code 1291, error message: ORA-01291: missing logfile

OGG-00868 Error code 1291, error message: ORA-01291: missing logfile

When you are working on GoldenGate with INTEGRATED CAPTURE and you are missing some of the old archive logs; you can’t start the extract like classic capture; INTEGRATED CAPTURE will work differently; it will try to start from the registered SCN number or if it is running then you will provide all the old archive logs till the latest one;

Note: if you are missing some old archive logs then you have to rebuild the entire GG setup

You need to do the below activity

GGSCI> STOP EXTRACT E0000032
GGSCI> UNREGISTER EXTRACT E0000032 DATABASE
GGSCI> REGISTER EXTRACT E0000032 DATABASE
GGSCI> START EXTRACT E0000032
GGSCI> INFO E0000032

You should see the extract changing from STARTING to RUNNING STATE;

if you feel still it is not getting started; then you have to follow like below(wait for atleast 10 min, some time INTEGRATED CAPTURE would take time depending on your database load)

GGSCI> STOP EXTRACT E0000032
GGSCI> UNREGISTER EXTRACT E0000032 DATABASE
GGSCI> delete EXTRACT E0000032
GGSCI> REGISTER EXTRACT E0000032 DATABASE
GGSCI> ADD EXTRACT E0000032, INTEGRATED TRANLOG, BEGIN NOW, Description "Some details about extract"
GGSCI> ADD EXTTRAIL ./dirdat/app/ap, EXTRACT E0000032
GGSCI> START EXTRACT E0000032
GGSCI> INFO E0000032


If you have any issue, you can see the ggserr.log or view report <extract_name> would give more details about the error message.

Happy Reading :)