Oracle内部工具Block Corruption介绍

核心提示： 6.检查数据块损坏使用verify命令，可以发现刚才修改的file 3 block 17已经被标记为损坏，Oracle内部工具Block Corruption介绍(5)，BBED> verifyDBVERIFY - Verification startingFILE = /opt/o

6.检查数据块损坏

使用verify命令，可以发现刚才修改的file 3 block 17已经被标记为损坏。

BBED> verify
DBVERIFY - Verification starting
FILE = /opt/oracle/oradata/conner/users01.dbf
BLOCK = 17
Block 17 is corrupt
***
Corrupt block relative dba: 0x00c00011 (file 0, block 17)
Bad check value found during verification
Data in bad block -
type: 6 format: 2 rdba: 0x00c00011
last change scn: 0x0000.20a3b575 seq: 0x1 flg: 0x04
consistency value in tail: 0xb5750601
check value in block header: 0x3006, computed block checksum: 0xe803
spare1: 0x0, spare2: 0x0, spare3: 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　 : 1
Total Blocks Influx　　　　　 : 0
BBED> quit

7.使用DBV检查

[oracle@jumper conner]$ dbv file=users01.dbf blocksize=8192
DBVERIFY: Release 9.2.0.4.0 - Production on Sun Sep 11 20:13:23 2005
Copyright (c) 1982, 2002, Oracle Corporation.　All rights reserved.
DBVERIFY - Verification starting : FILE = users01.dbf
Page 17 is marked corrupt
***
Corrupt block relative dba: 0x00c00011 (file 3, block 17)
Bad check value found during dbv:
Data in bad block -
type: 6 format: 2 rdba: 0x00c00011
last change scn: 0x0000.20a3b575 seq: 0x1 flg: 0x04
consistency value in tail: 0xb5750601
check value in block header: 0x3006, computed block checksum: 0xe803
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
DBVERIFY - Verification complete
Total Pages Examined　　　　 : 128
Total Pages Processed (Data) : 107
Total Pages Failing　 (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing　 (Index): 0
Total Pages Processed (Other): 20
Total Pages Processed (Seg)　: 0
Total Pages Failing　 (Seg)　: 0
Total Pages Empty　　　　　　: 0
Total Pages Marked Corrupt　 : 1
Total Pages Influx　　　　　 : 0

8.全表扫描此时出现ORA-01578错误

重新启动数据库以后，执行全表扫描，此时错误出现:

SQL> startup force;
ORACLE instance started.
Total System Global Area　101782828 bytes
Fixed Size　　　　　　　　　 451884 bytes
Variable Size　　　　　　　37748736 bytes
Database Buffers　　　　　 62914560 bytes
Redo Buffers　　　　　　　　 667648 bytes
Database mounted.
Database opened.
SQL> select count(*) from bbed;
select count(*) from bbed
　　　　　　　　　　 *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 3, block # 17)
ORA-01110: data file 3: '/opt/oracle/oradata/conner/users01.dbf'
SQL>

以上方法仅供测试使用。