Does Block recovery use incremental backup?
Translated from:
Does Block Recovery use Incremental Backups?? (Doc ID 727706.1)
Suitable for:
Oracle database-enterprise edition-version 9.2.0.8 to 12.1.0.1 [Release 9.2 to 12.1]
Information in this document applies to any platform.
Information in this document applies to any platform.
Goal:
Does Block Recovery take into account the incremental backups that can be used?
Solution:
The backup of the datafile containing the bad block must be "full backups" or "Incremental Level 0 Backups"
Block Recovery does not use ' incremental level 1 ' backup,
We do not know if the block that needs to be restored exists because the backupset is not completely scanned.
Doing so can lead to a waste of resources if the block is not in an incremental backup.
Therefore, the Blockrecover command uses only archived logs and backups to complete the recovery effort.
New from 11gR1 onward
-Flashback logs is as well searched for good copies of the block, but is RMAN to is able to search the Flashback logs
For good copies of corrupt blocks, Flashback database must is enabled on the target Database.
When performing block media recovery, RMAN automatically searches the flashback logs, if they is available,
For the required blocks before searching backups.
-Command Blockrecover is replaced by RECOVER BLOCK.
"Translated from MoS article" Block Recovery using incremental backup?