My Oracle Support Banner

OGG Why are Different Archive Log Sequence Numbers Displayed in SHOWCH and SHOWTRANS Output? (Doc ID 1390475.1)

Last updated on JULY 18, 2023

Applies to:

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

Symptoms

When using a skiptrans/ forcetrans command the SHOWCH and the SHOWTRANS commands
display different archive log sequence numbers.

Please find the following example to show the inconsistent results in SHOWCH and SHOWTRANS


The showtrans shows that the last open transaction is on archive log sequence 80637
wherein the recovery checkpoint (in showch) shows that you are on archivelog 81342.

Ideally the showtrans and the recovery checkpoint( showch) should show the
same archive log sequence numbers.

Changes

 

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
Changes
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.