您好,登录后才能下订单哦!
数据库版本:oracle 11.2.0.4
今天教一新手使用oracle 11.2.0.4 ogg 12.3.0.1.0做数据同步,其部署过程不规范,备库未对goldengate用户做checkpoint表,导致备库的引用进程启动不了。
rep_hr的参数:
rep_hr的状态
GGSCI (ZB as goldengate@ora) 26> info rep_hr
REPLICAT REP_HR Initialized 2017-10-29 19:18 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:09:29 ago)
Log Read Checkpoint File /u01/app/oracle/OGG/product/dirdat/et000000000
First Record RBA 0
GGSCI (ZB as goldengate@ora) 27>
rep_hr启动报错信息如下:
ERROR OGG-00446在初始化中出现的解决方法报错信息已经提到,处理过程如下:
GGSCI (ZB as goldengate@ora) 45> start rep_hr
Sending START request to MANAGER ...
REPLICAT REP_HR starting
GGSCI (ZB as goldengate@ora) 46> ADD CHECKPOINTTABLE
ERROR: Missing checkpoint table specification.
GGSCI (ZB as goldengate@ora) 47> ADD CHECKPOINTTABLE goldengate.checkpoint
Successfully created checkpoint table goldengate.checkpoint.
GGSCI (ZB as goldengate@ora) 48> start rep_hr
Sending START request to MANAGER ...
REPLICAT REP_HR starting
GGSCI (ZB as goldengate@ora) 49> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_HR 00:00:00 00:00:00
GGSCI (ZB as goldengate@ora) 50>
GGSCI (ZB as goldengate@ora) 45> start rep_hr
Sending START request to MANAGER ...
REPLICAT REP_HR starting
GGSCI (ZB as goldengate@ora) 49> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_HR 00:00:00 00:00:00
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。