**一、背景描述

在测试OGG双向同步时，在目标端配置了应用进程，在启动应用进程时发现有报错，打算删除该应用进程，在执行delete REPLICAT rtb删除时报如下错误，导致无法删除。

ERROR: Could not delete DB checkpoint for REPLICAT RTB (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.chkpoint, group ‘RTB’, key 3883182186 (0xe774a86a), SQL ).

使用force也同样报错：

GGSCI (xsky-node4) 34> delete rtb force
ERROR: Could not delete DB checkpoint for REPLICAT RTB (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.chkpoint, group ‘RTB’, key 3883182186 (0xe774a86a), SQL ).

二、解决办法

通过查阅资料，添加 ！ 符合可以删除

GGSCI (xsky-node4) 38> delete replicat rtb !
WARNING: Could not delete DB checkpoint for REPLICAT RTB (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.chkpoint, group ‘RTB’, key 3883182186 (0xe774a86a), SQL ).

GGSCI (xsky-node4) 39> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING DPA 00:00:00 00:00:04
EXTRACT RUNNING EXA 00:00:00 00:00:05

此时再没rtb那个replicat进程了。

真的没想到通过 添加 ！ 感叹号可以删除，又学到一招,特此记录下。