My Oracle Support Banner

Wrong Transaction Timestamp During OGG Replication (Doc ID 2725393.1)

Last updated on NOVEMBER 24, 2020

Applies to:

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

Symptoms

On : 19.1.0.0.4 version, 1 - Oracle DB backend

ACTUAL BEHAVIOR
---------------
wrong transaction timestamp during OGG replication


Issue during OGG replication from Oracle database.
Our process is:
Source oracle db -> downstream server -> OGG server -> Kafka|hadoop
When we open trail on downstream server via log dump utility we see correct time stamps for transaction (for example, 15:29:06.000.000 for all positions). When we open trail on second OGG server , we see strange time stamps for transaction (2020/10/20 15:29:05.987.034 -> 2020/10/20 15:29:05.986.821 ). Which mean that it has different timestamp (06 second versus 05.96x.xxx), moreover previous timestamp is higher than the next timestamp.

Cause

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
Symptoms
Cause
Solution


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