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

Last updated on SEPTEMBER 15, 2017

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]
Information in this document applies to any platform.
***Checked for relevance on 21-AUG-15 ***

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

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