Restoring a Database for Amazon RDS for Oracle

You can restore a database for Amazon RDS for Oracle.

Prerequisites

Verify the following on the destination client:

• The Oracle version must match AWS RDS Oracle version.

• Staging and redirect paths must have the necessary Oracle permissions.

• UNDO tablespace name in the destination init.ora file must match with the source.

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The databases Overview page appears.

2. On the Instances tab, click the instance.

   The instance page appears.

3. On the Overview tab, in the Recovery points section, select the backup to restore, and then click Restore.

   The Backup content page appears.

4. Select the parts of the database that you want to restore, and the date and time from which to restore, and then click Restore.

   The Restore options dialog box appears.

5. From the Destination server list, select the destination host.

6. In the Destination instance box, enter the destination instance.

7. To change the number of streams used for the restore operation, in the Number of streams box, enter the number of streams to use.

8. To specify a staging location for restoring the RMAN backup files to disk, in the Staging path box, enter the path.

9. To specify the data path for the database files, in the Redirect path for database box, enter the path.

   Note

   The RMAN backup pieces are restored to the staging location. The restore operation then uses these pieces and redirects them to the location specified by the Redirect path for database location. The RMAN restore uses the redirect path for the destination database and the restore datafiles.

10. To restore the database after the backup pieces are copied to disk, select the Restore database checkbox.

11. To recover the database, select the Recover database checkbox.

12. In the Recover type section, from the Recover to list, specify the backup to recover:

    • To recover the most recent backup operation, select Most recent backup.

    • To recover a specific backup, select Point in time, and then select the date and time.

    • To recover to a specific system change number (SCN), select SCN and then specify the SCN value.

13. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

    1. Click Schedule.

       The Add schedule dialog box appears.

    2. In the Name box, type a name for the schedule.

    3. Configure the Frequency and Repeat parameters.

    4. To specify exceptions to the schedule, click Exceptions.

       The Exceptions dialog box appears.

    5. Configure the exception parameters:

       • You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

       • Click Save when you have finished configuring the exception parameters.

    6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

    7. To save the schedule and return to the restore dialog box, click Schedule.

14. Click Submit.