How to restore and recover a database from an RMAN backup.
(Doc ID 881395.1)
Last updated on JULY 19, 2024
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 |