am196 发表于 2013-1-16 17:51:58

ogg replicat 不能删除

GGSCI (chnap-itd101) 29> delete replicat rep3
ERROR: Could not delete DB checkpoint for REPLICAT REP3 (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table gg_user.chkpt, group 'REP3', key 1049209657 (0x3e89ab39), SQL <DELETE FROM gg_user.chkpt  WHERE group_name = 'REP3' AND        group_key  = 1049209657>).


GGSCI (chnap-itd101) 30> dblogin userid gguser password gguser
Successfully logged into database.

GGSCI (chnap-itd101) 31> delete replicat rep3
ERROR: Could not delete DB checkpoint for REPLICAT REP3 (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table gg_user.chkpt, group 'REP3', key 1049209657 (0x3e89ab39), SQL <DELETE FROM gg_user.chkpt  WHERE group_name = 'REP3' AND        group_key  = 1049209657>).


GGSCI (chnap-itd101) 32> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    STOPPED     MSREP       00:00:00      405:59:17   
REPLICAT    RUNNING     REP1        00:00:00      00:00:08   
REPLICAT    STOPPED     REP3        00:00:00      524:50:24   


GGSCI (chnap-itd101) 33>

rep3 由于当是删除的时候，我是到数据库里面先删除对应的checkpoint表，
导致现在删除replicate rep3的时候报错。

我想这个应该是能够通过其它的方法让这个rep3不显示，或者把这个错误给处理的，
如果知道，帮我一下，不胜感激。

syhnd 发表于 2013-1-16 17:54:43

please review "My Checkpoint Table Is Corrupted. What Do I Do? "

am196 发表于 2013-1-16 19:00:07

syhnd 发表于 2013-1-16 17:54 static/image/common/back.gif
please review "My Checkpoint Table Is Corrupted. What Do I Do? "

没有该表了，我在数据库里面手工删除的。
页: [1]
查看完整版本: ogg replicat 不能删除