~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~INSERT
REDO RECORD - Thread:1 RBA: 0x0001ec.00003a82.0140 LEN: 0x01e8 VLD: 0x01
SCN: 0x0000.003fd60a SUBSCN: 1 10/31/2008 10:52:10
CHANGE #1 TYP:0 CLS:17 AFN:2 DBA:0x00800009 SCN:0x0000.003fd5ba SEQ: 1 OP:5.2
ktudh redo: slt: 0x0001 sqn: 0x00000789 flg: 0x0012 siz: 128 fbi: 0
uba: 0x00800693.02ce.2e pxid: 0x0000.000.00000000
CHANGE #2 TYP:0 CLS:18 AFN:2 DBA:0x00800693 SCN:0x0000.003fd5b9 SEQ: 3 OP:5.1
ktudb redo: siz: 128 spc: 996 flg: 0x0012 seq: 0x02ce rec: 0x2e
xid: 0x0001.001.00000789
ktubl redo: slt: 1 rci: 0 opc: 11.1 objn: 53755 objd: 53755 tsn: 0
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
0x00000000 prev ctl uba: 0x00800693.02ce.2b
prev ctl max cmt scn: 0x0000.003fceb7 prev tx cmt scn: 0x0000.003fcecc
txn start scn: 0xffff.ffffffff logon user: 0 prev brb: 8393221 prev bcl: 0 KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
op: Z
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040dde2 hdba: 0x0040dde1
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 0(0x0)~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`注意对undo段改动没有存放旧值
CHANGE #3 TYP:0 CLS: 1 AFN:1 DBA:0x0040dde2 SCN:0x0000.003fd60a SEQ: 4 OP:11.2
KTB Redo
op: 0x01 ver: 0x01
op: F xid: 0x0001.001.00000789 uba: 0x00800693.02ce.2e
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040dde2 hdba: 0x0040dde1
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 0(0x0) size/delt: 5
fb: --H-FL-- lb: 0x1 cc: 1
null: -
col 0: [ 1] 31~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~存放新值
CHANGE #4 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ: 0 OP:5.19
session number = 143
serial number = 21
current username = SYS
login username = SYS
client info =
OS username = 6688
Machine name = WORKGROUP\FUFU
OS terminal = FUFU
OS process id = 2660:2832
OS program name = sqlplus.exe
transaction name =
version 168821248
audit sessionid 4294967295
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~UPDATE
REDO RECORD - Thread:1 RBA: 0x0001ec.000048e1.01cc LEN: 0x01d4 VLD: 0x01
SCN: 0x0000.003fd797 SUBSCN: 1 10/31/2008 11:01:07
CHANGE #1 TYP:0 CLS:21 AFN:2 DBA:0x00800029 SCN:0x0000.003fd786 SEQ: 1 OP:5.2~~~~~~~~~~~~~~~~~~~~~~~~~~~~对undo 事物表的该动
ktudh redo: slt: 0x0017 sqn: 0x00000ba8 flg: 0x0012 siz: 152 fbi: 0
uba: 0x00803176.07ef.06 pxid: 0x0000.000.00000000~~~~~~~~~~~~~~~~~~~~uba存放对 以前旧值更新前存在undo段的数据地址
CHANGE #2 TYP:0 CLS:22 AFN:2 DBA:0x00803176 SCN:0x0000.003fd782 SEQ: 7 OP:5.1~~~~~~~~~~~~~~~对undo段的改动
ktudb redo: siz: 152 spc: 7540 flg: 0x0012 seq: 0x07ef rec: 0x06
xid: 0x0003.017.00000ba8
ktubl redo: slt: 23 rci: 0 opc: 11.1 objn: 53755 objd: 53755 tsn: 0
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
0x00000000 prev ctl uba: 0x00803176.07ef.01
prev ctl max cmt scn: 0x0000.003fd110 prev tx cmt scn: 0x0000.003fd11f
txn start scn: 0xffff.ffffffff logon user: 0 prev brb: 8401251 prev bcl: 0 KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
op: Z
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040dde2 hdba: 0x0040dde1 hdba代表test表数据块地址 ,bdba代表test表 段头的块地址
itli: 2 ispac: 0 maxfr: 4863
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0
ncol: 1 nnew: 1 size: -2
col 0: [ 1] 31~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~原值 col列0更新的是 第一列的意思
CHANGE #3 TYP:2 CLS: 1 AFN:1 DBA:0x0040dde2 SCN:0x0000.003fd616 SEQ: 1 OP:11.5~~~~~~~~~~~~~~~~~~对test表的改动~~~~~~~~~~~~~~~~~~~
KTB Redo
op: 0x11 ver: 0x01
op: F xid: 0x0003.017.00000ba8 uba: 0x00803176.07ef.06
Block cleanout record, scn: 0x0000.003fd797 ver: 0x01 opt: 0x02, entries follow...
itli: 1 flg: 2 scn: 0x0000.003fd616
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040dde2 hdba: 0x0040dde1~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~hdba代表test表数据块地址 ,bdba代表test表 段头的块地址
itli: 2 ispac: 0 maxfr: 4863
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 2 ckix: 0
ncol: 1 nnew: 1 size: 2
col 0: [ 3] 61 61 61~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~这个是aaa更新后的值
CHANGE #4 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ: 0 OP:5.20
session number = 143
serial number = 21
transaction name =
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12020513/viewspace-607612/ ,如需转载,请注明出处,否则将追究法律责任。