dml操作重做日誌分析
目的:
為了觀察dml操作對應重做日誌內容以及資料塊scn變更,透過dump logfile獲取重做日誌內容,結合資料塊進行分析。
1,測試表:
version:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
System name: Linux
Node name: rhel5
Release: 2.6.18-8.el5xen
drop table test_with_pk;
create table test_with_pk(x int,y int,z int);
alter table test_with_pk add constraint pk_test_with_pk primary key(x);
insert into test_with_pk values(3,4,5);
insert into test_with_pk values(4,5,6);
commit;
2,操作過程:
2.1 獲取scn方式:
select current_scn,'0x0000.'||ltrim(to_char(current_scn,'xxxxxxxxxxxx')) hexscn from v$database;
302586420,0x0000.12091a34
2.2 inserts
insert into test_with_pk values(7,8,9);
insert into test_with_pk values(8,9,10);
insert into test_with_pk values(9,10,11);
insert into test_with_pk values(10,11,12);
2.3 獲取scn方式:
302586436--0x0000.12091a44
2.4 deletes
delete from test_with_pk where x=3;
delete from test_with_pk where x=4;
delete from test_with_pk where x=7;
delete from test_with_pk where x=8;
2.5 獲取scn方式:
302586446--0x0000.12091a4e
2.6
commit;
2.7 獲取scn方式:
302586468--0x0000.12091a64
2.8 dump logfile:
--確定當前logfile
SELECT lf.MEMBER
FROM v$log lg, v$logfile lf
WHERE lg.group# = lf.group#
AND lg.status = 'CURRENT';
--dump logfile
alter system dump logfile '/oracle/oradata/ora10ctg/redo01.log'
scn min 302586420 scn max 302586468;
2.9對應資料塊scn
SELECT dbms_rowid.rowid_relative_fno(ROWID),
dbms_rowid.rowid_block_number(ROWID)
FROM test_with_pk
WHERE x = 10;
alter system dump datafile 4 block 407;
dump記錄見附件2。
為了觸發塊清理(cleanout)操作,使用如下語句。
select * from test_with_pk for update;
rollback;
alter system dump datafile 4 block 407;
dump記錄見附件3。
3 重做日誌、資料塊分析
透過分析日誌(附件1),可以觀察到:
(1)一個事務由多個REDO RECORD組成:
*在事務的第一個REDO RECORD中,由OP:5.2操作分配回滾段,確定xid;
*事務的最後一個REDO RECORD中,由OP:5.4操作在回滾段頭設定事務結束標誌
(2)一個dml操作redo中,包含如下塊的redo資訊,可能由多個REDO RECORD組成(本次測試中,對資料塊修改和對索引塊的修改分別對應一個REDO RECORD,而且REDO RECORD上的SCN相同):
*回滾段頭
*資料塊:只記錄後像(after image)
*資料塊對應undo塊,對undo塊的修改按rec(以ktudb redo開頭的行中)排序遞增:只記錄前像(before image)
*索引塊
*索引塊對應undo塊,對undo塊的修改按rec(以ktudb redo開頭的行中)排序遞增
*各段點陣圖維護
(3)一個REDO RECORD由多個change vector組成,各個change SCN可能早於REDO RECORD SCN,並且各個change SCN大小關係不確定(不是按順序增加)。
(4)透過分析資料塊,可以觀察到:
*資料塊上的scn(Start dump data blocks...後第二行): 是最後影響該塊操作的scn
*csc: 0x00.120911e5,為最後一次塊清理scn
*事務槽中的fsc,為事務提交時的scn(exact commit scn)
*事務槽中scn,資料更改scn,或塊清理後scn(maybe exact/bigger/smaller than commit scn)
附件1:
++++++++++++++++++++++++++++++++++++++++++++++++++++
v$database.current_scn:0x0000.12091a34
insert into test_with_pk values(7,8,9);
++++++++++++++++++++++++++++++++++++++++++++++++++++
REDO RECORD - Thread:1 RBA: 0x00011f.00001e4b.0010 LEN: 0x0234 VLD: 0x05
SCN: 0x0000.12091a37 SUBSCN: 5 11/14/2018 11:19:46
CHANGE #1 TYP:0 CLS:23 AFN:2 DBA:0x00800039 OBJ:4294967295 SCN:0x0000.12091a08 SEQ: 1 OP:5.2
++++事務開始,分配回滾段,DBA:0x00800039對應回滾段頭block地址
++++Opcode 5.2 : Update rollback segment header - KTURDH
ktudh redo: slt: 0x0025 sqn: 0x00000346 flg: 0x0012 siz: 132 fbi: 0 ++++確定slot,sqn,-->xid: 0x0004.025.00000346
uba: 0x008000a6.02ae.0f pxid: 0x0000.000.00000000 ++++確定uba,seq,rec
CHANGE #2 TYP:0 CLS:24 AFN:2 DBA:0x008000a6 OBJ:4294967295 SCN:0x0000.12091a07 SEQ: 3 OP:5.1
++++對應uba;Opcode 5.1 : Undo block or undo segment header - KTURDB
ktudb redo: siz: 132 spc: 4074 flg: 0x0012 seq: 0x02ae rec: 0x0f ++++事務內,rec++
xid: 0x0004.025.00000346 ++++xid
ktubl redo: slt: 37 rci: 0 opc: 11.1 objn: 59751 objd: 59865 tsn: 4 ++++表id
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
0x00000000 prev ctl uba: 0x008000a6.02ae.0c ++++前一事務uba
prev ctl max cmt scn: 0x0000.12091640 prev tx cmt scn: 0x0000.12091644
txn start scn: 0xffff.ffffffff logon user: 70 prev brb: 8389818 prev bcl: 0 KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
op: Z
KDO Op code: DRP row dependencies Disabled ++++DRP:delete row piece
xtype: XA flags: 0x00000000 bdba: 0x01000197 hdba: 0x01000193
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 0(0x0)
CHANGE #3 TYP:0 CLS: 1 AFN:4 DBA:0x01000197 OBJ:59865 SCN:0x0000.120911e5 SEQ: 1 OP:11.2
++++資料塊,物件id;Opcode 11.2 : Insert Row Piece
KTB Redo
op: 0x01 ver: 0x01
op: F xid: 0x0004.025.00000346 uba: 0x008000a6.02ae.0f ++++對應uba
++++op:F First change to ITL by this TX. Copy redo to ITL
KDO Op code: IRP row dependencies Disabled ++++IRP:insert row piece
xtype: XA flags: 0x00000000 bdba: 0x01000197 hdba: 0x01000193
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 0(0x0) size/delt: 12
fb: --H-FL-- lb: 0x1 cc: 3
null: ---
col 0: [ 2] c1 08
col 1: [ 2] c1 09
col 2: [ 2] c1 0a
CHANGE #4 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ: 0 OP:5.19
++++Opcode 5.19 : Transaction start audit log record
session number = 143
serial number = 95
current username = MH
login username = MH
client info =
OS username = mh
Machine name = \mh
OS terminal = mh
OS process id = 2872:1364
OS program name = PlSqlDev.exe
transaction name =
version 169869568
audit sessionid 1907
REDO RECORD - Thread:1 RBA: 0x00011f.00001e4c.009c LEN: 0x00f0 VLD: 0x01
SCN: 0x0000.12091a37 SUBSCN: 7 11/14/2018 11:19:46
CHANGE #1 TYP:0 CLS:24 AFN:2 DBA:0x008000a6 OBJ:4294967295 SCN:0x0000.12091a37 SEQ: 1 OP:5.1
ktudb redo: siz: 92 spc: 3940 flg: 0x0022 seq: 0x02ae rec: 0x10
xid: 0x0004.025.00000346
ktubu redo: slt: 37 rci: 15 opc: 10.22 objn: 59752 objd: 59864 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: 0x0002.01a.0000037a uba: 0x00800289.03d0.21
flg: C--- lkc: 0 scn: 0x0000.1209122b
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x100019b block=0x0100019c
(kdxlpu): purge leaf row
key :(3): 02 c1 08
CHANGE #2 TYP:0 CLS: 1 AFN:4 DBA:0x0100019c OBJ:59864 SCN:0x0000.12091a37 SEQ: 1 OP:10.2
++++主鍵索引維護
++++Opcode 10.2 : Insert leaf row
index redo (kdxlin): insert leaf row
KTB Redo
op: 0x01 ver: 0x01
op: F xid: 0x0004.025.00000346 uba: 0x008000a6.02ae.10 ++++對應uba
REDO: SINGLE / -- / --
itl: 2, sno: 2, row size 13
insert key: (3): 02 c1 08
keydata: (6): 01 00 01 97 00 00
++++++++++++++++++++++++++++++++++++++++++++++++++++
insert into test_with_pk values(8,9,10);
++++++++++++++++++++++++++++++++++++++++++++++++++++
REDO RECORD - Thread:1 RBA: 0x00011f.00001e4d.0010 LEN: 0x0140 VLD: 0x05
SCN: 0x0000.12091a38 SUBSCN: 1 11/14/2018 11:19:49
CHANGE #1 TYP:0 CLS:24 AFN:2 DBA:0x008000a6 OBJ:4294967295 SCN:0x0000.12091a37 SEQ: 2 OP:5.1
ktudb redo: siz: 92 spc: 3846 flg: 0x0022 seq: 0x02ae rec: 0x11
xid: 0x0004.025.00000346
ktubu redo: slt: 37 rci: 16 opc: 11.1 objn: 59751 objd: 59865 tsn: 4
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.0f
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000197 hdba: 0x01000193
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 1(0x1)
CHANGE #2 TYP:0 CLS: 1 AFN:4 DBA:0x01000197 OBJ:59865 SCN:0x0000.12091a37 SEQ: 1 OP:11.2
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.11
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000197 hdba: 0x01000193
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 1(0x1) size/delt: 12
fb: --H-FL-- lb: 0x1 cc: 3
null: ---
col 0: [ 2] c1 09
col 1: [ 2] c1 0a
col 2: [ 2] c1 0b
REDO RECORD - Thread:1 RBA: 0x00011f.00001e4d.0150 LEN: 0x00d8 VLD: 0x01
SCN: 0x0000.12091a38 SUBSCN: 2 11/14/2018 11:19:49
CHANGE #1 TYP:0 CLS:24 AFN:2 DBA:0x008000a6 OBJ:4294967295 SCN:0x0000.12091a38 SEQ: 1 OP:5.1
ktudb redo: siz: 76 spc: 3752 flg: 0x0022 seq: 0x02ae rec: 0x12
xid: 0x0004.025.00000346
ktubu redo: slt: 37 rci: 17 opc: 10.22 objn: 59752 objd: 59864 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: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.10
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x100019b block=0x0100019c
(kdxlpu): purge leaf row
key :(3): 02 c1 09
CHANGE #2 TYP:0 CLS: 1 AFN:4 DBA:0x0100019c OBJ:59864 SCN:0x0000.12091a37 SEQ: 2 OP:10.2
index redo (kdxlin): insert leaf row
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.12
REDO: SINGLE / -- / --
itl: 2, sno: 3, row size 13
insert key: (3): 02 c1 09
keydata: (6): 01 00 01 97 00 01
++++++++++++++++++++++++++++++++++++++++++++++++++++
insert into test_with_pk values(9,10,11);
++++++++++++++++++++++++++++++++++++++++++++++++++++
...
++++++++++++++++++++++++++++++++++++++++++++++++++++
insert into test_with_pk values(10,11,12);
++++++++++++++++++++++++++++++++++++++++++++++++++++
...
++++++++++++++++++++++++++++++++++++++++++++++++++++
v$database.current_scn:0x0000.12091a44
delete from test_with_pk where x=3;
++++++++++++++++++++++++++++++++++++++++++++++++++++
REDO RECORD - Thread:1 RBA: 0x00011f.00001e5d.0010 LEN: 0x015c VLD: 0x05
SCN: 0x0000.12091a46 SUBSCN: 2 11/14/2018 11:20:13
CHANGE #1 TYP:0 CLS:24 AFN:2 DBA:0x008000a6 OBJ:4294967295 SCN:0x0000.12091a40 SEQ: 2 OP:5.1
ktudb redo: siz: 156 spc: 3330 flg: 0x0022 seq: 0x02ae rec: 0x17
xid: 0x0004.025.00000346
ktubu redo: slt: 37 rci: 22 opc: 11.1 objn: 59751 objd: 59865 tsn: 4
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0009.01d.000003af uba: 0x00800a9e.03a7.03
flg: C--- lkc: 0 scn: 0x0000.12091229
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000198 hdba: 0x01000193
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2) size/delt: 12
fb: --H-FL-- lb: 0x0 cc: 3
null: ---
col 0: [ 2] c1 04
col 1: [ 2] c1 05
col 2: [ 2] c1 06
CHANGE #2 TYP:2 CLS: 1 AFN:4 DBA:0x01000198 OBJ:59865 SCN:0x0000.1209122b SEQ: 1 OP:11.3
++++Opcode 11.3 : Drop Row Piece
KTB Redo
op: 0x01 ver: 0x01
op: F xid: 0x0004.025.00000346 uba: 0x008000a6.02ae.17
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000198 hdba: 0x01000193
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2)
REDO RECORD - Thread:1 RBA: 0x00011f.00001e5d.016c LEN: 0x00d4 VLD: 0x01
SCN: 0x0000.12091a46 SUBSCN: 3 11/14/2018 11:20:13
CHANGE #1 TYP:0 CLS:24 AFN:2 DBA:0x008000a6 OBJ:4294967295 SCN:0x0000.12091a46 SEQ: 1 OP:5.1
ktudb redo: siz: 84 spc: 3172 flg: 0x0022 seq: 0x02ae rec: 0x18
xid: 0x0004.025.00000346
ktubu redo: slt: 37 rci: 23 opc: 10.22 objn: 59752 objd: 59864 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: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.16
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x100019b block=0x0100019c
(kdxlre): restore leaf row (clear leaf delete flags)
key :(3): 02 c1 04
keydata/bitmap: (6): 01 00 01 98 00 02
CHANGE #2 TYP:0 CLS: 1 AFN:4 DBA:0x0100019c OBJ:59864 SCN:0x0000.12091a40 SEQ: 1 OP:10.4
++++Opcode 10.4 : Mark leaf row deleted
index redo (kdxlde): delete leaf row
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.18
REDO: SINGLE / -- / --
itl: 2, sno: 0, row size 13
++++++++++++++++++++++++++++++++++++++++++++++++++++
delete from test_with_pk where x=4;
++++++++++++++++++++++++++++++++++++++++++++++++++++
...
++++++++++++++++++++++++++++++++++++++++++++++++++++
delete from test_with_pk where x=7;
++++++++++++++++++++++++++++++++++++++++++++++++++++
...
++++++++++++++++++++++++++++++++++++++++++++++++++++
delete from test_with_pk where x=8;
++++++++++++++++++++++++++++++++++++++++++++++++++++
REDO RECORD - Thread:1 RBA: 0x00011f.00001e64.0010 LEN: 0x0144 VLD: 0x05
SCN: 0x0000.12091a4c SUBSCN: 1 11/14/2018 11:20:31
CHANGE #1 TYP:0 CLS:24 AFN:2 DBA:0x008000a6 OBJ:4294967295 SCN:0x0000.12091a49 SEQ: 2 OP:5.1
ktudb redo: siz: 140 spc: 2630 flg: 0x0022 seq: 0x02ae rec: 0x1d
xid: 0x0004.025.00000346
ktubu redo: slt: 37 rci: 28 opc: 11.1 objn: 59751 objd: 59865 tsn: 4
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.1b
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000197 hdba: 0x01000193
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 1(0x1) size/delt: 12
fb: --H-FL-- lb: 0x1 cc: 3
null: ---
col 0: [ 2] c1 09
col 1: [ 2] c1 0a
col 2: [ 2] c1 0b
CHANGE #2 TYP:0 CLS: 1 AFN:4 DBA:0x01000197 OBJ:59865 SCN:0x0000.12091a49 SEQ: 1 OP:11.3
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.1d
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000197 hdba: 0x01000193
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 1(0x1)
REDO RECORD - Thread:1 RBA: 0x00011f.00001e64.0154 LEN: 0x00d4 VLD: 0x01
SCN: 0x0000.12091a4c SUBSCN: 2 11/14/2018 11:20:31
CHANGE #1 TYP:0 CLS:24 AFN:2 DBA:0x008000a6 OBJ:4294967295 SCN:0x0000.12091a4c SEQ: 1 OP:5.1
ktudb redo: siz: 84 spc: 2488 flg: 0x0022 seq: 0x02ae rec: 0x1e
xid: 0x0004.025.00000346
ktubu redo: slt: 37 rci: 29 opc: 10.22 objn: 59752 objd: 59864 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: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.1c
Dump kdilk : itl=2, kdxlkflg=0x5 sdc=0 indexid=0x100019b block=0x0100019c
(kdxlre): restore leaf row (clear leaf delete flags)
key :(3): 02 c1 09
keydata/bitmap: (6): 01 00 01 97 00 01
CHANGE #2 TYP:0 CLS: 1 AFN:4 DBA:0x0100019c OBJ:59864 SCN:0x0000.12091a49 SEQ: 1 OP:10.4
index redo (kdxlde): delete leaf row
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x008000a6.02ae.1e
REDO: SINGLE / -- / --
itl: 2, sno: 3, row size 13
++++++++++++++++++++++++++++++++++++++++++++++++++++
v$database.current_scn:0x0000.12091a4e
commit;
++++++++++++++++++++++++++++++++++++++++++++++++++++
REDO RECORD - Thread:1 RBA: 0x00011f.00001e7f.0078 LEN: 0x0060 VLD: 0x01
SCN: 0x0000.12091a62 SUBSCN: 1 11/14/2018 11:21:02
CHANGE #1 TYP:0 CLS:23 AFN:2 DBA:0x00800039 OBJ:4294967295 SCN:0x0000.12091a37 SEQ: 1 OP:5.4
++++DBA:0x00800039,對應回滾段頭DBA
++++SCN:0x0000.12091a37,對應本事務首次修改REDO RECORD SCN,非CHANGE# SCN
++++Opcode 5.4 : Commit transaction (transaction table update)
ktucm redo: slt: 0x0025 sqn: 0x00000346 srt: 0 sta: 9 flg: 0x2 ++++對應xid: 0x0004.025.00000346
ktucf redo: uba: 0x008000a6.02ae.1e ext: 3 spc: 2402 fbi: 0 ++++0x008000a6.02ae.1e,本事務最後一次改動對應的uba
++++++++++++++++++++++++++++++++++++++++++++++++++++
v$database.current_scn:0x0000.12091a64
++++++++++++++++++++++++++++++++++++++++++++++++++++
附件2
Start dump data blocks tsn: 4 file#: 4 minblk 407 maxblk 407
buffer tsn: 4 rdba: 0x01000197 (4/407)
scn: 0x0000.12091a62 seq: 0x01 flg: 0x06 tail: 0x1a620601 ++++scn: fast cleanout scn(事務提交scn)
frmt: 0x02 chkval: 0x5ed5 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0E4D8A00 to 0x0E4DAA00
...
Block header dump: 0x01000197
Object id on Block? Y
seg/obj: 0xe9d9 csc: 0x00.120911e5 itc: 2 flg: E typ: 1 - DATA
++++csc: 0x00,fast cleanout scn wrap;120911e5,清理(cleanout)scn base,本次測試前5小時scn
brn: 0 bdba: 0x1000191 ver: 0x01 opc: 0 ++++bdba:level 1 bitmap block
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0004.025.00000346 0x008000a6.02ae.1d --U- 4 fsc 0x0014.12091a62
++++xid:對應logfile中xid
++++Flag:--U-表示fast cleanout,upper bound scn
++++uba:對應xid事務中最後一個dml操作對應的undo block
++++fsc:0x0014,free space creidt;12091a62 commit scn base.
++++lck:4表示總共鎖定4行,fast cleanout沒有清理
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
data_block_dump,data header at 0xe4d8a64
===============
tsiz: 0x1f98
hsiz: 0x1a
pbl: 0x0e4d8a64
bdba: 0x01000197
76543210
flag=--------
ntab=1
nrow=4
frre=-1
fsbo=0x1a
fseo=0x1f68
avsp=0x1f4e
tosp=0x1f66
0xe:pti[0] nrow=4 offs=0
0x12:pri[0] offs=0x1f8c
0x14:pri[1] offs=0x1f80
0x16:pri[2] offs=0x1f74
0x18:pri[3] offs=0x1f68
block_row_dump:
tab 0, row 0, @0x1f8c
tl: 2 fb: --HDFL-- lb: 0x1
tab 0, row 1, @0x1f80
tl: 2 fb: --HDFL-- lb: 0x1
tab 0, row 2, @0x1f74
tl: 12 fb: --H-FL-- lb: 0x1 cc: 3
col 0: [ 2] c1 0a
col 1: [ 2] c1 0b
col 2: [ 2] c1 0c
tab 0, row 3, @0x1f68
tl: 12 fb: --H-FL-- lb: 0x1 cc: 3
col 0: [ 2] c1 0b
col 1: [ 2] c1 0c
col 2: [ 2] c1 0d
end_of_block_dump
End dump data blocks tsn: 4 file#: 4 minblk 407 maxblk 407
附件3
Start dump data blocks tsn: 4 file#: 4 minblk 407 maxblk 407
buffer tsn: 4 rdba: 0x01000197 (4/407)
scn: 0x0000.12094bd5 seq: 0x02 flg: 0x00 tail: 0x4bd50602 ++++scn:csc SCN,csc: 0x00.12094bd3
++++seq:seq++
frmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0E417A00 to 0x0E419A00
...
Block header dump: 0x01000197
Object id on Block? Y
seg/obj: 0xe9d9 csc: 0x00.12094bd3 itc: 2 flg: E typ: 1 - DATA ++++csc:無活躍事務時max(cleanout scn,scn_tx) or 有活躍事務時min(hitime_scn)
brn: 0 bdba: 0x1000191 ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0004.025.00000346 0x008000a6.02ae.1d C--- 0 scn 0x0000.12091a62
++++Flag:C-commit
++++Lck:0
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
data_block_dump,data header at 0xe417a64
===============
tsiz: 0x1f98
hsiz: 0x1a
pbl: 0x0e417a64
bdba: 0x01000197
76543210
flag=--------
ntab=1
nrow=4
frre=0
fsbo=0x1a
fseo=0x1f68
avsp=0x1f66
tosp=0x1f66
0xe:pti[0] nrow=4 offs=0 ++++nrows,仍然為4
0x12:pri[0] sfll=1
0x14:pri[1] sfll=-1
0x16:pri[2] offs=0x1f74
0x18:pri[3] offs=0x1f68
block_row_dump:
tab 0, row 2, @0x1f74
tl: 12 fb: --H-FL-- lb: 0x0 cc: 3 ++++鎖已清除
col 0: [ 2] c1 0a
col 1: [ 2] c1 0b
col 2: [ 2] c1 0c
tab 0, row 3, @0x1f68
tl: 12 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 2] c1 0b
col 1: [ 2] c1 0c
col 2: [ 2] c1 0d
end_of_block_dump
End dump data blocks tsn: 4 file#: 4 minblk 407 maxblk 407
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/18922393/viewspace-700459/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 重做日誌基礎操作
- logmnr分析線上重做日誌
- 使用Logminer來分析具體的DML操作日誌
- 重做日誌
- 聯機重做日誌、歸檔日誌、備用重做日誌
- logmnr分析歸檔重做日誌
- 重做日誌檔案的相關操作
- 重做日誌管理
- 日誌挖掘-對於DML操作的挖掘
- [20170412]分析重做日誌.txt
- 為oracle新增重做日誌組及重做日誌成員Oracle
- redo重做日誌管理
- Oracle的重做日誌Oracle
- 恢復重做日誌
- MySQL重做日誌(redo log)MySql
- 重做日誌的恢復
- oracle 恢復重做日誌Oracle
- 日誌分析常規操作
- oracle線上調整重做日誌Oracle
- 手工建立多路重做日誌組
- 重做日誌大小的設定
- Oracle重做日誌調整技巧Oracle
- Oracle11g redo log 建立、新增、刪除(重做日誌組,重做日誌檔案)Oracle
- 16、重做日誌檔案的狀態及重做日誌組的狀態說明
- Oracle重做日誌檔案基礎Oracle
- oracle 聯機重做日誌檔案Oracle
- 重做日誌檔案中的SCN
- SQL Server重做日誌管理機制SQLServer
- 7.管理重做日誌(筆記)筆記
- 2 Day DBA-管理Oracle例項-管理聯機重做日誌- 多路複用聯機重做日誌Oracle
- 日誌分析-apache日誌分析Apache
- 重做日誌檔案損壞測試
- 線上修改重做日誌檔案的大小
- 修改Oracle重做日誌檔案的大小Oracle
- 重做日誌(redo log)相關總結
- 丟失重做日誌怎麼處理
- 丟失重做日誌讀書筆記筆記
- 怎樣改變重做日誌的大小