OGG-00446goldengate抽取进程找不到相应的归档日志的解决方案

OGG-00446 Could not find archived log for sequence 23 thread 1 under default destinations
2011-11-09 16:54
GGSCI (node) 37> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING

EXTRACT     ABENDED     EORAKK      50:41:54      01:23:10

GGSCI (node) 38> view report eorakk

…

2011-11-05 23:05:31  ERROR   OGG-00446  Could not find archived log for sequence 23 thread 1 under default destinationsSQL <SELECT  name    FROM v$archived_log   WHERE sequence# = :ora_seq_no AND         thread# = :ora_thread A

ND         resetlogs_id = :ora_resetlog_id AND         archived = ‘YES’ AND         deleted = ‘NO>, error retrievi

ng redo file name for sequence 23, archived = 1, use_alternate = 0Not able to establish initial position for seque

nce 23, rba 5577232.

2011-11-05 23:05:31  ERROR   OGG-01668  PROCESS ABENDING.

原因是extract 所需的archived log已经被清走，不在log_archive_dest指定的目录下.有两个：

1，  只要把sequence 从10770开始到当前的archived log重新拷贝回log_archive_dest目录下即可。

2，  在ggsci命令行下执行：alter extract eorakk begin now(个人感觉此操作相当于清除extract进程对以前产生的redo的依赖)。

注意第2个解决方案中 eorakk为抽取进程的名字.