My Oracle Support Banner

GG Command INFO ALL Shows Output For Process As Unknown State Under Lag At Chkpt Column On RAC Setup (Doc ID 2168573.1)

Last updated on JUNE 26, 2018

Applies to:

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

Goal

3 node RAC with 12c OGG. One of the nodes was rebotoed & GG Lag at Chkpt kept on increasing. Stopped & started GG but it came up with unknown state.

GGSCI (mtgqn1pporadb03) 3> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING BACUEXT unknown 00:00:05

Also, it was observed that node which got rebooted has some timing difference in seconds with other nodes.

[oracle@mtgqn1pporadb02 ~]$ date
Thu Jul 14 12:34:12 PDT 2016
[oracle@mtgqn1pporadb01 ~]$ date
Thu Jul 14 12:33:24 PDT 2016
oracle@mtgqn1pporadb03:/home/oracle> date
Thu Jul 14 12:33:26 PDT 2016
 

Solution

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
Goal
Solution


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