My Oracle Support Banner

How to Validate RMAN BMR Recoverability (Doc ID 3009183.1)

Last updated on MARCH 15, 2024

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


 There can be a time when Block Media Recovery is required and knowing what files are needed and that all are available is essential to an efficient and quick recovery.


The use case is for Block Media Recovery.

V$DATABASE_BLOCK_CORRUPTION having rows or ORA-01578 is raised.

Given a datafile number and a block number, check:

Consider both cases: nocatalog and catalog, the bs_key and bp_key is different when using, nocatalog vs. catalog mode operation.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 16.4 Validating Backups Before Restoring Them
 Step 1 - Identify the file# and block# to be recovered
Step 2 - Execute RMAN Validate Preview
 Confirm and validate recovery related files using RMAN.
 Scenario 1 - Validation is successfully done. RMAN BMR can be performed
 Scenario 2 - Validation is not successfully done. Missing Backupset. RMAN BMR cannot be performed
 Scenario 3 - Validation is not successfully done. Missing Archived log. RMAN BMR cannot be performed
 Step 3 - Resolve any issues reported by RMAN Validate Preview
 Step 4 - RMAN Validate Preview after fixing the issue
 Step 5 - Perform the block media recovery

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.