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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms