Restoring an Oracle Database to Its Current Location (In Place)

Updated

You can restore Oracle data to the same database on the same client from which the database was backed up.

You can restore the following data:

  • The database and control file

  • The database

  • The control file

  • Individual tablespaces and the control file

  • Individual tablespaces

When you choose the option to recover from the latest backup time or from the latest System Change Number (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

  • Verify that the path to the auxiliary instance location has enough free space. The free space needed for the auxiliary instance location is the sum of the sizes of the system tablespaces and the tablespaces selected for the restore.

  • The auxiliary instance location must be accessible to the oracle user.

  • Verify that the destination path has enough free space for the tablespaces that you want to restore.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click the instance.

    The instance page appears.

  3. On the Overview tab, in the Recovery points section, select the backup to restore, and then click Restore.

    The Backup content page appears.

  4. Select the data that you want to restore, and then click Restore.

    The Restore options dialog box appears.

  5. Select the In place tab.

  6. To change the number of streams to use for the restore, in the Number of streams box, enter the number of streams to use.

  7. To specify the auxiliary path, in the Auxiliary path box enter the full path to the auxiliary instance location.

    The Auxiliary path box only appears if you are not restoring all the tablespaces.

  8. To specify an alternate directory to restore the database or individual table spaces into, do the following:

    1. Click Redirect.

      The Redirect path options dialog box appears.

    2. To redirect the database, click Database, and then enter the full path for the new location of the database.

    3. To redirect individual tablespaces and datafiles, click Tablespaces and datafiles. For each tablespace that you want to redirect:

      1. Expand the tablespace.

      2. In the Datafiles box, change the path to the new location.

    4. To redirect the online redo logs, move the Online redo logs toggle key to the right, and then enter the full path for the new location.

    5. Click Save.

  9. Select the data that you want to restore.

    These options only appear if you chose to restore all the tablespaces.

    • 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 SP file, clear the Database check box and select the SP File check box.

    • To restore the log files, clear the Database check box.

  10. To automatically move the database or selected tablespaces to the correct offline mode before the restore, select the Switch Database Mode check box.

  11. For Recover to, specify how you want to apply the archive files to the data files.

    The SCN option restores the database to the System Change Number (SCN) that you specify. The SCN tracks the timing of transactions in the database. The SCNs are stored in the control files and the datafile headers. You can recover the database to the most recent existing SCN number in the control file, which is the most recent consistent database state.

  12. Click Submit.