OGG怎么强制删除replicat

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

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 <DELETE FROM ggate.ch
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 <DELETE FROM ggate.ch
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 <DELETE FROM ggate.
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”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！