GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Goldengate replicat lag at chkpt increasing

edited Jan 11, 2018 12:09AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi Experts,

Replicat process  lag at chkpt is increasing ...

Please let know how to troubleshot this issue ...

GGSCI ( as ggadmin@dbprd1) 12> info all

Program       Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER       RUNNING

REPLICAT      RUNNING     REREP2      01:22:49      00:00:00

GGSCI ( as ggadmin@dbprd1) 9> send REPLICAT REREP2, status

Sending STATUS request to REPLICAT REREP2 ...

  Current status: Processing data

  Sequence #: 3860

  RBA: 107539690

  565 records in current transaction

GGSCI ( as ggadmin@dbprd1) 10> info *, detail

REPLICAT   REREP2    Last Started 2017-12-12 07:16   Status RUNNING

Checkpoint Lag       01:19:40 (updated 00:00:06 ago)

Process ID           32000

Log Read Checkpoint  File ./dirdat/st000003860

2018-01-04 20:24:41.108088  RBA 112743062

Current Log BSN value: 255319556430

Last Committed Transaction CSN value: 255320079936

  Extract Source                          Begin             End

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center