# Restoring SAP for Oracle Data to the Current Location (In Place)

You can restore SAP for Oracle data to the current location (in place). You can restore the database, individual tablespaces, the control file, and/or the archive log. You can restore to the current time or to a point in time.

## Before You Begin

Set the database to the correct mode:

Is the control file included in the restore? | Mode to put the database in
--- | ---
Yes | NOMOUNT
No | MOUNT

## Procedure

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

   The Overview page appears.

2. Click the Instances tab.

   The Instances page appears.

3. Click on an instance and select the Subclients tab.

   The subclients list appears.

4. In the row for the subclient that you want to restore, click the action button , and then select Restore.

   The Backup content dialog box appears.

5. Select the content to restore, and then click Restore.

   The Restore options dialog box appears.

6. On the In place tab, specify the following:

   1. In Number of streams, enter the number of streams to use for the restore.

   2. Under Restore, select the check boxes for the data to restore:

      - Data

      - Control file

      - Archive log

   3. If you enabled IntelliSnap backups of the subclient, to revert the data to the time when the snapshot was created, select the Use snap revert check box.

      Selecting this check box restores the entire LUN to the point when the snapshot was created, overwriting all the modifications to the data since the snapshot was created.

      This check box is available only if the snapshot engine used for the IntelliSnap backup supports the revert operation.

   4. Under Recovery Type, specify whether to restore to the current time or to a point in time.

   5. If you want to specify whether to open the database after the restore/recovery operation has completed, check the Open DB check box. Selecting this option will open the database, and enable the Reset Logs option.

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

      - Type the path to the script.

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

7. Click Submit.

## What to Do Next

After the restore is complete, if the current database is not consistent, you can restore the database to a point other than the current time.

×

Loading...