Performing SQL Restores

You can restore the following data:

  • The database and control file
  • The database
  • The control file
  • Individual tablespaces and the control file
  • Individual tablespaces

You can restore the database to an instance with the same name as the source instance to the source client, or a different client.

After the restore, you can recover the database to a point other than the current time when the current database is inconsistent.

When you choose the option to recover from the latest backup time or from the latest SCN with a secondary copy, the software only considers the time or SCN from the latest job available on the secondary copy, even when the primary copy or other copies have a more recent backup job.

Before You Begin

Perform a backup.


  1. You can perform a restore on the agent details page, the instances page,or job details page.
    • Agent details: From the navigation pane, click Solutions > DB Instances instance, in the upper right of the page, click Restore.
    • Instances page: From the navigation page, click Solutions > DB Instances, in the Actions column for the instance, click the action button action_button, and then click Restore.
    • Job details: From the navigation pane, click Jobs > job ID, in the Job summary area, click Restore.

      The Backup Content page appears.

  2. Select the backups to restore.
    • To use the latest backup, in the upper-right of the page, click Show latest backups.
    • To use a backup from a specific date, in the upper-right, click Show backups as of a specific date, and then select the backup.
    • To use a backup from a date range, click Show backups for a date range, and then select the backup.
  3. Select the data that you want to restore
    • To restore all of the data, select the check box next to Database name.
    • To restore individual database, clear the check box next to each tablespace that you do not want to restore.
  4. Click Restore.

    The Restore Options dialog box appears.

  5. From the Destination list, select the destination host for the restore.
  6. To restore to a disk, in the Restore to Disk box, type the full path to restore to, or click Browse and specify the path.
  7. To restore with exclusive access to the database, select the Drop connections to database check box.

    Note: The restore fails when the software cannot gain exclusive access to the database.

  8. To write the restored data to the destination regardless of whether data exists, select the Unconditionally overwrite existing database or file check box.
  9. To restore to a new database, from the Data files list, select the new database name.

    The Database name box reflects the change.

  10. To restore to a new path, in the Physical path box, type the full path name, or use the Browse button.
  11. Click Submit.

What to Do Next

You can control or view the job. For more information, see Jobs.

Last modified: 10/31/2018 7:40:53 PM