OGG Why are Different Archive Log Sequence Numbers Displayed in SHOWCH and SHOWTRANS Output?
(Doc ID 1390475.1)
Last updated on JULY 06, 2020
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Jul-2013***
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