Thursday, September 11, 2008

To check for Oracle block corruption

To check for Oracle block corruption :-

  • use DBV for each file


dbv file=/db_1/system01.dbf blocksize=8192

  • use rman

run {
allocate channel disk1 device type disk ;
allocate channel disk2 device type disk ;
backup validate check logical database;
}

select count(*) from v$database_block_corruption;

No comments: