This discussion is archived
3 Replies Latest reply: Nov 24, 2012 10:00 AM by satrap RSS

When does capture/pump/replicat process do a checkpoint?

975365 Newbie
Currently Being Moderated
Dear Guru,

May someone help me to know when capture/pump/replicat process does a checkpoint? There are 2 things which made me confused.
- CHECKPOINTSECS parameter: There is no setting in the parameter file, that means it will be set by default (10s)
- One document says that checkpoints are based on transaction boundaries, that means checkpoint will happened by the end of each transaction

In my source db, there was a long running transaction lasting for 1 hour and already committed and written to the local trail files. Then the pump process have started to read the trail files to pump to target. My concern is when the capture/pump/replicat process do a checkpoint? 10s or 1 hour?

One thing is I often see the value of "Time since chkpt" in the output of "Info all" command is more than 10s. If they do a checkpoint every 10s, how could the value of "Time since chkpt" be more than 10s? I think that maybe the term "chkpt" of "Time since chkpt" is of database transaction, not of GoldenGate. However I'm not sure. It made me really confused.

Here is the output of "Info all" command:
Program Status Group Lag Time Since Chkpt
EXTRACT RUNNING PUMP6 00:17:07 00:04:29


My system profile:
Source:
OS: OEL5 64bit
DB: Oracle 11gR2 (11.2.0.2)
GG: 11gR1 (11.1)

Target:
OS: Solaris 10
DB: Oracle 11gR2 (11.2.0.3)
GG: 11gR1 (11.1)

Thanks for your help in advance.
Hieu

Edited by: 972362 on Nov 21, 2012 2:36 AM
  • 1. Re: When does capture/pump/replicat process do a checkpoint?
    satrap Journeyer
    Currently Being Moderated
    There are different types of checkpoints that Golden gate maintains for each process. You can see them using INFO <EXTRACT/PUMP/REPLICAT>, SHOWCH.

    For example, for an extract, you will see the following read checkpoints:
    - startup checkpoint
    - recovery checkpoint
    - current checkpoint
    - BR recovery checkpoints

    Similarly there are different read and write checkpoints maintained for Pump and Replicat.
    For more details on each of them, you can refer to 'SHOWCH' parameter in GG reference guide.
  • 2. Re: When does capture/pump/replicat process do a checkpoint?
    975365 Newbie
    Currently Being Moderated
    Hi satrap,

    Thanks for your comment. I understand that there are some kinds of checkpoint for each process. However I don't know exactly which parameter is to control the checkpoint interval of each kind. Could you elaborate more about it, either for extract, pump or replicat process?

    Best regards,
    Hieu
  • 3. Re: When does capture/pump/replicat process do a checkpoint?
    satrap Journeyer
    Currently Being Moderated
    CHECKPOINTSECS defines how often an extract makes its regular checkpoints. An extract will make a checkpoint every 10 seconds if this value is set to 10 irrespective of a transaction that is running for 1 hour. Extract also writes commit checkpoints when a transaction is committed.
    In the example where your Pump is showing time since checkpoint as greater than 10 could have a problem at the network level or issues with the remote trail..
    that is my observation as I had an extract that was being shown as RUNNING but time since last checkpoint was in hours and when i checked the report file, it had an error.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points