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

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

• Wallet files

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 database overview page appears.

2. On the Instances tab, click the instance.

   The instance properties 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 option.

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 restoring some of the tablespaces.

8. To specify the startup parameter file location, in the PFile box, type the full path to the file.

   The PFile box only appears if you are restoring some of the tablespaces.

9. To redirect the database or individual table spaces, do the following:

   1. Click REDIRECT OPTIONS.

      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 temporary tablespaces, move the Redirect temporary tablespaces toggle to the right, and then enter the full path for the new location.

   5. To change the characteristics of the online redo logs, move the Online redo logs toggle to the right, and then enter the information for the redo logs.

   6. Click SAVE.

10. To select the data that you want to restore, in the Restore section, select the items to restore.

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

11. Choose if you want to apply the archive files to the data files or if you want to restore the archive log files:

    • To apply the archive files to the data files select Recover to, and then from the Recover to type list select the type of recovery and enter any related values.

    • To restore the archive log, select Restore archive log:

      1. From the Archive log type list, select the type of recovery and enter any related values.

      2. In the Target directory box, enter the full path to the directory.

12. To select a MediaAgent for the restore, under Advanced options, from the MediaAgent list select a media agent server name.

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

14. To use the recovery catalog, under Advanced options move the Use recovery catalog toggle to the right, and then type the Connect string user ID, password, and service name.

15. To run the operation without connecting to the target database, under Advanced options select Skip target connection.

16. To have the software validate the restore without restoring the data, under Advanced options select Validate only.

17. To specify pre or post recovery scripts, do the following under Pre or Post options:

    1. Type the path to the script.

    2. To run a script as a specific user, move the Run as user toggle to the right and type the user name and password.

    3. To run the post-recovery process regardless of the job's outcome, select the Run post restore process for all attempts check box.

18. To restore wallet files to enable the use of wallet credentials, select the Restore wallet check box.

    For more information about Oracle wallet backup and restore, see Wallet Backup and Restore.

19. To customize the script for this restore operation, click PREVIEW.
    The preview window appears.

    1. To customize the script, click CUSTOMIZE.
       The Customize script window appears.
    2. On the Ctrl/SP file script or on the Database script tab, modify the script.
    3. Click SUBMIT to submit the modified script.

20. If you did not customize the script, click SUBMIT.