----
_SYSSMU22$
SQL>
select dbms_utility.data_block_address_file(to_number(substr(uba,3,8),'xxxxxxxxxxx')) undo_file#,
2 dbms_utility.data_block_address_block(to_number(substr(uba,3,8),'xxxxxxxxxxx')) blockno#,
3 to_number(substr(uba,12,4),'xxxxxxxxx') undo_seq,
4 to_number(substr(uba,17,2),'xxxxxxxxx') undo_record
5
from (
select '0x018000b4.0000.1b' uba
from dual);
UNDO_FILE# BLOCKNO# UNDO_SEQ UNDO_RECORD
---------- ---------- ---------- -----------
6 180 0 27 （5）根据步骤（4）查询的基本信息，dump事务的undo段头和undo块
SQL>
alter
system dump undo header '_SYSSMU22$';
System altered.
SQL>
alter
system dump datafile 6 block 180;
System altered.
undo header trace 文件:
TRN CTL:: seq: 0x0000 chd: 0x0014 ctl: 0x0012 inc: 0x00000000 nfb: 0x0002
mgc: 0xb000 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x018000b4.0000.1b scn: 0x0000.00000000 --uba对应事务表中最早使用的undo块
Version: 0x01
FREE BLOCK POOL::
uba: 0x00000000.0000.1a ext: 0x0 spc: 0x1292
uba: 0x018000b3.0000.08 ext: 0x0 spc: 0x1c52
uba: 0x018000b2.0000.24 ext: 0x0 spc: 0x124e
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::
index
state cflags wrap# uel scn dba parent-xid nub stmt_num cmt
------------------------------------------------------------------------------------------------
...........省略一部分...............
0x0f 9 0x00 0x0002 0x0010 0x0000.000fbe30 0x018000b4 0x0000.000.00000000 0x00000001 0x00000000 1399884492
0x10 9 0x00 0x0002 0x0011 0x0000.000fbe3f 0x018000b4 0x0000.000.00000000 0x00000001 0x00000000 1399884492
0x11 9 0x00 0x0002 0x0012 0x0000.000fbe45 0x018000b4 0x0000.000.00000000 0x00000001 0x00000000 1399884492
0x12 9 0x00 0x0002 0xffff 0x0000.000fbe5e 0x018000b4 0x0000.000.00000000 0x00000001 0x00000000 1399884492
0x13 10 0x80 0x0002 0x0000 0x0000.000fbdcc 0x018000b4 0x0000.000.00000000 0x00000001 0x00000000 0
0x14 9 0x00 0x0001 0x0015 0x0000.00000000 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 0
state为10表示该事物为活动状态
............后面省略.....................
undo block trace 文件：
UNDO BLK:
xid: 0x0016.013.00000002 seq: 0x0 cnt: 0x1b irb: 0x1b icl: 0x0 flg: 0x0000
Rec
Offset Rec
Offset Rec
Offset Rec
Offset Rec
Offset
---------------------------------------------------------------------------
0x01 0x1f60 0x02 0x1efc 0x03 0x1eac 0x04 0x1e5c 0x05 0x1e28
0x06 0x1de0 0x07 0x1d80 0x08 0x1cc0 0x09 0x1c70 0x0a 0x1bec
0x0b 0x1b68 0x0c 0x1ae0 0x0d 0x1a80 0x0e 0x19f8 0x0f 0x1998
0x10 0x18ec 0x11 0x1840 0x12 0x1790 0x13 0x1724 0x14 0x16b8
0x15 0x1604 0x16 0x1554 0x17 0x14a4 0x18 0x13f4 0x19 0x1344
0x1a 0x12d8 0x1b 0x124c
.................省略一部分undo record................
*-----------------------------
* Rec #0x1b slt: 0x13 objn: 73431(0x00011ed7) objd: 73431 tblspc: 4(0x00000004) --------0xbl undo record中保存的前映像数据与我们知道的一致，为DHTEST1
* Layer: 11 (
Row) opc: 1 rci 0x00
Undo
type: Regular undo
Begin trans
Last buffer split:
No
Temp
Object:
No
Tablespace Undo:
No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x018000b4.0000.19 ctl
max scn: 0x0000.00000000 prv tx scn: 0x0000.00000000
txn
start scn: scn: 0x0000.000fbd45 logon
user: 85
prev brb: 0 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
compat
bit: 4 (post-11) padding: 1
op: Z
KDO Op code: URP
row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000 |