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)