本文共 5313 字，大约阅读时间需要 17 分钟。
[20160531]windows下bbed修复corrupt数据块.txt
--昨天别人的问题,使用windows下的bbed修复corrupt数据块报错.我自己也重复测试看看:
--bbed在windows的安装看:1.环境:
SCOTT@book> @ &r/ver1
PORT_STRING VERSION BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionSCOTT@book> create table dept2 tablespace tea as select * from dept ;
Table created.SCOTT@book> select ora_rowscn,rowid,dept2.* from dept2 ;
ORA_ROWSCN ROWID DEPTNO DNAME LOC ------------ ------------------ ------------ -------------- ------------- 13238134154 AAAW9NAAHAAAACDAAA 10 ACCOUNTING NEW YORK 13238134154 AAAW9NAAHAAAACDAAB 20 RESEARCH DALLAS 13238134154 AAAW9NAAHAAAACDAAC 30 SALES CHICAGO 13238134154 AAAW9NAAHAAAACDAAD 40 OPERATIONS BOSTONSCOTT@book> @ &r/rowid AAAW9NAAHAAAACDAAA
OBJECT FILE BLOCK ROW DBA TEXT ------------ ------------ ------------ ------------ -------------------- ---------------------------------------- 94029 7 131 0 7,131 alter system dump datafile 7 block 131 ;SCOTT@book> alter system checkpoint;
System altered.SCOTT@book> select * from v$dbfile where file#=7;
FILE# NAME ------------ ---------------------------------------- 7 /mnt/ramdisk/book/tea01.dbf2.拷贝数据文件到windows:
BBED> set dba 7,132 DBA 0x01c00084 (29360260 7,132)--//注意windwos下block+1.
BBED> p kcbh struct kcbh, 20 bytes @0 ub1 type_kcbh @0 0x06 ub1 frmt_kcbh @1 0xa2 ub1 spare1_kcbh @2 0x00 ub1 spare2_kcbh @3 0x00 ub4 rdba_kcbh @4 0x01c00083 ub4 bas_kcbh @8 0x150de58c ub2 wrp_kcbh @12 0x0003 ub1 seq_kcbh @14 0x02 ub1 flg_kcbh @15 0x04 (KCBHFCKV) ub2 chkval_kcbh @16 0x443c ub2 spare3_kcbh @18 0x0000
BBED> p tailchk
ub4 tailchk @8188 0xe58c0602按照文档的说明:
seq_kcbh 表示Sequence number,incremented for every change made to the block at the same SCN. tailchk 看文档 包括 SCN base+type+SCN seq.BBED> corrupt
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y Block marked media corrupt.BBED> sum apply
Check value for File 7, Block 132: current = 0xf135, required = 0xf135BBED> verify
DBVERIFY - Verification starting FILE = R:\tea01.dbf BLOCK = 131Block 131 is corrupt
*** Corrupt block relative dba: 0x01c00083 (file 0, block 131) Bad header found during verification Data in bad block - type: 6 format: 2 rdba: 0x01c00084 last change scn: 0x0000.00000000 seq: 0xff flg: 0x04 consistency value in tail: 0x000006ff check value in block header: 0xf135, computed block checksum: 0x0 spare1: 0x0, spare2: 0x0, spare3: 0x0 *** --//verify 报错.BBED> p seq_kcbh
ub1 seq_kcbh @14 0xffBBED> p tailchk
ub4 tailchk @8188 0x000006ff--//修复,正常这样修复很简单,就是设置seq_kcbh=0x01,tailchk=0x00000601.
BBED> assign seq_kcbh=0x01
ub1 seq_kcbh @14 0x01BBED> assign tailchk=0x00000601
ub4 tailchk @8188 0x00000601BBED> sum apply
Check value for File 7, Block 132: current = 0xf135, required = 0xf135BBED> verify
DBVERIFY - Verification starting FILE = R:\tea01.dbf BLOCK = 131Block 131 is corrupt
*** Corrupt block relative dba: 0x01c00083 (file 0, block 131) Bad header found during verification Data in bad block - type: 6 format: 2 rdba: 0x01c00084 last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04 consistency value in tail: 0x00000601 check value in block header: 0xf135, computed block checksum: 0x0 spare1: 0x0, spare2: 0x0, spare3: 0x0 *** --//verify 报错.注执行上面这些在linux下已经正常修复了.BBED> p kcbh
struct kcbh, 20 bytes @0 ub1 type_kcbh @0 0x06 ub1 frmt_kcbh @1 0x02 ub1 spare1_kcbh @2 0x00 ub1 spare2_kcbh @3 0x00 ub4 rdba_kcbh @4 0x01c00084 ub4 bas_kcbh @8 0x00000000 ub2 wrp_kcbh @12 0x0000 ub1 seq_kcbh @14 0x01 ub1 flg_kcbh @15 0x04 (KCBHFCKV) ub2 chkval_kcbh @16 0xf135 ub2 spare3_kcbh @18 0x0000--//scn设置为0,不行吗?设置bas_kcbh看看:
BBED> p ktbbh.ktbbhitl[0].ktbitbas
ub4 ktbitbas @64 0x150de58aBBED> assign kcbh.bas_kcbh=0x150de58a
ub4 bas_kcbh @8 0x150de58a--注意tailchk要修改为0xe58a0601,前面4位来之kcbh.bas_kcbh的后4位.
BBED> sum apply
Check value for File 7, Block 132: current = 0xe438, required = 0xe438BBED> verify
DBVERIFY - Verification starting FILE = R:\tea01.dbf BLOCK = 131Block 131 is corrupt
*** Corrupt block relative dba: 0x01c00083 (file 0, block 131) Bad header found during verification Data in bad block - type: 6 format: 2 rdba: 0x01c00084 last change scn: 0x0000.150de58a seq: 0x1 flg: 0x04 consistency value in tail: 0xe58a0601 check value in block header: 0xe438, computed block checksum: 0x0 spare1: 0x0, spare2: 0x0, spare3: 0x0 ***--//依旧报错,这次仔细看发现rdba: 0x01c00084变成了偶数,我修改的块dba=7,131后面是奇数.
--//8*16+4=132,如果你看修改前的kcbh.rdba_kcbh=0x01c00083. --//很明显在bbed下执行corrupt修改了kcbh.rdba_kcbh. --//问题因为在windows下使用访问块时+1而导致的错误,所以讲windows下使用要小心.BBED> p kcbh.rdba_kcbh
ub4 rdba_kcbh @4 0x01c00084BBED> assign kcbh.rdba_kcbh=0x01c00083
ub4 rdba_kcbh @4 0x01c00083BBED> sum apply
Check value for File 7, Block 132: current = 0xe43f, required = 0xe43fBBED> verify
DBVERIFY - Verification starting FILE = R:\tea01.dbf BLOCK = 131DBVERIFY - Verification complete
Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0--Ok,通过,总之在windows下使用要注意.
--我一直感觉很奇怪bbed在9i下正常的,而到了10g,11g访问块都要加一个块,不知道为什么,因为32位与64位的区别吗? --有计划找一台32位的机器测试看看.转载地址：http://dxial.baihongyu.com/