Using RMAN to Restore and Recover a Database When the Repository and Spfile/Init.ora Files Are Also Lost
Last updated on OCTOBER 31, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 8.1.7 to 11.2]
Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [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.
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