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 JANUARY 05, 2017

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

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