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 :)
