揭密一致性读------之UNDO回滚链(七)
trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00c0035d.050b.26 ctl max scn: 0x0000.00c6c61f prv tx scn: 0x0000.00c6c63b
txn start scn: scn: 0x0000.00c6c924 logon user: 90
prev brb: 12583765 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x0009.01d.00004c91 uba: 0x00c02939.02d6.01
flg: C--- lkc: 0 scn: 0x0000.00c6c91b
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0
ncol: 2 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01c0195f hdba: 0x01c0195a
itli: 1 ispac: 0 maxfr: 4858
vect = 3
col 1: [2000]
42 42 42 42 42 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
****************************************************************************************************************
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0007.002.000039a5 0x00c14bec.0496.15 ---- 1 fsc 0x0000.00000000 ......1
0x02 0x0004.01a.000039be 0x00c2aafd.0433.04 C--- 0 scn 0x0000.00c6c938 ......2
itl: xid: 0x0002.01d.00004c55 uba: 0x00c0035d.050b.28
flg: C--- lkc: 0 scn: 0x0000.00c6c92a ......3
itl: xid: 0x0001.021.000039a0 uba: 0x00c2bd97.0267.01
flg: C--- lkc: 0 scn: 0x0000.00c6c924 ......4
itl: xid: 0x0009.01d.00004c91 uba: 0x00c02939.02d6.01
flg: C--- lkc: 0 scn: 0x0000.00c6c91b
******************************************************************************************************************
uba: 0x00c2bd97.0267.01==》3号文件，179607号块
sys@OCM> alter system dump datafile 3 block 179607;
UNDO BLK:
xid: 0x0001.01c.0000399f seq: 0x267 cnt: 0x1e irb: 0x1e icl: 0x0 flg: 0x0000
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1774 0x02 0x16d8 0x03 0x1650 0x04 0x15c8 0x05 0x154c
0x06 0x14e4 0x07 0x145c 0x08 0x1344 0x09 0x12d0 0x0a 0x124c
0x0b 0x11e0 0x0c 0x117c 0x0d 0x1128 0x0e 0x10a4 0x0f 0x1028
0x10 0x0fac 0x11 0x0f38 0x12 0x0e9c 0x13 0x0d78 0x14 0x0d10
0x15 0x0cb8 0x16 0x0c64 0x17 0x0c08 0x18 0x0b94 0x19 0x0b38
0x1a 0x0ae4 0x1b 0x0a5c 0x1c 0x09e0 0x1d 0x0978 0x1e 0x08f0
*-----------------------------
* Rec #0x1 slt: 0x21 objn: 78660(0x00013344) objd: 78660 tblspc: 7(0x00000007)
* 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: 0x00c2bd96.0267.3e ctl max scn: 0x0000.00c6c5f5 prv tx scn: 0x0000.00c6c5fc
txn start scn: scn: 0x0000.00c6c91b logon user: 90
prev brb: 12762517 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: Z
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0
ncol: 2 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01c0195f hdba: 0x01c0195a
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [2000]
41 41 41 41 41 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
gyj@OCM>
select dump('AAAAA',16) from dual;
DUMP('AAAAA',16)
----------------------------
Typ=96 Len=5: 41,41,41,41,41
嘿嘿！手工终于找到了AAAAA了。