Oracle Goldengate升级到11.1.1.1.1后,解决了前期频繁出现的一些错误,但是又出现了新的错误。
2011-11-11 16:54:03 WARNING OGG-00455 Oracle GoldenGate Capture for Oracle, ext2.prm: Problem in resolving [xxx.tab_xxx]: ORA-21780: Maximum number of object durations exceeded., try to fix this issue in order to avoid possible fatal error.
2011-11-11 16:54:03 ERROR OGG-00521 Oracle GoldenGate Capture for Oracle, ext2.prm: Object was resolved, however in the same resolution call both DDL history and database metadata resolution failed, cannot recover, SCN [2777663572], object id [56041].
2011-11-11 16:54:05 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext2.prm: PROCESS ABENDING.
造成错误的原因是OGG 11.1.1.1.1中引入的一个自动开启特性 — logretention,这个特性触发了bug 12732996。
LOGRETENTION主要功能是防止rman删除ogg恢复所需要用到的归档日志,可以通过禁用这个特性来解决上面的这个问题。
ggsci> stop ext2
ggsci> dblogin userid xx password xx
ggsci> unregister extract ext2 logretention
ggsci> edit params ext2TRANLOGOPTIONS LOGRETENTION DISABLED — add
ggsci> start ext2