My Oracle Support Banner

How to restore and recover a database from an RMAN backup. (Doc ID 881395.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.



Goal


The following note will guide a DBA through the process of restoring and recovering a database from an RMAN backup.  It will assist in a complete database restore.

Assumption

- A valid backup of the database is accessible.

- Required archive logs* to recover the database are available and accessible.

* Archive logs required are those generated from the start time of the backup until the completion of the backup if an online backup was performed. 

 

If you need to perform restore/recovery on a different host for a backup taken on another host, also refer:

<Note 419137.1> How To Restore Rman Backups On A Different Node When The Directory Structures Are Different

 

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
Solution
 Step 1:  Identify controlfile backup to restore
 Step 2:  Restore the controlfile
 Step 3:  Restore and recover the database
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.