ogg目标库应用进程异常,告警OGG-00519、ORA-02443

时间:2022-12-14 20:58:10
问题描述:ogg目标库应用进程异常,告警OGG-00519、ORA-02443,如下所示:
场景说明:源端表中存在一个约束,约束名为系统自定义,该约束在目标端未能查找,所以便在源库将其删除,结果就出现目标端应用进程异常.
源端ogg软件:fbo_ggs_Linux_x64_ora10g_64bit.tar
目标端ogg软件:191004_fbo_ggs_Linux_x64_shiphome.zip
异常重现:
2022-12-12 18:12:25 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [2443], ORA-02443: Cannot drop constraint - nonexistent constraint
], no error handler present.

GGSCI (leo-19c-ogg as ogg@simdb) 10> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT ABENDED REP1 00:00:00 00:03:34

解决过程:
--修改应用进程参数
GGSCI (leo-19c-ogg as ogg@simdb) 11> edit param rep1
--原参数
DDLERROR 942 IGNORE
--修改为
DDLERROR DEFAULT IGNORE RETRYOP
--全部参数如下:
GGSCI (leo-19c-ogg as ogg@simdb) 9> view param rep1
REPLICAT rep1
setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
--setenv (ORACLE_SID=)
userid ogg@SIMDB,password ogg
REPORT AT 08:59
REPORTCOUNT EVERY 30 MINUTES, RATE
CACHEMGR CACHESIZE 2048MB,CACHEDIRECTORY /u01/app/ogg/dirtmp
REPERROR DEFAULT, ABEND
DISCARDFILE /u01/app/ogg/dirrpt/rep1.dsc, APPEND, MEGABYTES 1024
DISCARDROLLOVER AT 3:00
GETTRUNCATES
ALLOWNOOPUPDATES
APPLYNOOPUPDATES
ASSUMETARGETDEFS
DBOPTIONS DEFERREFCONST
DBOPTIONS SUPPRESSTRIGGERS
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DDLERROR 942 IGNORE
MAP SCOTT.* TARGET SCOTT.*;
GGSCI (leo-19c-ogg as ogg@simdb) 12> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT ABENDED REP1 00:00:00 00:04:10

GGSCI (leo-19c-ogg as ogg@simdb) 13> start rep1

Sending START request to MANAGER ...
REPLICAT REP1 starting

GGSCI (leo-19c-ogg as ogg@simdb) 14> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT RUNNING REP1 00:06:09 00:00:00

参考文档:https://blog.csdn.net/u010098331/article/details/51473298