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 and later
Information in this document applies to any platform.


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.




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.