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 all


Program     Status      Group       Lag at Chkpt  Time Since Chkpt


MANAGER     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!
通过惊叹号来进行强制删除

参考：http://ranjitnagi.blogspot.com/2013/01/gg-checkpoint-table-errorerror-could.html
         http://chandu208.blogspot.com/2015/02/error-could-not-delete-db-checkpoint.html


<1h3 class="post-title entry-title" "="" style="font-weight: normal;padding: 0px;-webkit-tap-highlight-color: rgba(0, 0, 0, 0);position: relative;font-stretch: normal;font-size: 28px;line-height: normal">ERROR: Could not delete DB checkpoint for REPLICATDB version:   11.2.0.2.0OGG version:   11.2.1.0.3OS Version:  RHEL 6GGSCI (oracledev10) 10>  delete Replicat REP ERROR: Could not delete DB checkpoint for REPLICAT REP (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ggs_admin.ggchkpt, group 'REP', key 2292316344 (0x88a1f8b8), SQL ). The  above error was due to REPLICAT process added without specifying NODBCHECKPOINT argument when it got created initially. Solution:  Try deleting with "!" optionGGSCI (oracledev10) 12>  delete replicat REP ! WARNING: Could not delete DB checkpoint for REPLICAT REP (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ggs_admin.ggchkpt, group 'REP', key 2292316344 (0x88a1f8b8), SQL ).Replicat REP Deleted now
Here, The “!” tells GoldenGate to ignore the checkpoint tableIf we wish to create Replicat  without checkpoint then use below command to create ADD REPLICAT , EXTTRAIL , NODBCHECKPOINTIf we want to create Replicat  WITH checkpoint then use below command to create ADD CHECKPOINTTABLE ggs_admin.ggchkpt          ( create if not exists) ADD REPLICAT , EXTTRAIL ,  CHECKPOINTTABLE ggs_admin.ggchkpt

Refer: How Can I Delete A REPLICAT Created Without A Checkpoint Table? (Doc ID 965689.1)

链接：http://blog.itpub.net/8520577/viewspace-2119349/