Golden Gate Checkpoint Table Error: Could not Delete DB Checkpoint for REPLICAT

Recently while we were working on goldengate configuration on Exadata we faced below error while deleting the replicate process. Hope it will help you.

ERROR


GGSCI (dm01) 4> delete replicat EXREP1

ERROR: Could not delete DB checkpoint for REPLICAT EXREP1 (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.checkpointtable, group 'EXREP1', key 3261899073 (0xc26ca141), SQL <DELETE FROM ogg.checkpointtable  WHERE group_name = 'EXREP1' AND     group_key  = 3261899073>).

After getting above error we have checked whether EXREP1 has been deleted or not, but because of above error it has not been deleted.


GGSCI (dm01) 6> info all


Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT     STOPPED     EXREP1     00:00:00      00:00:01


Solution

While deleting specify ! argument as well to remove replicat process.


GGSCI (dm01) 5>  delete replicat EXREP1 !

WARNING: Could not delete DB checkpoint for REPLICAT EXREP1 (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.checkpointtable, group 'EXREP1', key 3261899073 (0xc26ca141),SQL <DELETE FROM ogg.checkpointtable  WHERE group_name = 'EXREP1' AND        group_key  = 3261899073>).

Now you can seen in info all, EXREP1 process has been deleted successfully.

GGSCI (dm01) 6> info all


Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING


1 comment:

  1. Thank you for your post! I couldn't find info on this override option until I stumble on your site.

    ReplyDelete