My Oracle Support Banner

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

Last updated on JUNE 01, 2024

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 REP1 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 REP1 ...
  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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.