GoldenGate Checkpoint Table

Checkpoint table

Replicat maintains the position of trail in the checkpoint table on Oracle database. we can say that replicat add  a entry into the checkpoint table when  replicat applied last successful transaction applied on database. On operating system,  replicat process maintains a checkpoint file in “dirchk” directory. If the checkpoint file is corrupted, we can use information from checkpoint table and we can start replicat from where it is abended or stopped. Replicat consistently track and update information from the checkpoint file and checkpoint table and process transactions on database. 

Specifying a default checkpoint table in the GLOBALS file

Oracle always recommends,  to create checkpoint table in goldengate user schema 

Steps to create checkpoint table

Step1: 

GGSCI (nt4567) 25> dblogin userid ggsuser, PASSWORD XXXXXXXXX

Successfully logged into database.

Step2: 

GGSCI (nt4567) 26> add checkpointtable ggsuser.ckptab

Successfully created checkpoint table ggsuser.ckptab

--Note # when checkpoint table is corrupted, replicat fails on database. you can recreate checkpoint table. when we restart abended replicat, abended replicat uses checkpoint file and process transactions on database. There is no impact on database -

--Nikhil Tatineni--
--Oracle Database --