ogg goldengate Extract: Could not find archived log…
Extract: Could not find archived log…Redo thread 2: Could not find archived log for sequence 5242 thread 2 under default destinations SQL <SELECT name FROM gv$archived_log WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND deleted = 'N>, error retrieving redo file name for sequence 5242, archived = 1, use_alternate = 0...
错误分析：
OGG会缺根据gv$archived_log查找归档日志位置.
可以通过参数指定归档日志目录
tranlogoptions PRIMARY altarchivelogdest instance ora1 /arch1, altarchivelogdest instance ora2 /arch2
配置该参数并加入primary选项可以避免Extract持续查询归档日志位置，降低对主库的压力，建议无论归档日志是否放在数据库中指定位置均应配置此参数
如果不是在共享存储，这样做是不是还需要把另外一个节点的日志也挂载到本地来，如果是rac环境 xwedison 发表于 2013-12-3 21:53 static/image/common/back.gif
如果不是在共享存储，这样做是不是还需要把另外一个节点的日志也挂载到本地来，如果是rac环境 ...
是的，要nfs过来，ogg需要所有节点的archivelog，但是可以屏蔽rac中的某个节点，比如rac1,rac2,rac3,rac4，你可以只复制rac1和rac3等等
页:
[1]