Incorrect Lag on Integrated Replicat/ Time Since Checkpoint Increases When There Is No Activity In The Database (Doc ID 2151697.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2.1.2 version, 1 - Oracle DB backend

ACTUAL BEHAVIOR
---------------
Replicat shows lag even though it reached EOF.
REPLICAT RINT Last Started 2016-05-12 17:56 Status RUNNING
INTEGRATED
Checkpoint Lag 01:25:38 (updated 00:00:00 ago)
Process ID 16867
Log Read Checkpoint File /u01/goldengate/v122010/dirdatna005812
  2016-05-12 17:55:59.000000 RBA 206847696


Sending STATUS request to REPLICAT RINT ...
  Current status: At EOF
  Sequence #: 5813
  RBA: 218901613
  0 records in current transaction

EXPECTED BEHAVIOR
-----------------------
When replicat reached EOF it should show the lag as zero.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms