How to Validate RMAN BMR Recoverability
(Doc ID 3009183.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later Information in this document applies to any platform.
Purpose
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.
Scope
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:
Corruption detected and showing in V$DATABASE_BLOCK_CORRUPTION
Confirm and validate recovery related files using RMAN
A list of required archived logs will be provided by RMAN
Missing backup set scenario
Missing archived log scenario
Consider both cases: nocatalog and catalog, the bs_key and bp_key is different when using, nocatalog vs. catalog mode operation.
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!