Tuesday, September 9, 2008

Check for Oracle block corruption

# To check for Oracle block corruption you can :-

# 1. use DBV
dbv file=/db1/system01.dbf blocksize=8192

#2. 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;


RMAN> blockrecover corruption list;