11G new feature-block media recovery performance enhancements (Blocks media recovery)

Block Media Recovery performance enhancement (Block media recovery):
Just restore the damaged block. You do not need to offline the corrupted data file.
Restore and recover to the damaged blocks, using good data blocks in the backup, avoiding restore and recover of the entire data file.

Prerequisites:
The Flashback database feature must be turned on.

In Oracle 10g, the Blockrecover command can perform block media recovery.
In Oracle 11g, the new command recover ... block instead of Blockrecover.
Recover. Block will retrieve the flashback log before looking for a backup file. When you perform a recover. Block operation, the database must be an open or Mount state. Rman needs to use archived logs to perform block recovery, and the database must be an archive mode.

How to find the damaged data block:
Analyze tables and indexes
list Failure
Validate
Backup Validate command
Export to Dev/null?
v$database_block_corruption

To repair a damaged block of data using the recover ... block:

2 3 5  One ; RMAN235 from Tag=test1; #指定具体的备份

Fix all bad blocks at once:

rman> Recover corruption list;

11G new feature-block media recovery performance enhancements (Blocks media recovery)