Send Extract Showtrans lists non-existing XIDs and causes RMAN-08137
(Doc ID 2580979.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 12.3.0.1.0 and laterInformation 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
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 |