My Oracle Support Banner

Using RMAN to Restore and Recover a Database When the Repository and Spfile/Init.ora Files Are Also Lost (Doc ID 372996.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.0 [Release 8.1.7 to 11.2]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2014***


Goal

PURPOSE


The purpose of this note is to provide guidelines on how RMAN can be used to restore and recover a database when all that is available are the physical backuppieces on disk or tape. Such a situation might occur if:

a. in a total disaster situation not only is the database lost but also all the controlfiles, the spfile (9i and later) and the recovery catalog (if used)
b. there is a need to restore and recover the database from an old backup that has long since been deleted or aged out of the rman repository (such as a disk backup that was copied to tape prior to deletion via RMAN)


SCOPE & APPLICATION


This article is meant for database administrators and backup and recovery specialists tasked with the restore and recovery of a database when only the physical backuppieces are available. A good working knowledge of Oracle and Recovery Manager is assumed. Oracle versions 8i through to 10G are covered.

Solution

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
Goal
 PURPOSE
 SCOPE & APPLICATION
Solution
 INTRODUCTION
 
 Restoring When All is Lost 
 1. Restoring the INIT.ORA File
 2. Restoring the SPFILE and CONTROLFILE when CONTROLFILE AUTOBACKUP is NOT used
 2.1 Restoring the SPFILE and CONTROLFILE when CONTROLFILE AUTOBACKUP is used
 3. Query the Backup History in the Restored Controlfile
 3.1 Restored controlfile does NOT contain the database backup metadata
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.