Oracle GoldenGate extract and replicat processes perform checkpoint operations. In case of some unexpected failure happened, the checkpoint file or database table ensures extract and replicat processes restart’s from the point of failure and avoid re-capture and re-apply of transactions.
So, Checkpoint table enables the checkpoint to be included within Replicat’s transaction, ensuring complete recovery from all failure scenarios.
Below GGSCI command can be used to create the checkpoint table by specifying the database schema and table name.
GGSCI> add checkpointtable ggs_admin.ggschkpt
Another method is to add the parameter CHECKPOINTTABLE ggs_admin.ggschkpt to the GLOBALS parameter file and execute the command without specifying the tablename. Exit and re-start GGSCI to activate the new parameters added to GLOBALS file.
GGSCI> delete checkpointtable ggs_admin.ggschkpt
GGSCI> dblogin userid ggs_admin, password xxxxxx
GGSCI> add checkpointtable
