Checks contents of
v$database_block_corruptionto obtain list of corrupted block in database.
*
Once corrupted block is restored/recovered, you may need to run following rman command to refresh v$database_block_corruption contents:
validate datafile 123 block 1234567;
Documentation regarding database block corruption: * Master Note for Handling Oracle Database Corruption Issues [ID 1088018.1] * Best Practices for Avoiding and Detecting Corruption [ID 428570.1] * Extracting Data from a Corrupt Table using ROWID Range Scans in Oracle8 and higher [ID 61685.1] * How to Format Corrupted Block Not Part of Any Segment [ID 336133.1] * http://laurentschneider.com/wordpress/2012/04/how-to-get-rid-of-corrupted-blocks-without-a-backup.html