Could not find archived log for sequence 1 thread 2 under default destinations SQL
ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extjms2.prm: Could not 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>, error retrieving redo file name for sequence 1, archived = 1, use_alternate = 0Not able to establish initial position for begin time 2014-11-21 11:08:09.
由于线程2为1的归档日志已经被删除，导致goldengate 抽取进程停止：
解决方法：
1、恢复删除的归档日志，重新启动抽取进程；
RMAN>restore archivelog from logseq 1 until logseq 2;
GGSCI>start extjms2
2、通过v$archived_log查询到下个日志的时间点，重新指定抽取进程的时间点,启动抽取进程；
GGSCI>alter extract extjms2 ,begin 2014-11-20 00:20:15
GGSCI>start extjms2
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
