Restoring an Oracle Database to Disk (Application-Free Restore)

Applies to: Oracle and Oracle RAC

You can restore Oracle databases directly to a disk from the CommCell Console without the use of Oracle.

You can restore multiplexed data on the same media. The data from different backup jobs is passed to the client so that all of the interleaved backup jobs are restored in parallel. Restore the data that is associated with a specific backup jobs such as full, incremental, or archive log in parallel streams.

Note

The following procedure restores the archive files (backup sets) to a disk. To restore files to the database, you must use the Oracle Agent.

Before You Begin

  1. Install the Oracle Agent on the destination.

  2. Verify that there is enough disk space for the backup pieces that are restored from the application-free restore.

  3. If you want to catalog the backup pieces after the restore, the Oracle user must have permission.

Procedure

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

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

  3. On the Restore to Disk dialog box, click OK.

  4. Select the backup job to restore to a disk. Right-click the job and select Restore to Disk.

    Select multiple backup jobs at a time and restore them to disk.

  5. In the Restore Options for All Selected Items dialog box, set up the client:

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

    2. In the Destination path box specify where the backup pieces are restored to.

      Note

      If the destination is an NFS share, the hosting NFS server must have the "no_root_squash" option enabled.

    3. To use a different account other than the one configured for the Oracle instance, select the Impersonate User check box and enter the credentials.

      The account must have the necessary write privileges on the location for the restored data.

  6. Click OK to close the Restore Options for All Selected Items dialog box.

What to Do Next

  1. Optional: When the restored backup pieces are unknown to the RMAN repository, catalog the restore disk pieces. For more information, see Cataloging Backup Pieces Restored to Disk after an Application Free Restore.

  2. Perform an RMAN restore (for example, restore the database, restore the control file or recover the database). For more information, see Oracle Restore Examples Using the RMAN Command Line Interface.

Loading...