Golden Gate

==========================
Golden gate Checkpoint
==========================

Example:

GGSCI (my_server) 1> INFO ALL

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     DPM_I_01    00:00:00      00:00:03
EXTRACT     RUNNING     DPM_P_01    00:00:00      00:00:01
EXTRACT     RUNNING     DPM_S_01    00:00:00      00:00:04
EXTRACT     RUNNING     EXT_I_01    00:00:02      00:00:05
EXTRACT     RUNNING     EXT_P_01    00:00:02      00:00:01
EXTRACT     RUNNING     EXT_S_01    00:00:03      00:00:06
REPLICAT    RUNNING     REP_I_01    00:00:00      01:43:12
REPLICAT    RUNNING     REP_P_01    00:00:04      00:00:00
REPLICAT    RUNNING     REP_S_01    00:00:04      00:00:00

Checkpoint Files are under dirchk directory:

oracle@my_server:/software/ogg/191/dirchk>% ls -ltr

-rw-r----- 1 oracle dba  6144 Sep 29 01:00 EXT_I_01.cpb
-rw-r----- 1 oracle dba  6144 Sep 29 01:00 EXT_S_01.cpb
-rw-r----- 1 oracle dba  6144 Sep 29 01:00 EXT_P_01.cpb

-rw-r----- 1 oracle dba 53248 Sep 30 10:54 EXT_S_01.cpe
-rw-r----- 1 oracle dba 69632 Sep 30 10:54 EXT_I_01.cpe
-rw-r----- 1 oracle dba 71680 Sep 30 10:54 EXT_P_01.cpe

-rw-r----- 1 oracle dba 14336 Sep 30 10:54 DPM_S_01.cpe
-rw-r----- 1 oracle dba 14336 Sep 30 10:54 DPM_I_01.cpe
-rw-r----- 1 oracle dba 14336 Sep 30 10:54 DPM_P_01.cpe

-rw-r----- 1 oracle dba 16384 Sep 30 09:12 REP_I_01.cpr
-rw-r----- 1 oracle dba 14336 Sep 30 10:54 REP_P_01.cpr
-rw-r----- 1 oracle dba 16384 Sep 30 10:54 REP_S_01.cpr

Each process in Goldengate has its own checkpoint file which gets updated by default every 10 seconds, if the process is in running status.

Time since checkpoint is the time elapsed since the checkpoint file associated to process was updated.

Lag at checkpoint is the actual lag of the process. It is updated when the checkpoint file was updated.