Example of Redo:
CHANGE #3 TYP:0 CLS: 1 AFN:4 DBA:0x01000d44 OBJ:43810 SCN:0x0000.00299b74 SEQ: 1 OP:10.2
index redo (kdxlin): insert leaf row --insert index index leaf
KTB Redo
op: 0x01 ver: 0x01
op: F xid: 0x0007.011.0000023d uba: 0x0080101c.00ba.15
REDO: SINGLE / -- / --
itl: 2, sno: 0, row size 14
insert key: (10): 02 c1 02 06 01 00 0d 3d 00 00
CHANGE #4 TYP:0 CLS:29 AFN:2 DBA:0x00800069 OBJ:4294967295 SCN:0x0000.00299b76 SEQ: 1 OP:5.4
ktucm redo: slt: 0x0011 sqn: 0x0000023d srt: 0 sta: 9 flg: 0x2
ktucf redo: uba: 0x0080101c.00ba.15 ext: 12 spc: 4868 fbi: 0
CHANGE #5 TYP:0 CLS:30 AFN:2 DBA:0x0080101c OBJ:4294967295 SCN:0x0000.00299b4d SEQ: 4 OP:5.1
ktudb redo: siz: 144 spc: 5116 flg: 0x0012 seq: 0x00ba rec: 0x14
xid: 0x0007.011.0000023d
ktubl redo: slt: 17 rci: 0 opc: 11.1 objn: 43809 objd: 43809 tsn: 4
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
0x00000000 prev ctl uba: 0x0080101c.00ba.0e
prev ctl max cmt scn: 0x0000.00299179 prev tx cmt scn: 0x0000.002991cd
txn start scn: 0x0000.00299b74 logon user: 38 prev brb: 8392728 prev bcl: 0 KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0002.003.000002ce uba: 0x00801137.0097.11
flg: C--- lkc: 0 scn: 0x0000.00299b67
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000d3d hdba: 0x01000d3b
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0
ncol: 0 nnew: 0 size: -3
full row:
CHANGE #6 TYP:0 CLS:30 AFN:2 DBA:0x0080101c OBJ:4294967295 SCN:0x0000.00299b76 SEQ: 1 OP:5.1
ktudb redo: siz: 100 spc: 4970 flg: 0x0022 seq: 0x00ba rec: 0x15
xid: 0x0007.011.0000023d
ktubu redo: slt: 17 rci: 20 opc: 10.22 objn: 43810 objd: 43810 tsn: 4
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0008.00a.000002b4 uba: 0x008011dc.00ac.07
flg: C--- lkc: 0 scn: 0x0000.00299b70
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x1000d43 block=0x01000d44
(kdxlpu): purge leaf row
key :(10): 02 c1 02 06 01 00 0d 3d 00 00
REDO RECORD - Thread:1 RBA: 0x000080.00013c90.0010 LEN: 0x0070 VLD: 0x06
SCN: 0x0000.00299bc6 SUBSCN: 1 10/31/2009 14:52:01
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ: 0 OP:23.1
Block Written - afn: 4 rdba: 0x01000d3d BFT:(1024,16780605) non-BFT:(4,3389)
scn: 0x0000.00299b76 seq: 0x02 flg:0x06
END OF REDO DUMP
----- Redo read statistics for thread 1 ----- Redo 统计信息
Read rate (ASYNC): 40688Kb in 2.23s => 17.82 Mb/sec
Total physical reads: 40960Kb
Longest record: 37Kb, moves: 0/127712 (0%)
Change moves: 51286/265334 (19%), moved: 9Mb
Longest LWN: 1024Kb, moves: 9/4754 (0%), moved: 3Mb
Last redo scn: 0x0000.00299d16 (2727190)
----------------------------------------------
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15072844/viewspace-627471/
,如需转载,请注明出处,否则将追究法律责任。