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: