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

问题描述：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