Restoring an Amazon RDS for Oracle Backup to the Source Instance

You can restore the backup to the instance where you performed the backup operation. You can perform the restore operation from the Amazon RDS Virtualization client computer.

Before You Begin

• Perform a backup operation. For more information, see Performing an Amazon RDS for Oracle Database Backup Operation.

• The schema must be present on the destination before running the restore procedure. If it is not present, the database administrator must create the schema before restoring the data.

Procedure

1. From the CommCell Browser, expand Client Computers > client > Oracle > instance.Right-click the subclient, and then click Browse and Restore.

   The Browse and Restore Options dialog box appears.

2. On the Time Range tab, select the backup:

   • To restore the most recent backup, select Latest Backup.

   • To restore to a point-in-time, select Time Range, and then in the Start and End boxes, type the date and time.

3. Click View Content.

4. On the Browse page, select the tables to restore, and then click Recover All Selected.

   The Restore Options dialog box appears.

5. On the General tab, select the restore options:

   1. From the Destination client list, select the client.

   2. In the Staging path for dump files box, type the full path to the location on the destination where the software stages the data before it imports the data to the database.

   3. In the Parallelism for import box, type the number of streams the software uses for the restore operation.

   4. To overwrite the existing tables on the destination, select the Overwrite if table exists check box.

6. Click OK.