dbv Marked Corrupt不在DataFile中

1、dbv file=/dev/rdbvg3_20g_002 blocksize=8192
       age 2621441 is marked corrupt
Corrupt block relative dba: 0x30280001 (file 192, block 2621441)
Bad header found during dbv:
Data in bad block:
 type: 6 format: 4 rdba: 0x01000000
 last change scn: 0x384a.0006c502 seq: 0x64 flg: 0x53
 spare1: 0x45 spare2: 0x47 spare3: 0x4547
 consistency value in tail: 0x4b602b06
 check value in block header: 0x614
 block checksum disabled

Page 2621442 is marked corrupt
Corrupt block relative dba: 0x30280002 (file 192, block 2621442)
Bad header found during dbv:
Data in bad block:
 type: 23 format: 5 rdba: 0x00040000
 last change scn: 0x4b60.06c50238 seq: 0x28 flg: 0x06
 spare1: 0x3e spare2: 0x3d spare3: 0x3e3d
 consistency value in tail: 0x384c4c13
 check value in block header: 0x1745
 computed block checksum: 0xb3c9

Page 2621443 is marked corrupt
Corrupt block relative dba: 0x30280003 (file 192, block 2621443)
Bad header found during dbv:
Data in bad block:
 type: 6 format: 7 rdba: 0x6a003000
 last change scn: 0x384c.0006c502 seq: 0x4c flg: 0x04
 spare1: 0x45 spare2: 0x4a spare3: 0x454a
 consistency value in tail: 0x070c2c00
 check value in block header: 0x617
 computed block checksum: 0x6b8b
。。。。。。。。
Page 2654205 is marked corrupt
Corrupt block relative dba: 0x30287ffd (file 192, block 2654205)
Bad header found during dbv:
Data in bad block:
 type: 120 format: 5 rdba: 0x01032402
 last change scn: 0xffff.c114ffff seq: 0xff flg: 0x0b
 spare1: 0xb spare2: 0x14 spare3: 0x3331
 consistency value in tail: 0x321eff02
 check value in block header: 0x3133
 block checksum disabled

Page 2654206 is marked corrupt
Corrupt block relative dba: 0x30287ffe (file 192, block 2654206)
Bad header found during dbv:
Data in bad block:
 type: 193 format: 3 rdba: 0xffffff0b
 last change scn: 0x3136.31333336 seq: 0x33 flg: 0x39
 spare1: 0xff spare2: 0xff spare3: 0x3802
 consistency value in tail: 0x35323634
 check value in block header: 0x3836
 block checksum disabled
DBVERIFY - Verification complete

Total Pages Examined         : 2654206
Total Pages Processed (Data) : 1041385
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 68120
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1511737
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 198
Total Pages Marked Corrupt   : 32766
Total Pages Influx           : 290
Highest block SCN            : 1676874442 (3048.1676874442)
2、从上面可以看出使用dbv测试数据文件/dev/rdbvg3_20g_002,显示有32766个坏块,
3、
select file_name,bytes/8192 ,AUTOEXTENSIBLE from dba_data_files where file_name='/dev/rdbvg3_20g_002';
*************************************************************************************
/dev/rdbvg3_20g_002   2621440,NO
4、明显第一个block corrution为2621441，却是在最大的block_id(2621440)之后的第一个快,奇怪吧!
5、赶紧处理吧,
Solution：alter database datafile '/dev/rdbvg3_20g_002' resize 20482M
                   or
                   alter database datafile '/dev/rdbvg3_20g_002' resize 20478M
6、测试Raw device 需要加end 参数
      dbv file=  blocksize=8192 end=bytes/block_size

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26634508/viewspace-751863/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26634508/viewspace-751863/