to 163 Dba:0x00400001
------------------------------------------------------------------------
32000000 00000000 00000000 00000000
<32 bytes per line>
BBED> sum apply
Check value for File 1, Block 1:
current = 0xa50a, required = 0xa50a
--open the database
SQL> alter database open;
Database altered.
SQL>
--------------------------------------------------------------------
--数据有坏块 时候是否影响启动
--corrupt the block
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 0x0140000c
ub4 bas_kcbh @8 0x000de97d
ub2 wrp_kcbh @12 0x0000
ub1 seq_kcbh @14 0x02
ub1 flg_kcbh @15 0x04 (KCBHFCKV)
ub2 chkval_kcbh @16 0x1c9c
ub2 spare3_kcbh @18 0x0000
BBED> corrupt
Block marked media corrupt.
BBED> v
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/test/block.dbf
BLOCK = 12
Block Checking: DBA = 4194316, Block Type = KTB-managed data block
Found block already marked corrupted
DBVERIFY - 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
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 0x0040000c
ub4 bas_kcbh @8 0x00000000
ub2 wrp_kcbh @12 0x0000
ub1 seq_kcbh @14 0xff --原来是02
ub1 flg_kcbh @15 0x04 (KCBHFCKV)
ub2 chkval_kcbh @16 0x1d91
ub2 spare3_kcbh @18 0x0000
BBED> sum apply
Check value for File 1, Block 12:
current = 0x1d91, required = 0x1d91
--reopen the database
SQL> alter database open;
Database altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 184549376 bytes
Fixed Size 1218412 bytes
Variable Size 92276884 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
--一般坏块不影响数据库的启动
--修改回来 用corropt修改不会来 奶奶的 还是简单改改ff吧 revert 可以的 注意呀 奶奶的
--跟踪文件里的错误
Bad header found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x0040000c
last change scn: 0x0000.00000000 seq: 0x2 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000602
check value in block header: 0x1d91
computed block checksum: 0x0
Reread of rdba: 0x0140000c (file 5, block 12) found same corrupted data
-----------------------------------------------------------------------
|