Saturday, February 14, 2015

ERROR: Could not delete DB checkpoint for REPLICAT

DB version:  11.2.0.2.0
OGG version:  11.2.1.0.3
OS Version: RHEL 6

GGSCI (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 <DELETE FROM ggs_admin.ggchkpt  WHERE group_name = 'REP' AND        group_key  = 2292316344>).

The  above error was due to REPLICAT process added without specifying NODBCHECKPOINT argument when it got created initially.

Solution:  Try deleting with "!" option

GGSCI (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 <DELETE FROM ggs_admin.ggchkpt  WHERE group_name = 'REP' AND        group_key  = 2292316344>).

Replicat REP Deleted now

Here, The “!” tells GoldenGate to ignore the checkpoint table

If we wish to create Replicat without checkpoint then use below command to create

ADD REPLICAT <group>, EXTTRAIL <trail>, NODBCHECKPOINT


If we want to create Replicat WITH checkpoint then use below command to create
ADD CHECKPOINTTABLE ggs_admin.ggchkpt          (create if not exists)

ADD REPLICAT <group>, EXTTRAIL <trail>,  CHECKPOINTTABLE ggs_admin.ggchkpt


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

1 comments:

21cssIndia said...

Oracle RAC DBA --- "
Oracle RAC DBA Online Training

Send ur Enquiry to contact@21cssindia.com
Introduction to Real Application Clusters
What is Cluster
Types of Cluster & Cluster products
Oracle Grid Infrastructure principles and Purpose" more… Online Training- Corporate Training- IT Support U Can Reach Us On +917386622889 - +919000444287 http://www.21cssindia.com/courses/oracle-rac-dba-online-training-127.html

Post a Comment

Auto Scroll Stop Scroll