问题描述: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
ogg目标库应用进程异常,告警OGG-00519、ORA-02443
原创
©著作权归作者所有:来自51CTO博客作者Liujun_Deng的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
OGG 监控AGENT 安装步骤
OGG OEM监控添加
oracle ogg 监控 -
ogg源端投递进程告警OGG-01496、OGG-01668
ogg源端投递进程告警OGG-01496、OGG-01668
OGG-01496 OGG-01668 -
ogg在启动应用进程时报错OGG-00412
ogg在启动应用进程时报错OGG-00412
Group bc 数据库oracle -
ogg在源端insert数据后,抽取进程出现OGG-00664、OGG-02078、OGG-02171异常
ogg在源端insert数据后,抽取进程出现OGG-00664、OGG-02078、OGG-02171异常
oracle OGG-00664 OGG-02078 OGG-02171 -
删除ogg用户表空间时告警ORA-00604、ORA-20782
删除ogg用户表空间时告警ORA-00604、ORA-20782
ORA-00604 ORA-20782 -
运用OGG同步异构数据库时OGG-01201、OGG-00936的异常处理
运用OGG同步异构数据库时OGG-01201、OGG-00936的异常处理
oracle mysql OGG-01201 OGG-00936 -
dockerconfigjson解码
docker是什么?docker是一个go语言开发的应用容器引擎。docker的作用?①运行容器里的应用;②docker是用来管理容器和镜像的一种工具。 容器 与 虚拟机 的区别?容器
dockerconfigjson解码 docker 容器 运维 centos