Restoring an Oracle Archive Subset to a Disk

Applies to: Archives that are in the XML format.

Apply a query to the database so that you can restore a subset of the data.

This procedure restores the archive to a database.

Before You Begin

If you want to restore to a database that is not the source database:

1. Ensure that all the archive database prerequisites are met. For more information, see Prerequisites.

2. Configure an instance on the staging database. For more information, see Instances for Oracle.

Procedure

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

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

   The Browse and Restore Options dialog box appears.

3. Click View Content.

4. On the Current Selected pane, select the data that you want to restore.

   • To restore one data version, in the right pane, select the table to restore, and then click Recover All Selected.

   • To restore multiple data versions:

     1. Right click the table to restore in the right pane, and then select View All Versions.

     2. On the All versions of dialog box, specify the restore version:

     3. To restore all listed versions, click Restore All.

     4. To restore a particular version, select the version, and then click Restore.

   The Restore Options dialog box appears.

5. On the General tab:

   1. From the Destination Client list, select the client

   2. In the Redirect Path box, type the path for the restored archive.

6. On the Job Initiation tab, specify whether to run the restore now or if it will be scheduled.

   Note: If you selected Schedule, set up the schedule.

   For information on configuring a restore schedule, see Schedule Restore.

7. Click OK to close the Restore Options dialog box.