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

Last updated on JULY 01, 2013

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Jul-2013***

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

EXTRACT E1_B Last Started 2011-12-19 15:43 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint Oracle Redo Logs
2011-12-19 20:51:47 Seqno 81489, RBA 700964864

Current Checkpoint Detail:

Read Checkpoint #1

Oracle Redo Log

Startup Checkpoint (starting position in the data source):
Sequence #: 80614
RBA: 91695120
Timestamp: 2011-12-16 09:38:54.000000
Redo File: Not Avaliable

Recovery Checkpoint (position of oldest unprocessed transaction in the data
source):
Sequence #: 81342
RBA: 209655824
Timestamp: 2011-12-19 11:40:56.000000
Redo File: Not Avaliable

GGSCI (GG) 148> send E1_B, showtrans
Sending SHOWTRANS request to EXTRACT E1_B ...
Oldest redo log file necessary to restart Extract is:

Redo Log Sequence Number 81342, RBA 209655824

------------------------------------------------------------
XID: 527.12.146191
Items: 0
Extract: E1_B
Redo Thread: 1
Start Time: 2011-12-16:11:08:03
SCN: 2594.3947645455 (11145092811279)
Redo Seq: 80637
Redo RBA: 158258192
Status: Running


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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms