How to restore and recover a database from an RMAN backup.
Last updated on SEPTEMBER 15, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 220.127.116.11 [Release 10.1 to 11.2]
Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 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 21-AUG-15 ***
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.
- 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms