|
/app/oracle/diag/rdbms/rhys/RHYS/incident
1 Diag Cdump /opt/app/oracle/diag/rdbms/rhys/RHYS/cdump
1 Health Monitor /opt/app/oracle/diag/rdbms/rhys/RHYS/hm
1 Default Trace File /opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_ora_3316.trc
1 Active Problem Count 1
1 Active Incident Coun 1
INST_ID NAME VALUE
---------- -------------------- ------------------------------------------------------------
t
11 rows selected.
SQL> !vi /opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_ora_3316.trc
查看undo 前镜像：
* Rec #0x16 slt: 0x3c objn: 73888(0x000120a0) objd: 73888 tblspc: 5(0x00000005)
* 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: 0x00c00122.016e.13 ctl max scn: 0x0000.00acf0a4 prv tx scn: 0x0000.00acf0a6
txn start scn: scn: 0x0000.00acf251 logon user: 0
prev brb: 12583237 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x000d.016.000000d8 uba: 0x020000ed.02b6.08
flg: C--- lkc: 0 scn: 0x0000.00aa0d31
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01400087 hdba: 0x01400082
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 0
col 0: [ 2] c1 03
SQL> select utl_raw.cast_to_number(replace('c1 03',' ')) a from dual;
A
----------
2
SQL>
查看undoheader
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num
------------------------------------------------------------------------------------------------
0x00 9 0x80 0x0024 0x0060 0x0000.00acf3c9 0x00c0016c 0x0000.000.00000000 0x00000001 0x00000000
0x39 9 0x80 0x0023 0x0031 0x0000.00acf37f 0x00c00163 0x0000.000.00000000 0x00000001 0x00000000
0x3a 9 0x80 0x0023 0x003e 0x0000.00acf38c 0x00c0016a 0x0000.000.00000000 0x00000001 0x00000000
0x3b 9 0x80 0x0023 0x0035 0x0000.00acf384 0x00c0016a 0x0000.000.00000000 0x00000001 0x00000000
0x3c 10 0x80 0x0022 0x0000 0x0000.00acf251 0x00c00122 0x0000.000.00000000 0x00000001 0x00000000
0x3d 9 0x80 0x0023 0x0046 0x0000.00acf39e 0x00c0016b 0x0000.000.00000000 0x00000002 0x00000000
查看数据块信息：
SQL> alter system dump datafile 5 block 135;
System altered.
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0015.03c.00000022 0x00c00122.016e.16 ---- 1 fsc 0x0000.00000000
0x02 0x000b.016.000000df 0x02006448.04fb.07 C--- 0 scn 0x0000.00ab118a
bdba: 0x01400087
data_block_dump,data header at 0x7ff873eada64
===============
tsiz: 0x1f98
hsiz: 0x1e
pbl: 0x7ff873eada64
76543210
flag=--------
ntab=1
nrow=6
frre=0
fsbo=0x1e
fseo=0x1f39
avsp=0x1f5b
tosp=0x1f5b
0xe:pti[0] nrow=6 offs=0
0x12:pri[0] sfll=2
0x14:pri[1] offs=0x1f82
0x16:pri[2] sfll=3
0x18:pri[3] sfll=-1
0x1a:pri[4] offs=0x1f61
0x1c:pri[5] offs=0x1f39
block_row_dump:
tab 0, row 1, @0x1f82
tl: 11 fb: --H-FL-- lb: 0x1 cc: 3
col 0: [ 2] c1 02
col 1: [ 2] c1 04
col 2: [ 1] 62
tab 0, row 4, @0x1f61
tl: 11 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 2] c1 03
col 1: [ 2] c1 02
col 2: [ 1] 61
tab 0, row 5, @0x1f39
tl: 9 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 2] c1 04
col 1: *NULL*
col 2: [ 1] 44
end_of_block_dump
End dump data blocks tsn: 5 file#: 5 minblk 135 maxblk 135
进行提交事务：
查看u |