Oracle19COGG基础运维-04DML同步常见问题-创新互联

Oracle 19C OGG基础运维-04DML同步常见问题

站在用户的角度思考问题,与客户深入沟通,找到珠海网站设计与珠海网站推广的解决方案,凭借多年的经验,让设计与互联网技术结合,创造个性化、用户体验好的作品,建站类型包括:做网站、成都网站制作、企业官网、英文网站、手机端网站、网站推广、域名与空间、网络空间、企业邮箱。业务覆盖珠海地区。

一:源端添加检查点失败

错误: No checkpoint table specified. Using GLOBALS specification c##ogg.ggschkpt...

GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 2> ADD CHECKPOINTTABLE 

No checkpoint table specified. Using GLOBALS specification c##ogg.ggschkpt...

ERROR: Catalog name is missing from checkpoint table specification c##ogg.ggschkpt.

解决方案: 用户前指定数据库名

GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 2> ADD CHECKPOINTTABLE CDB$ROOT.c##ogg.ggschkpt

二:启动抓取进程ext_01失败

错误: Classic Extract does not support multitenant container databases.

[oracle@cjcos01 ogg]$ tail -f ggserr.log 

......

2020-04-09T13:29:22.503+0800  ERROR   OGG-06220  Oracle GoldenGate Capture for Oracle, ext_01.prm:  Classic Extract does not support multitenant container databases.

2020-04-09T13:29:22.582+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext_01.prm:  PROCESS ABENDING.

解决方案: 添加ext_01时指定INTEGRATED

添加抽取进程

---add extract ext_01,tranlog,begin now

---delete extract ext_01 

ADD EXTRACT ext_01,INTEGRATED TRANLOG,BEGIN NOW

三:添加pump进程失败

错误: ERROR: Invalid group name (must be at most 8 characters).

GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 10> add extract extpump_01,exttrailsource /ogg/dirdat/rt

ERROR: Invalid group name (must be at most 8 characters).

解决方案: 进程名不能大于8个字符,将extpump_01改成pump_01

GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 10> add extract pump_01,exttrailsource /ogg/dirdat/rt

四:启动应用进程rep_01失败

错误: Checkpoint table chenpdb.ogg.checkpoint does not exist

2020-04-09T13:49:54.378+0800  ERROR   OGG-00446  Oracle GoldenGate Delivery for Oracle, rep_01.prm:  Checkpoint table chenpdb.ogg.checkpoint does not exist. Create this table with the ADD CHECKPOINTTABLE command.

解决方案 : 

检查在设置./GLOBALS时表名为chenpdb.ogg.ggschkpt,添加rep_01进程时错写成了chenpdb.ogg.ggschkpt,导致后来启动rep_01失败,删除rep_01重新添加即可

add replicat rep_01,exttrail /ogg/dirdat/mb, CHECKPOINTTABLE chenpdb.ogg.ggschkpt

欢迎关注我的微信公众号"IT小Chen",共同学习,共同成长!!!

Oracle 19C OGG基础运维-04DML同步常见问题


分享题目:Oracle19COGG基础运维-04DML同步常见问题-创新互联
分享链接:http://myzitong.com/article/ghiod.html