Restoring an Amazon RDS for Oracle Backup to a New Instance

You can restore the Amazon RDS Oracle data to a destination that is different from the source. 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.
If you will be running a cross-server restore, the connect string details of the destination database must be in the source's tnsnames.ora file and the connect string details of the source database must be in the destination's tnsnames.ora file.

Procedure

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.
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.
Click View Content.
On the Browse page, select the tables to restore, and then click Recover All Selected.

The Restore Options dialog box appears.
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. Select the Import to database check box.
5. From the Database Name list, select the database that the software restores the tables to.
6. In the Connect Details box, type the Oracle Connect String for the database.
7. To overwrite the existing tables on the destination, select the Overwrite if table exists check box.
8. If you want to restore data to different tablespaces on the destination, use the Remap tablespace box to define how you want the tablespaces remapped. The format of the string is as follows, with a space character between each source:destination pair:
```
Tablespace1_source:Tablespace1_destination Tablespace2_source:Tablespace2_destination... TablespaceN_source:TablespaceN_destination
```
  Note
  
  If remapping of the tablespaces fails with Oracle errors, then the tablespaces cannot be remapped. If this occurs, the database administrator must create tablespaces in the destination database that are identical to those in the source database.
Click OK.