My Oracle Support Banner

Wrong Transaction Timestamp During OGG Replication (Doc ID 2725393.1)

Last updated on APRIL 17, 2023

Applies to:

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


On : version, 1 - Oracle DB backend

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, moreover previous timestamp is higher than the next timestamp.


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.