oracle ogg 删除,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

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)