My Oracle Support Banner

Log Read Checkpoint Timestamp In INFO Command Output Is Shown Incorrect For Integrated Replicat When It's Abended Or Stopped. (Doc ID 2238703.1)

Last updated on MARCH 22, 2019

Applies to:

Oracle GoldenGate - Version to [Release 12.1]
Information in this document applies to any platform.


With OGG it is noticed that the Log Read Checkpoint timestamp is not reflecting the correct timestamp from the trailfile where the replicat stopped reading it.

It shows:
if Abended - the time when it got abended.
if Running - the current time

Here is the example:
Oracle GoldenGate Command Interpreter for Oracle
Version 21604177 OGGCORE_12.
AIX 6, ppc, 64bit (optimized), Oracle 11g on Sep  2 2015 16:29:21
Operating system character set identified as ISO-8859-1.
GGSCI (hqbuun761) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

REPLICAT    ABENDED     RTEST       00:00:14      64:33:15

GGSCI (hqbuun761) 3> info RTEST

REPLICAT   RTEST     Last Started 2015-12-24 09:50   Status ABENDED
Checkpoint Lag       00:00:14 (updated 64:33:26 ago)
Log Read Checkpoint  File ./dirdat/es000034
                     2015-12-21 17:20:11.515874  RBA 56808478

Oracle GoldenGate Log File Dump Utility for Oracle
Version 21604177 OGGCORE_12.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

Logdump 110 >open ./dirdat/es000034
Current LogTrail is ./dirdat/es000034
Logdump 111 >pos 56808478
Reading forward from RBA 56808478
Logdump 112 >ghdr on
Logdump 113 >n
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)
RecLength  :   578  (x0242)   IO Time    : 2015/12/07 15:09:29.006.778
IOType     :     5  (x05)     OrigNode   :   255  (xff)
TransInd   :     .  (x03)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
AuditRBA   :       3429       AuditPos   : 2550800
Continued  :     N  (x00)     RecCount   :     1  (x01)




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

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