Goldengate复制进程错误Fatal error executing DDL

目标数据库错误：

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;

 

然后重新启动进程。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12778571/viewspace-688106/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12778571/viewspace-688106/