Oracle rman Recover Block

Run the dbv command and the SQL queries to identify the corrupt blocks

$dbv file=/u01/oracle/oradata/orcl/user_data01.dbf

SQL> select file#, block#, blocks, corruption_type "TYPE" from v$database_block_corruption;

Recover

RMAN> recover datafile 6 block 12; -> for specified block

RMAN> recover corruption list; -> all block

Validate the results.

SQL>select file#, block#, blocks, corruption_type “TYPE” from v$database_block_corruption;