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
文章转载：http://mswzjz.cn/article/gphpii.html