OGG-00519 问题解决

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/