New feature of 11G-enhanced recovery performance of Block Media (block media recovery)

New feature of 11G-enhanced recovery performance of Block Media (block media recovery)

Enhanced Block Media recovery performance (block media recovery):

Just recover the damaged block. There is no need to offline the damaged data file.

For damaged data blocks, the good data blocks in the backup are used for restore and recover, which avoids the restore and recover of the whole 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 replaces blockrecover.

Recover... Block retrieves the flashback log before looking for backup files. Performing recover... When block operates, the database must be in an open or mount state. Rman needs to use archive logs to perform block recovery, and the database must also be in archive mode.

How to identify damaged data blocks:

Analyze tables and indexes

List failure

Validate

Backup validate command

Export to dev/null?

V$database_block_corruption

Use recover... Block repairs damaged data blocks:

RMAN > recover dataflie 2 block 3 heroic datafile 5 block 11 transition rman > recover dataflie 2 block 3 authoring datafile 5 block 11 from tag=test1; # specify a specific backup

Fix all the bad blocks at once:

RMAN > recover corruption list