Last updated on December 21st, 2015 at 05:35 am
1. Run below command to populate v$database_block_corruption view with information of all the corrupted blocks.
RMAN> backup validate check logical database;
“CHECK LOGICAL” option is used to identify both Physical and Logical Block Corruptions.
Select the view to identify the corrupted blocks detected by RMAN.
SQL> select * from v$database_block_corruption;
Please note, After a corrupt block is repaired, the row identifying the block is deleted from the view.
2. Check alert. log file for corrupted blocks, data file list.
For ex:- ORA-01578: ORACLE data block corrupted (file # 11, block # 45)
ORA-01110: data file 5: ‘/xxxx/db01.dbf’
3. You can also use dbverify utility to identify Physical and Logical Intra Block Corruptions.
dbv file=datafile_name blocksize=datafile_block_size