GG checkpoint table error....(ERROR: Could not delete DB checkpoint for REPLICAT..)

Hi All

I'm pretty new to GG technology and learning concepts. But recently while configuring GG on target server i got following error.

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

Reason was un know to me.


Here is the Info:


GGSCI (nacssiovm0147) 15> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    STOPPED     REP1        00:00:00      17:01:17

GGSCI (nacssiovm0147) 16> delete REPLICAT REP1

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

The reason for above error was i added REPLICAT process without specifying NODBCHECKPOINT argument.

So replicat process got created initially, but when i tried to delete this REPLICAT group i got above error.

Solution:

I searched support.oracle.com and fount that we should specify ! argument as well in " delete REPLICAT REP1" command.

For example:

GGSCI (nacssiovm0147) 17> delete REPLICAT REP1 !

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

GGSCI (nacssiovm0147) 18> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

Now the REPLICAT process has got delete.

Thanks for checking out and corrections are welcome

Reference- MOS note 965689.1