Oracle BBED工具介绍(七)
oradata/orcl/users01.dbf
BLOCK = 17
Block 17 is corrupt
Corrupt block relative dba: 0x00000011 (file 0, block 17)
Bad header found during verification
Data in bad block:
type: 98 format: 2 rdba: 0x00000011
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000001
check value in block header: 0xa711
computed block checksum: 0x6262
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 : 0
Total Blocks Marked Corrupt : 1
Total Blocks Influx : 0
修改完之后block的状态是corrupt的。用sum命令使之有效。
BBED> help sum
SUM [ DBA | FILE | FILENAME | BLOCK ] [ APPLY ]
BBED> sum file 4 block 17
Check value for File 4, Block 17:
current = 0xa711, required = 0xc573
此时 current checksum 是0xa711，required checksum 是0xc573
BBED> sum file 4 block 17 apply
Check value for File 4, Block 17:
current = 0xc573, required = 0xc573
加上apply参数，使checksum一致。此时block状态恢复正常。
BBED> verify
DBVERIFY - Verification starting
FILE = /export/home/oradata/orcl/users01.dbf
BLOCK = 17
Block 17 is corrupt
Corrupt block relative dba: 0x00000011 (file 0, block 17)
Bad header found during verification
Data in bad block:
type: 98 format: 2 rdba: 0x00000011
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000001
check value in block header: 0xc573
computed block checksum: 0x0
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 : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
重启一下数据库使之生效即可。
看看数据库的数据
SQL>select * from DAVE;
NAME
--------------------
dmm
l