Loading...

Performing Oracle 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

  1. Perform a backup.
  2. Set the database to the correct mode defined in the table.

    Control file in the restore

    Required database mode

    Control file is included in the restore

    NOMOUNT

    Control file not included in the restore

    MOUNT

Procedure

  1. You can perform a restore on the agent details page, the instances page, or job details page.
    • Instances page: From the navigation page, click Solutions > DB Instances, in the Restore column for the instance, 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 Name.
    • To restore individual tablespaces, 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. Select the data that you want to restore.
    • To restore the database or individual tablespaces, select the Database check box and clear the Control file check box.
    • To restore the control file, clear the Database check box and select the Control file check box.
    • To restore the database and control file, select the Database check box and the Control file check box.
  7. Select the database recover option.
    • To recover to the latest backup job completion time, select Most recent backup.
    • To recover the database to the current time. select Current Time.
    • To recover to a point-in-time, select Point in Time, and then enter the date and time.
    • To recover to the System Change Number, select SCN.

      The System Change Number (SCN) tracks the timing of transactions in the Oracle database. The SCNs are stored in the control files and the datafile headers. You can recover the database to the last existing SCN number in the control file, which is the last consistent database state.

  8. If you restore to a new destination, then you can mask the data on the destination. Select the Mask sensitive data check box, and then from the Data masking policy list, select the data masking policy.
  9. Click Submit.

What to Do Next

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

Last modified: 8/1/2018 1:25:33 PM