DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, July 13, 2017

OGG-00446 Supplemental checkpoint table does not exist. Create a supplemental checkpoint table with the UPGRADE CHECKPOINTTABLE command in GGSCI if you have upgraded from release 11.2.1.0.0 or earlier.

OGG-00446  Supplemental checkpoint table does not exist. Create a supplemental checkpoint table with the UPGRADE CHECKPOINTTABLE command in GGSCI if you have upgraded from release 11.2.1.0.0 or earlier.


GGSCI (dbhost02.domain.com) 3> info all

Program     Status      Group  Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EXT     00:00:00      00:00:06
REPLICAT    STOPPED     REP     00:00:00      00:04:15

GGSCI (dbhost02.domain.com) 6>UPGRADE CHECKPOINTTABLE GGUSER_CHECKPOINT

1. When we are execute above command the issue will be resolved.After restart the replicat process the same error will comes means we need to Delete the checkpoint table.

2. After that add the checkpoint table and restart the replicat process the issue will be resolved

GGSCI(dbhost02.domain.com) DELETE CHECKPOINTTABLE GGUSER_CHECKPOINT
GGSCI(dbhost02.domain.com) ADD CHECKPOINTTABLE GGUSER_CHECKPOINT
GGSCI(dbhost02.domain.com) 5> info all

Program     Status      Group  Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EXT     00:00:02      00:00:26
REPLICAT    RUNNING     REP     02:35:52      00:00:16

No comments: