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 APRIL 03, 2020
Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 8.1.7 to 11.2] Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 12.1] Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2014***
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!