GG MGR Process Showing Wrong Information After DST Time Change (Doc ID 2202335.1)

Last updated on APRIL 12, 2017

Applies to:

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

Goal

 After November DST time change Extract, Pump and Replicat all were current but showing lag of around an hour:

 

EXTRACT EXTHG Last Started 2016-10-16 02:30 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)        <==== Current
Process ID 8860
VAM Read Checkpoint 2016-11-07 13:26:57.830000
LSN: 0x00005ffc:00001f8d:0004, Tran: 0000:024499e4

Write Checkpoint #1

GGS Log Trail

Current Checkpoint (current write position):
Sequence #: 144
RBA: 38580133
Timestamp: 2016-11-07 14:27:00.301000
Extract Trail: dirdat\hg
Trail Type: EXTTRAIL

GGSCI (GA016D237) 5> LAG EXTHG

Sending GETLAG request to EXTRACT EXTHG ...
Last record lag 3,601 seconds. <======================== Lag 1 hour
At EOF, no more records to process.

 

PUMP
==============================
EXTRACT PMPHGN Last Started 2016-10-30 19:45 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:04 ago)          <=== Current
Process ID 9660
Log Read Checkpoint File dirdat\hg000144 <=== Pump reading current extract trail 144
2016-11-07 13:28:00.296666 RBA 38837675

GGSCI (GA016D237) 6> LAG PMPHGN

Sending GETLAG request to EXTRACT PMPHGN ...
Last record lag 3,602 seconds. <======================== Lag 1 hour
At EOF, no more records to process.

 

REPLICAT
===================
REPLICAT REPHG Last Started 2016-11-07 10:37 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Process ID 6030700
Log Read Checkpoint File dirdat/hg000125
2016-11-07 12:26:39.028698 RBA 109329101 <============= Replicat reading current pump trail Sequence #: 125

GGSCI (ga016d02) 22> lag rephg

Sending GETLAG request to REPLICAT REPHG ...
Last record lag 3,604 seconds. <======================== Lag 1 hour
At EOF, no more records to process.

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