OGG-00519 问题解决
目标数据库错误:
2011-02-28 14:19:39 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rorabb.prm: Fatal error executing DDL replication: error [Error code [1435], ORA-01435: ?????, SQL ALTER SESSION SET CURRENT_SCHEMA=SWASBHOM ], no error handler present.
2011-02-28 14:19:39 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rorabb.prm: PROCESS ABENDING.
解决:
在复制进程脚本加上
DDL INCLUDE MAPPED
DDLERROR DEFAULT IGNORE RETRYOP
把进程修改成如下格式:
REPLICAT roraBB
userid userid gg,password gg
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/roraBB.DSC, PURGE,MAXBYTES 50000000
DDL INCLUDE MAPPED
DDLERROR DEFAULT IGNORE RETRYOP
MAP OWAS.*, TARGET OWAS.*;
MAPEXCLUDE OWAS.SYS_IMPORT_FULL_01, TARGET OWAS.SYS_IMPORT_FULL_01;
MAPEXCLUDE OWAS.SYS_EXPORT_SCHEMA_01, TARGET OWAS.SYS_EXPORT_SCHEMA_01;
然后重新启动进程。
参考:
http://blog.itpub.net/12778571/viewspace-688106/