手工提交Cluster Table的事务
cluster
table
事務
提交
文章
本站文章除注明转载外，均为本站原创： 转载自love wife love life —Roger 的Oracle技术博客 本文链接地址: 手工提交Cluster Table的事务 前几天培训班中有学生问到,对于cluster table如果去实现手工提交事务,来屏蔽一些错误.他在自己的 环境中遇到了ora-00
本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客
本文链接地址: 手工提交Cluster Table的事务
前几天培训班中有学生问到,对于cluster table如果去实现手工提交事务,来屏蔽一些错误.他在自己的
环境中遇到了ora-00600 4000错误,涉及的对象即为cluster table,下面我这里简单模拟了一下。供参考!
++++创建测试表
SQL> conn roger/roger Connected. SQL> create cluster t_cluster(id number(2)) ; Cluster created. SQL> create table t_0610 2 (id number(2) primary key, 3 name varchar2(13)) 4 cluster t_cluster(id); Table created. SQL> create index t_cluster_idx on cluster t_cluster; Index created. SQL> SQL> insert into t_0610 values(1,'baidu'); 1 row created. SQL> insert into t_0610 values(2,'google'); 1 row created. SQL> insert into t_0610 values(8,'roger'); 1 row created. SQL> commit; Commit complete. SQL> select * from t_0610; ID NAME ---------- ------------- 1 baidu 2 google 8 roger SQL> select dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) blk# 2 from t_0610; FILE# BLK# ---------- ---------- 6 172 6 173 6 174 SQL> oradebug setmypid ORA-01031: insufficient privileges SQL> conn /as sysdba Connected. SQL> oradebug setmypid Statement processed. SQL> alter system flush buffer_cache; System altered. SQL> alter system dump datafile 6 block 172; System altered. SQL> oradebug close_trace Statement processed. SQL> oradebug tracefile_name /oracle/diag/rdbms/roger/roger/trace/roger_ora_16777.trc
登入後複製
++++blockdump内容
Dump of buffer cache at level 4 for tsn=7 rdba=25165996 BH (0x71bf2f28) file#: 6 rdba: 0x018000ac (6/172) class: 1 ba: 0x71ad8000 set: 3 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 0,15 dbwrid: 0 obj: 77519 objn: 77520 tsn: 7 afn: 6 hint: f hash: [0x8abfa738,0x8abfa738] lru: [0x74ff33a0,0x7abf47d0] lru-flags: on_auxiliary_list ckptq: [NULL] fileq: [NULL] objq: [NULL] objaq: [NULL] st: FREE md: NULL fpin: 'ktspbwh2: ktspfmdb' tch: 0 lfb: 33 flags: Block dump from disk: buffer tsn: 7 rdba: 0x018000ac (6/172) scn: 0x0000.00b941a6 seq: 0x01 flg: 0x06 tail: 0x41a60601 frmt: 0x02 chkval: 0xcb52 type: 0x06=trans data Hex dump of block: st=0, typ_found=1 Dump of memory from 0x00007FADB771EA00 to 0x00007FADB7720A00 7FADB771EA00 0000A206 018000AC 00B941A6 06010000 [.........A......] 7FADB771EA10 0000CB52 00000001 00012ECF 00B94199 [R............A..] 7FADB771EA20 00000000 00320002 018000A8 00080006 [......2.........] 7FADB771EA30 00000515 00C00562 002E014E 00008000 [....b...N.......] 7FADB771EA40 00B94198 001D0007 000004C9 00C03C08 [.A...........<.. ...a...... repeat times block header dump: object id on y seg csc: itc: flg: e typ: data brn: bdba: ver: opc: inc: exflg: itl xid uba flag lck scn c--- fsc data_block_dump at tsiz: hsiz: pbl: ntab="2"> 大于2，说明这是一个cluster table nrow=2 frre=-1 fsbo=0x1a fseo=0x1f78 avsp=0x1f5e tosp=0x1f5e 0xe:pti[0] nrow=1 offs=0 0x12:pti[1] nrow=1 offs=1 0x16:pri[0] offs=0x1f82 0x18:pri[1] offs=0x1f78 block_row_dump: tab 0, row 0, @0x1f82 tl: 22 fb: K-H-FL-- lb: 0x0 cc: 1 curc: 1 comc: 1 pk: 0x018000ac.0 nk: 0x018000ac.0 col 0: [ 2] c1 02 tab 1, row 0, @0x1f78 tl: 10 fb: -CH-FL-- lb: 0x2 cc: 1 cki: 0 col 0: [ 5] 62 61 69 64 75 end_of_block_dump End dump data blocks tsn: 7 file#: 6 minblk 172 maxblk 172</..>
登入後複製
大家可以看到，这跟普通的data block的dump内容是有所差别的，因为这里涉及到cluster table。
下面来模拟下手工提交cluster table的事务。
+++++模拟事务不提交
SQL> alter system checkpoint; System altered. SQL> alter system flush buffer_cache; System altered. SQL> show user USER is "SYS" SQL> conn roger/roger Connected. SQL> delete from t_0610 where id=8; ++++++不提交 1 row deleted. SQL> alter system flush buffer_cache; System altered. SQL> select xidusn,xidslot,xidsqn,ubablk,ubafil,ubarec from v$transaction; XIDUSN XIDSLOT XIDSQN UBABLK UBAFIL UBAREC ---------- ---------- ---------- ---------- ---------- ---------- 3 17 1212 1066 3 20 SQL>
登入後複製
这里我们可以看到对于这个未提交的事务XID为：3.17.1212? 前面我们已经知道
测试表中的数据分布在3个block中，这里我模拟的情况是删除第3条数据，且不提交，通过bbed来实现手工
提交这个未提交事务，注意：第3条数据是在第3个block中，即174 block。
+++++首先修改表的itl等信息
BBED> set file 6 block 174 FILE# 6 BLOCK# 174 BBED> map File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Dba:0x018000ae ------------------------------------------------------------ KTB Data Block (Table/Cluster) struct kcbh, 20 bytes @0 struct ktbbh, 72 bytes @20 struct kdbh, 14 bytes @100 struct kdbt[2], 8 bytes @114 sb2 kdbr[2] @122 ub1 freespace[8030] @126 ub1 rowdata[32] @8156 ub4 tailchk @8188 BBED> p kdbr sb2 kdbr[0] @122 8066 sb2 kdbr[1] @124 8056 BBED> p ktbbh struct ktbbh, 72 bytes @20 ub1 ktbbhtyp @20 0x01 (KDDBTDATA) union ktbbhsid, 4 bytes @24 ub4 ktbbhsg1 @24 0x00012ecf ub4 ktbbhod1 @24 0x00012ecf struct ktbbhcsc, 8 bytes @28 ub4 kscnbas @28 0x00b94309 ub2 kscnwrp @32 0x0000 sb2 ktbbhict @36 2 ub1 ktbbhflg @38 0x32 (NONE) ub1 ktbbhfsl @39 0x00 ub4 ktbbhfnx @40 0x018000a8 struct ktbbhitl[0], 24 bytes @44 struct ktbitxid, 8 bytes @44 ub2 kxidusn @44 0x0009 ub2 kxidslt @46 0x0002 ub4 kxidsqn @48 0x0000044c struct ktbituba, 8 bytes @52 ub4 kubadba @52 0x00c000f9 ub2 kubaseq @56 0x014a ub1 kubarec @58 0x1d ub2 ktbitflg @60 0x8000 (KTBFCOM) union _ktbitun, 2 bytes @62 sb2 _ktbitfsc @62 0 ub2 _ktbitwrp @62 0x0000 ub4 ktbitbas @64 0x00b941a4 struct ktbbhitl[1], 24 bytes @68 struct ktbitxid, 8 bytes @68 ub2 kxidusn @68 0x0003 ub2 kxidslt @70 0x0011 ub4 kxidsqn @72 0x000004bc struct ktbituba, 8 bytes @76 ub4 kubadba @76 0x00c0042a ub2 kubaseq @80 0x0185 ub1 kubarec @82 0x13 ub2 ktbitflg @84 0x0001 (NONE) union _ktbitun, 2 bytes @86 sb2 _ktbitfsc @86 6 ub2 _ktbitwrp @86 0x0006 ub4 ktbitbas @88 0x00000000 BBED> modify /x 0180 Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Offsets: 84 to 87 Dba:0x018000ae ------------------------------------------------------------------------ 01800600 BBED> modify /x 00 offset 86 File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Offsets: 86 to 87 Dba:0x018000ae ------------------------------------------------------------------------ 0000 BBED> sum apply Check value for File 6, Block 174: current = 0x055c, required = 0x055c BBED> verify DBVERIFY - Verification starting FILE = /oracle/oradata/roger/roger01.dbf BLOCK = 174 Block Checking: DBA = 25165998, Block Type = KTB-managed data block data header at 0x7f88d49c1264 kdbchk: row locked by non-existent transaction table=1 slot=0 lockid=2 ktbbhitc=2 Block 174 failed with check code 6101 BBED> p *kdbr[1] rowdata[0] ---------- ub1 rowdata[0] @8156 0x7c BBED> x /rnnnnccccccnnnnnnnnnnn rowdata[0] @8156 ---------- flag@8156: 0x7c (KDRHFL, KDRHFF, KDRHFD, KDRHFH, KDRHFC) lock@8157: 0x02 cols@8158: 0 BBED> modify /x 6c offset 8156 File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Offsets: 8156 to 8159 Dba:0x018000ae ------------------------------------------------------------------------ 6c020100 BBED> sum apply Check value for File 6, Block 174: current = 0x054c, required = 0x054c BBED> verify DBVERIFY - Verification starting FILE = /oracle/oradata/roger/roger01.dbf BLOCK = 174 Block Checking: DBA = 25165998, Block Type = KTB-managed data block data header at 0x1112864 kdbchk: row locked by non-existent transaction table=1 slot=0 lockid=2 ktbbhitc=2 Block 174 failed with check code 6101 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 1 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED BBED> p kdbh struct kdbh, 14 bytes @100 ub1 kdbhflag @100 0x01 (KDBHFFK) sb1 kdbhntab @101 2 sb2 kdbhnrow @102 2 sb2 kdbhfrre @104 -1 sb2 kdbhfsbo @106 26 sb2 kdbhfseo @108 8056 sb2 kdbhavsp @110 8030 sb2 kdbhtosp @112 8040 BBED> d /v offset 102 count 4 File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Offsets: 102 to 105 Dba:0x018000ae ------------------------------------------------------- 0200ffff l .... BBED> modify /x 01 offset 102 File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Offsets: 102 to 105 Dba:0x018000ae ------------------------------------------------------------------------ 0100ffff BBED> sum apply Check value for File 6, Block 174: current = 0x054f, required = 0x054f BBED> verify DBVERIFY - Verification starting FILE = /oracle/oradata/roger/roger01.dbf BLOCK = 174 Block Checking: DBA = 25165998, Block Type = KTB-managed data block data header at 0x1112864 kdbchk: fsbo(26) wrong, (hsz 24) Block 174 failed with check code 6129 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 1 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED BBED> d /v offset 106 File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Offsets: 106 to 109 Dba:0x018000ae ------------------------------------------------------- 1a00781f l ..x. BBED> modify /x 18 offset 106 File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Offsets: 106 to 109 Dba:0x018000ae ------------------------------------------------------------------------ 1800781f BBED> sum apply Check value for File 6, Block 174: current = 0x054d, required = 0x054d BBED> verify DBVERIFY - Verification starting FILE = /oracle/oradata/roger/roger01.dbf BLOCK = 174 Block Checking: DBA = 25165998, Block Type = KTB-managed data block data header at 0x1112864 kdbchk: row count in table index incorrect Block 174 failed with check code 6125 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 1 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED BBED> p kdbt struct kdbt[0], 4 bytes @114 sb2 kdbtoffs @114 0 sb2 kdbtnrow @116 1 struct kdbt[1], 4 bytes @118 sb2 kdbtoffs @118 1 sb2 kdbtnrow @120 1 BBED> p kdbt[1] struct kdbt[1], 4 bytes @118 sb2 kdbtoffs @118 1 sb2 kdbtnrow @120 1 BBED> d /v offset 118 count 4 File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Offsets: 118 to 121 Dba:0x018000ae ------------------------------------------------------- 01000100 l .... BBED> modify /x 000000 offset 118 File: /oracle/oradata/roger/roger01.dbf (6) Block: 174 Offsets: 118 to 121 Dba:0x018000ae ------------------------------------------------------------------------ 00000000 BBED> sum apply Check value for File 6, Block 174: current = 0x054d, required = 0x054d BBED> verify DBVERIFY - Verification starting FILE = /oracle/oradata/roger/roger01.dbf BLOCK = 174 Block Checking: DBA = 25165998, Block Type = KTB-managed data block data header at 0x1112864 kdbchk: table index offset incorrect tab 1 Block 174 failed with check code 6124 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 1 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED
登入後複製
我们可以看到，无论怎么修改，这个block通过bbed进行检测都报错，这里不是因为修改的不对,而是因为
还需要修改cluster 上的Index信息。通过treedump 我们可以确认index block为file 6 block 187.
+++++ dump Index block
SQL> oradebug setmypid Statement processed. SQL> alter system dump datafile 6 block 187; System altered. SQL> oradebug close_trace Statement processed. SQL> oradebug tracefile_name /oracle/diag/rdbms/roger/roger/trace/roger_ora_17394.trc SQL>
登入後複製
+++++ dump 内容如下
Block header dump: 0x018000bb Object id on Block? Y seg/obj: 0x12ed2 csc: 0x00.b941a3 itc: 2 flg: E typ: 2 - INDEX brn: 0 bdba: 0x18000b8 ver: 0x01 opc: 0 inc: 0 exflg: 0 Itl Xid Uba Flag Lck Scn/Fsc 0x01 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000 0x02 0x0009.002.0000044c 0x00c000f9.014a.1e --U- 1 fsc 0x0000.00b941a4 Leaf block dump =============== header address 140553058142820=0x7fd50f1a4a64 kdxcolev 0 KDXCOLEV Flags = - - - kdxcolok 0 kdxcoopc 0x80: opcode=0: iot flags=--- is converted=Y kdxconco 1 kdxcosdc 0 kdxconro 3 kdxcofbo 42=0x2a kdxcofeo 7993=0x1f39 kdxcoavs 7951 kdxlespl 0 kdxlende 0 kdxlenxt 0=0x0 kdxleprv 0=0x0 kdxledsz 8 kdxlebksz 8032 row#0[8019] flag: ------, lock: 0, len=13, data:(8): 01 80 00 ac 00 00 01 00 col 0; len 2; (2): c1 02 row#1[8006] flag: ------, lock: 0, len=13, data:(8): 01 80 00 ad 00 00 01 00 col 0; len 2; (2): c1 03 row#2[7993] flag: ------, lock: 2, len=13, data:(8): 01 80 00 ae 00 00 01 00 col 0; len 2; (2): c1 09 ----- end of leaf block dump -----
登入後複製
可以看到，该index block中还存在3个index entry信息，我们需要将第3条信息给删掉，首先计算一下offset：
SQL> select 7993+76+24 from dual; 7993+76+24 ---------- 8093
登入後複製
+++++利用bbed修改 index block
BBED> set file 6 block 187 FILE# 6 BLOCK# 187 BBED> map File: /oracle/oradata/roger/roger01.dbf (6) Block: 187 Dba:0x018000bb ------------------------------------------------------------ KTB Data Block (Index Leaf) struct kcbh, 20 bytes @0 struct ktbbh, 72 bytes @20 struct kdxle, 32 bytes @100 sb2 kd_off[3] @132 ub1 freespace[7951] @138 ub1 rowdata[39] @8089 ub4 tailchk @8188 BBED> set offset 8093 OFFSET 8093 BBED> x /rn rowdata[4] @8093 ---------- flag@8093: 0x00 (NONE) lock@8094: 0x02 keydata[8]: 0x01 0x80 0x00 0xae 0x00 0x00 0x01 0x00 data key: col 0[2] @8104: 8 BBED> map File: /oracle/oradata/roger/roger01.dbf (6) Block: 187 Dba:0x018000bb ------------------------------------------------------------ KTB Data Block (Index Leaf) struct kcbh, 20 bytes @0 struct ktbbh, 72 bytes @20 struct kdxle, 32 bytes @100 sb2 kd_off[3] @132 ub1 freespace[7951] @138 ub1 rowdata[39] @8089 ub4 tailchk @8188 BBED> p kdxle struct kdxle, 32 bytes @100 struct kdxlexco, 16 bytes @100 ub1 kdxcolev @100 0x00 ub1 kdxcolok @101 0x00 ub1 kdxcoopc @102 0x80 ub1 kdxconco @103 0x01 ub4 kdxcosdc @104 0x00000000 sb2 kdxconro @108 3 sb2 kdxcofbo @110 42 sb2 kdxcofeo @112 7993 sb2 kdxcoavs @114 7951 sb2 kdxlespl @116 0 sb2 kdxlende @118 0 ub4 kdxlenxt @120 0x00000000 ub4 kdxleprv @124 0x00000000 ub1 kdxledsz @128 0x08 ub1 kdxleflg @129 0x00 (NONE) BBED> d /v offset 118 count 2 File: /oracle/oradata/roger/roger01.dbf (6) Block: 187 Offsets: 118 to 119 Dba:0x018000bb ------------------------------------------------------- 0000 l .. BBED> modify /x 01 offset 118 File: /oracle/oradata/roger/roger01.dbf (6) Block: 187 Offsets: 118 to 119 Dba:0x018000bb ------------------------------------------------------------------------ 0100 BBED> sum apply Check value for File 6, Block 187: current = 0x4faa, required = 0x4faa BBED> verify DBVERIFY - Verification starting FILE = /oracle/oradata/roger/roger01.dbf BLOCK = 187 Block Checking: DBA = 25166011, Block Type = KTB-managed data block **** actual rows marked deleted = 0 != kdxlende = 1 ---- end index block validation Block 187 failed with check code 6401 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 0 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 1 Total Blocks Failing (Index): 1 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED BBED> set offset 8093 OFFSET 8093 BBED> x /rn rowdata[4] @8093 ---------- flag@8093: 0x00 (NONE) lock@8094: 0x02 keydata[8]: 0x01 0x80 0x00 0xae 0x00 0x00 0x01 0x00 data key: col 0[2] @8104: 8 BBED> modify /x 01 offset 8093 File: /oracle/oradata/roger/roger01.dbf (6) Block: 187 Offsets: 8093 to 8094 Dba:0x018000bb ------------------------------------------------------------------------ 0102 BBED> sum apply Check value for File 6, Block 187: current = 0x4eaa, required = 0x4eaa BBED> verify DBVERIFY - Verification starting FILE = /oracle/oradata/roger/roger01.dbf BLOCK = 187 Block Checking: DBA = 25166011, Block Type = KTB-managed data block **** actual free space credit for itl 2 = 15 != # in trans. hdr = 0 ---- end index block validation Block 187 failed with check code 6401 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 0 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 1 Total Blocks Failing (Index): 1 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED BBED> map File: /oracle/oradata/roger/roger01.dbf (6) Block: 187 Dba:0x018000bb ------------------------------------------------------------ KTB Data Block (Index Leaf) struct kcbh, 20 bytes @0 struct ktbbh, 72 bytes @20 struct kdxle, 32 bytes @100 sb2 kd_off[3] @132 ub1 freespace[7951] @138 ub1 rowdata[39] @8089 ub4 tailchk @8188 BBED> p ktbbh struct ktbbh, 72 bytes @20 ub1 ktbbhtyp @20 0x02 (KDDBTINDEX) union ktbbhsid, 4 bytes @24 ub4 ktbbhsg1 @24 0x00012ed2 ub4 ktbbhod1 @24 0x00012ed2 struct ktbbhcsc, 8 bytes @28 ub4 kscnbas @28 0x00b941a3 ub2 kscnwrp @32 0x0000 sb2 ktbbhict @36 2 ub1 ktbbhflg @38 0x32 (NONE) ub1 ktbbhfsl @39 0x00 ub4 ktbbhfnx @40 0x018000b8 struct ktbbhitl[0], 24 bytes @44 struct ktbitxid, 8 bytes @44 ub2 kxidusn @44 0x0000 ub2 kxidslt @46 0x0000 ub4 kxidsqn @48 0x00000000 struct ktbituba, 8 bytes @52 ub4 kubadba @52 0x00000000 ub2 kubaseq @56 0x0000 ub1 kubarec @58 0x00 ub2 ktbitflg @60 0x0000 (NONE) union _ktbitun, 2 bytes @62 sb2 _ktbitfsc @62 0 ub2 _ktbitwrp @62 0x0000 ub4 ktbitbas @64 0x00000000 struct ktbbhitl[1], 24 bytes @68 struct ktbitxid, 8 bytes @68 ub2 kxidusn @68 0x0009 ub2 kxidslt @70 0x0002 ub4 kxidsqn @72 0x0000044c struct ktbituba, 8 bytes @76 ub4 kubadba @76 0x00c000f9 ub2 kubaseq @80 0x014a ub1 kubarec @82 0x1e ub2 ktbitflg @84 0x2001 (KTBFUPB) union _ktbitun, 2 bytes @86 sb2 _ktbitfsc @86 0 ub2 _ktbitwrp @86 0x0000 ub4 ktbitbas @88 0x00b941a4 BBED> d /v offset 86 count 2 File: /oracle/oradata/roger/roger01.dbf (6) Block: 187 Offsets: 86 to 87 Dba:0x018000bb ------------------------------------------------------- 0000 l .. BBED> modify /x 0f offset 86 File: /oracle/oradata/roger/roger01.dbf (6) Block: 187 Offsets: 86 to 87 Dba:0x018000bb ------------------------------------------------------------------------ 0f00 BBED> sum apply Check value for File 6, Block 187: current = 0x4ea5, required = 0x4ea5 BBED> verify DBVERIFY - Verification starting FILE = /oracle/oradata/roger/roger01.dbf BLOCK = 187 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 0 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 1 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED
登入後複製
到这里，我们完成了Index Block的修改，最后我们再来校验一下前面的data block，你会发现已经ok了，如下：
BBED> set file 2 block 174
FILE#?????????? 2
BLOCK#????????? 174
BBED> verify
DBVERIFY – Verification starting
FILE = /oracle/oradata/roger/sysaux01.dbf
BLOCK = 174
DBVERIFY – Verification complete
Total Blocks Examined???????? : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing?? (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing?? (Index): 0
Total Blocks Empty??????????? : 1
Total Blocks Marked Corrupt?? : 0
Total Blocks Influx?????????? : 0
Message 531 not found;? product=RDBMS; facility=BBED
BBED>
+++++ 最后来验证下数据
SQL> alter system flush buffer_cache; System altered. SQL> select * from roger.t_0610; ID NAME ---------- ------------- 1 baidu 2 google
登入後複製
至此，整个模拟测试结束，供参考！
Related posts:
- 创建index之前如何确定其大小
- ora-00600 [kddummy_blkchk] solution
- 如何修复未格式化的坏块？
- Archivelog 模式下，datafile header损坏，如何恢复？
- datafile 也能跨resetlogs ？
本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客 本文链接地址: 手工提交Cluster Table的事务 前几天培训班中有学生问到,对于cluster table如果去实现手工提交事务,来屏蔽一些错误.他在自己的 环境中遇到了ora-00600 4000错误,涉及的对象即为cluster table,下面我这里简单模拟了一下。供参考! ++++创建测试表 SQL> conn roger/roger Connected. SQL> create cluster t_cluster(id number(2)) ; Cluster created. SQL> create table t_0610 2 (id number(2) primary key, 3 name varchar2(13)) 4 cluster t_cluster(id); Table created. SQL> create index t_cluster_idx on cluster t_cluster; Index created. [...]
本網站聲明
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn
熱AI工具
Undresser.AI Undress
人工智慧驅動的應用程序，用於創建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Undress AI Tool
免費脫衣圖片
Clothoff.io
AI脫衣器
Video Face Swap
使用我們完全免費的人工智慧換臉工具，輕鬆在任何影片中換臉！
熱門文章
Windows 11 KB5054979中的新功能以及如何解決更新問題
3 週前
By DDD
如何修復KB5055523無法在Windows 11中安裝？
2 週前
By DDD
Inzoi：如何申請學校和大學
4 週前
By DDD
如何修復KB5055518無法在Windows 10中安裝？
2 週前
By DDD
Roblox：Dead Rails - 如何召喚和擊敗Nikola Tesla
4 週前
By 尊渡假赌尊渡假赌尊渡假赌
熱工具
記事本++7.3.1
好用且免費的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強大的PHP整合開發環境
Dreamweaver CS6
視覺化網頁開發工具
SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)
今日頭條發布文章怎麼有收益？今日頭條發布文章獲得更多收益方法！
Mar 15, 2024 pm 04:13 PM
一、今日頭條發布文章怎麼有收益？今日頭條發布文章獲得更多收益方法！ 1.開通基礎權益：原創文章選擇投放廣告可獲得收益，影片必須原創橫屏才會有收益。 2.開通百粉權益：粉絲量達百粉以上，微頭條、原創問答創作及問答均可獲得收益。 3.堅持原創作品：原創作品包含文章、微標題及問題等，要求300字以上。注意違規抄襲作品作為原創發布，會被扣信用分，即使有收益也會被扣除。 4.垂直度：做專業領域一類的文章，不能隨意跨領域寫文章，會得不到合適的推薦，達不到作品的專和精，難以吸引粉絲讀者。 5.活躍度：活躍度高，
Lock wait timeout exceeded; try restarting transaction - 如何解決MySQL報錯：事務等待逾時
Oct 05, 2023 am 08:46 AM
Lockwaittimeoutexceeded;tryrestartingtransaction-如何解決MySQL報錯：事務等待逾時在使用MySQL資料庫時，有時可能會遇到一個常見的錯誤：Lockwaittimeoutexceeded;tryrestartingtransaction，該錯誤表示事務等待逾時。這個錯誤通常發生在並且
MySQL事務處理：自動提交與手動提交的區別
Mar 16, 2024 am 11:33 AM
MySQL事務處理：自動提交與手動提交的差異在MySQL資料庫中，事務是一組SQL語句的集合，要麼全部執行成功，要麼全部執行失敗，保證了資料的一致性和完整性。在MySQL中，事務可以分為自動提交和手動提交，其區別在於事務提交的時機以及對事務的控制範圍。以下將詳細介紹自動提交和手動提交的區別，並給出具體的程式碼範例來說明。一、自動提交在MySQL中，如果沒有顯示
PHP PDO教學：從基礎到精通的進階指南
Feb 19, 2024 pm 06:30 PM
1.PDO簡介PDO是PHP的擴充庫，它提供了一個物件導向的方式來操作資料庫。 PDO支援多種資料庫，包括Mysql、postgresql、oracle、SQLServer等。 PDO使開發人員能夠使用統一的api來操作不同的資料庫，這使得開發人員可以在不同的資料庫之間輕鬆切換。 2.PDO連接資料庫要使用PDO連接資料庫，首先需要建立一個PDO物件。 PDO物件的建構函式接收三個參數：資料庫類型、主機名稱、資料庫使用者名稱和密碼。例如，以下程式碼建立了一個連接到mysql資料庫的物件：$dsn="mysq
MongoDB技術開發中遇到的事務管理問題解決方案分析
Oct 08, 2023 am 08:15 AM
MongoDB技術開發中遇到的事務管理問題解決方案分析隨著現代應用程式變得越來越複雜和龐大，對資料的事務處理需求也越來越高。作為一種流行的NoSQL資料庫，MongoDB在資料管理方面有著出色的效能和擴展性。然而，MongoDB在資料一致性和事務管理方面相對較弱，為開發人員帶來了挑戰。在本文中，我們將探討在MongoDB開發中遇到的事務管理問題，並提出一些解
Java資料庫連線如何處理事務和並發？
Apr 16, 2024 am 11:42 AM
事務確保資料庫資料完整性，包括原子性、一致性、隔離性和持久性。 JDBC使用Connection介面提供交易控制（setAutoCommit、commit、rollback）。並發控制機制協調並發操作，使用鎖或樂觀/悲觀並發控制來實現事務隔離性，以防止資料不一致。
MySQL事務的原理及應用場景
Mar 02, 2024 am 09:51 AM
MySQL事務的原理及應用場景在資料庫系統中，事務是一組SQL操作的集合，這些操作要麼全部成功執行，要麼全部失敗回滾。 MySQL作為一種常用的關聯式資料庫管理系統，支援事務的特性，能夠確保資料庫中的資料在一致性、隔離性、持久性和原子性方面得到保證。本文將從MySQL事務的基本原理入手，介紹其應用場景，並提供具體的程式碼範例供讀者參考。 MySQL事務的原理：My
掌握 PHP PDO 的力量：進階查詢與更新
Feb 20, 2024 am 08:24 AM
PHP資料物件（PDO）擴充功能提供了與資料庫伺服器高效且物件導向的互動。其高級查詢和更新功能使開發人員能夠執行複雜的資料庫操作，從而提高效能和程式碼可維護性。本文將深入探討PDO的高階查詢與更新功能，引導您掌握其強大功能。進階查詢：使用佔位符和綁定參數佔位符和綁定參數是提高查詢效能和安全性的重要工具。佔位符使用問號(?)表示查詢中可替換的參數，而綁定參數則允許指定每個參數的資料類型和值。透過使用這些方法，您可以避免sql注入攻擊並提高效能，因為資料庫引擎可以提前最佳化查詢。 //使用佔位符$stmt=$
