Hi Experts,
I need help with getting an Oracle extract started.
It is an integrated extract running in a downstream database.
Due to missing archive log it was lagging behind. Yesterday I stopped the extracts/ replicats and sycned the source and destination databases using datapump flashback_scn.
After the sync is completed I am trying to start the extract from scn(flashback_scn) and it won't start.
alter extract ENDPRD_A scn 16421455756;
start extract ENDPRD_A ;
Error
2018-01-19 09:34:52 ERROR OGG-00868 Oracle GoldenGate Capture for Oracle, endprd_a.prm: Error code 1291, error message: ORA-01291: missing logfile
(Missing Log File /u01/app/oraclegg/fast_recovery_area/DOWNSTREAM/archivelog/2017_12_07/o1_mf_2_19811_f2mf3wby_.arc. Read Position SCN: 3.3536553868 (16421455756)).
2018-01-19 09:34:52 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, endprd_a.prm: PROCESS ABENDING
I am sure why it is looking at the old archive log which was missing since 07th of December. The scn -16421455756 is certainly latest and I validated in source database.
I even tried to start the extract from current and it is still failing
ALTER EXTRACT ENDPRD_A, BEGIN NOW
Even then it looks for the same missing archive log.
I am new to Golden Gate , please advise how do I force GG to just start moving forward .
Thanks
Aravind