Restoring Oracle data

Before you restore Oracle resources, make sure that you have completed all of the configuration requirements.

See Configuring the Oracle Agent on Windows computers and Linux servers.

See About restoring and recovering Oracle resources.


In a CASO environment, you can delegate an Oracle restore job to a managed media server. However, if the restore job uses encrypted Oracle backup sets from which to restore, the restore job may fail. An error message may appear that indicates the managed media server does not have the required encryption keys necessary to complete the job. You must create the encryption keys on the managed media server that runs the restore job.

See Creating an encryption key.

To restore Oracle data

  1. On the navigation bar, click the arrow next to Restore.

  2. Click New Restore Job.

  3. On the Properties pane, under Source, click Selections.

  4. Click the View by Resource tab.

  5. Expand the All Resources icon.

  6. Expand the system resource that contains the database instance that you want to restore.

  7. Expand the database instance that you want to restore.

    The current state of the database is listed to the right of the database name. The database must be in a Mounted, Nomounted, or Open state. You cannot select databases for restore jobs if they have a status of Down.

  8. Expand either the Current Database or Control Files resource.

    If you restore a control file, the entire database reverts to the point in time of the selected control file backup. You cannot use this option to restore an individual tablespace or datafile.

    To restore an individual tablespace or datafile, make your selection from the online database view instead.

  9. Select the appropriate items to restore.

  10. On the Properties pane, under Settings, click Oracle.

  11. Complete the appropriate options.

    See Oracle restore options .

  12. Select other restore options from the Properties pane as appropriate, and then start the restore job.

    See Restoring data by setting job properties.

  13. Run a full backup of the restored database.

More Information

Creating a template for DBA-initiated jobs

About DBA-initiated restore and recovery for Oracle

Troubleshooting the Oracle Agent

Restoring Oracle data