Restoring Data from an Oracle Logical Dump Backup

You can restore Oracle data from a logical dump backup, to the same instance or a different instance.

Before You Begin

• Perform a logical dump backup operation. For more information about configuring a subclient for Oracle logical dump backups, see Creating a Subclient for Oracle Logical Dump Backups.

• 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

1. From the CommCell Browser, expand Client Computers > client > Oracle.

2. Right-click the instance, point to All Tasks and then click Browse and Restore.

   The Browse and Restore Options dialog box appears.

3. 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.

4. Click View Content.

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

   The Oracle Restore Options dialog box appears.

6. Depending on the type of restore to be run, click Restore in place or Restore out of place, and then click Next.

   The Oracle In Place Restore Options or Oracle Out of Place Restore Options dialog box appears.

7. 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. If you are restoring to a different instance, complete the following steps:

      • Select the Import to database check box.

      • From the Database Name list, select the database that the software restores the tables to.

      • In the Connect Details box, type the Oracle Connect String for the database.

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

   6. 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.

8. Click OK to start the restore.