ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, Extjms2.prm:Could don't find archived log for sequence 1 thread 2 Under Default destinations SQL <select name from V$archived_log WHERE sequence# =: ora_seq_no and Thread # =: Ora_thread and resetlogs_id =: ora_resetlog_id and archived = ' YES ' and deleted = ' no>, er Ror retrieving Redo file name for sequence 1, archived = 1, use_alternate = 0Not able to establish initial position Gin Time 2014-11-21 11:08:09.
The goldengate extraction process is stopped because the archive log for thread 2 is 1 has been deleted:
Workaround:
1, restore the deleted archive log, restart the extraction process;
Rman>restore Archivelog from Logseq 1 until Logseq 2;
Ggsci>start EXTJMS2
2, through the V$archived_log query to the next log point in time, re-specify the time point of the extraction process, start the extraction process;
Ggsci>alter extract extjms2, begin 2014-11-20 00:20:15
Ggsci>start EXTJMS2
Could not find archived log for sequence 1 thread 2 under Default destinations SQL