有备份情况下用blockrecover修改坏快

检查坏块：
1.用dba检查dbv file =/u01/oracle/oradata/test/test1.dbf blocksize=8192

2. 或用rman里的backup validate datafile 2;

 

坏块都在以下地方记录：
1. select * from v$database_block_corruption ;

2. alert_.log文件中会记录，如Reread of rdba: 0x0080000e (file 2, block 14) found same corrupted data

3. 访问到坏块所对应的对象时，会直接抛出错误

 

修复：

blockrecover datafile 2 block 14 from backupset;

或: blockrecover tablespace test DBA 54531097 from backupset;

 

修复后v$database_block_corruption 记录不会消失，只有再次backup validate datafile 2才会消失