重庆思庄Oracle、Redhat认证学习论坛

标题: ogg目标库应用进程异常，告警OGG-00519、ORA-02443 [打印本页]

作者: denglj 时间: 2022-12-30 13:28
标题: 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-1218:12:25 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [2443],ORA-02443: Cannot drop constraint -nonexistent constraint

], noerror 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

--原参数

DDLERROR942 IGNORE

--修改为

DDLERRORDEFAULT IGNORE RETRYOP

--全部参数如下：

GGSCI(leo-19c-ogg as ogg@simdb) 9> view param rep1

REPLICATrep1

setenv(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

--setenv(ORACLE_SID=)

useridogg@SIMDB,password ogg

REPORTAT 08:59

REPORTCOUNTEVERY 30 MINUTES, RATE

CACHEMGRCACHESIZE 2048MB,CACHEDIRECTORY /u01/app/ogg/dirtmp

REPERRORDEFAULT, ABEND

DISCARDFILE/u01/app/ogg/dirrpt/rep1.dsc, APPEND, MEGABYTES 1024

DISCARDROLLOVERAT 3:00

GETTRUNCATES

ALLOWNOOPUPDATES

APPLYNOOPUPDATES

ASSUMETARGETDEFS

DBOPTIONSDEFERREFCONST

DBOPTIONSSUPPRESSTRIGGERS

DDLINCLUDE MAPPED

DDLOPTIONSREPORT

DDLERROR942 IGNORE

MAPSCOTT.* 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

SendingSTART request to MANAGER ...

REPLICATREP1 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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)