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
转载于:https://blog.51cto.com/yiqiuyu/1580860