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

2015-07-13 22:08:35 暂无评论奇妙冰淇淋随笔杂文 2,767

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

…

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为抽取进程的名字.

声明: 除非转自他站（如有侵权，请联系处理）外，本文采用 BY-NC-SA 协议进行授权 | 智乐兔
转载请注明：转自《OGG-00446goldengate抽取进程找不到相应的归档日志的解决方案》
本文地址：https://www.zhiletu.com/archives-290.html
关注公众号：