My Oracle Support Banner

Send Extract Showtrans lists non-existing XIDs and causes RMAN-08137 (Doc ID 2580979.1)

Last updated on JANUARY 06, 2021

Applies to:

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

Symptoms

Getting "RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process" since the Recovery Checkpoint is pointed to old date.

The transactions listed from "send xxx showtrans" are not running in the database.

 

GGSCI > info xxx, showch

EXTRACT    xxx  Last Started 2019-07-19 00:24   Status RUNNING
Checkpoint Lag       00:00:03 (updated 00:00:04 ago)
Process ID           305471
Log Read Checkpoint  Oracle Integrated Redo Logs
                    2019-07-19 14:21:50
                    SCN 49.871908334 (211325305838)


Current Checkpoint Detail:

Read Checkpoint #1

 Oracle Integrated Redo Log

 Startup Checkpoint (starting position in the data source):
   Timestamp: 2019-01-28 16:18:41.000000
   SCN: Not available

 Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
   Timestamp: 2019-07-19 10:21:51.000000                                                  <<<<<<<<<<<<<<<<<<<
   SCN: 49.810370944 (211263768448)

 Current Checkpoint (position of last record read in the data source):
   Timestamp: 2019-07-19 14:21:50.000000
   SCN: 49.871908334 (211325305838)

 

 

Send Showtrans command list the XIDs that start from old date

GGSCI > send xxx , showtrans tabular

Sending SHOWTRANS request to EXTRACT xxx ...


XID                    Items    Extract   Redo Thread  Start Time           SCN                               Redo Seq  Redo RBA            Status              
------------------------------------------------------------------------------------------------------------------------------------------------------
0.140.19.6009754       0        xxxx  1            2019-07-19:10:21:51  49.810370944 (211263768448)       51164     3619983828          Running            
0.1468.32.102853       0        xxxx 1            2019-07-19:10:21:51  49.810370948 (211263768452)       51164     3621760044          Running            
0.1386.1.113453        0        xxxx 1            2019-07-19:10:21:51  49.810370948 (211263768452)       51164     3620821432          Running            
0.788.17.987845        0        xxxx 1            2019-07-19:10:21:51  49.810370949 (211263768453)       51164     3623676540          Running            
0.2589.7.21066         0        xxxx 2            2019-07-19:11:20:44  49.825163559 (211278561063)       51836     7209780             Running            
0.1486.16.105612       0        xxxx 1            2019-07-19:11:20:44  49.825163573 (211278561077)       51171     72879684            Running            
0.1926.16.238503       0        xxxx 2            2019-07-19:11:20:44  49.825163573 (211278561077)       51836     8048896             Running            
0.2527.20.24923        0        xxxx 2            2019-07-19:11:20:44  49.825163573 (211278561077)       51836     6286732             Running        

 

The transaction IDs listed in showtrans command are not running in the database.


SQL>  select b.inst_id,b.sid,b.serial#, b.username,wait_class, state,SECONDS_IN_WAIT, XIDUSN||'.'||XIDSLOT||'.'||XIDSQN "XID", (START_SCNW * 4294967296) + START_SCNB "Start SCN" ,SES_ADDR from gv$transaction a, gv$session b where a.SES_ADDR=b.saddr;

INST_ID    SID    SERIAL# USERNAME   WAIT_CLASS STATE             SECONDS_IN_WAIT XID                Start SCN SES_ADDR
------- ------ ---------- ---------- ---------- ----------------- --------------- -------------- ------------- ----------------
     1  17098      30918 C##GGADMIN User I/O   WAITING                         0 1403.30.104563  211318137540 000000246C1A8668
     1  24591      45367 C##GGADMIN Idle       WAITING                         0 1729.29.104647  211318137900 000000244C741D18
     1  32788      11932 C##GGADMIN User I/O   WAITED SHORT TIME               0 172.21.9958325  211318138676 000000248D135FA0
     1  38935      60534 C##GGADMIN User I/O   WAITING                         0 1869.31.67959   211318138991 000000246DAB1178
     1  43715      54283 C##GGADMIN Idle       WAITING                         0 1701.22.95015   211318139085 000000244DD248D8

 

 

 

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.