OGG怎么强制删除replicat

这篇文章主要介绍“OGG怎么强制删除replicat”,在日常操作中,相信很多人在OGG怎么强制删除replicat问题上存在疑惑,小编查阅了各式资料,整理出简单好用的操作方法,希望对大家解答”OGG怎么强制删除replicat”的疑惑有所帮助!接下来,请跟着小编一起来学习吧!

我们提供的服务有:成都网站建设、成都网站设计、微信公众号开发、网站优化、网站认证、木垒哈萨克ssl等。为上千企事业单位解决了网站和推广的问题。提供周到的售前咨询和贴心的售后服务,是有科学管理、有技术的木垒哈萨克网站制作公司

GGSCI (WINDOWS-0QO8SQ0) 6> dblogin userid system, password *****
Successfully logged into database.GGSCI (WINDOWS-0QO8SQ0) 7> delete rep2
ERROR: Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942: ta
ble or view does not exist (status = 942). Deleting from checkpoint table ggate.
checkpoint, group 'REP2', key 2986303197 (0xb1ff5edd), SQL eckpoint  WHERE group_name = 'REP2' AND        group_key  = 2986303197>).

GGSCI (WINDOWS-0QO8SQ0) 8> delete rep2 force
ERROR: Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942: ta
ble or view does not exist (status = 942). Deleting from checkpoint table ggate.
checkpoint, group 'REP2', key 2986303197 (0xb1ff5edd), SQL eckpoint  WHERE group_name = 'REP2' AND        group_key  = 2986303197>).

GGSCI (WINDOWS-0QO8SQ0) 9> delete replicat rep2!
WARNING: Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942:
table or view does not exist (status = 942). Deleting from checkpoint table ggat
e.checkpoint, group 'REP2', key 2986303197 (0xb1ff5edd), SQL checkpoint  WHERE group_name = 'REP2' AND        group_key  = 2986303197>).

GGSCI (WINDOWS-0QO8SQ0) 10> info allProgram     Status      Group       Lag at Chkpt  Time Since ChkptMANAGER     RUNNING
JAGENT      STOPPED
REPLICAT    RUNNING     REP1        00:00:00      00:00:01直接删除时,报错Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942.
因原OGG对应用户ggate已经被删除。
只好采用强制删除
delete replicat rep2!
通过惊叹号来进行强制删除

到此,关于“OGG怎么强制删除replicat”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注创新互联网站,小编会继续努力为大家带来更多实用的文章!


网站标题:OGG怎么强制删除replicat
分享URL:http://ybzwz.com/article/gphpii.html