Getting Started - SAP for Oracle Restore

Perform a Restore

It is recommended that you perform a restore operation immediately after your first full backup to understand the process.

The following section comprehends the steps involved in restoring your entire database.

1.
  • From the CommCell Console, navigate to Policies | Storage Policies.
  • Right-click the <storage policy> and click Properties.
  • Click the Copy Precedence tab.
  • By default, the snapshot copy is set to 1 and is used for the operation.

    You can also use a different copy for performing the operation. For the copy that you want to use, set the copy precedence as 1.

  • Click OK.
2.
  • From the CommCell Console, navigate to <Client> | SAP for Oracle.
  • Right-click the instance that contains the data you want to restore and click All Tasks | Browse Backup Data.
3. Click OK.
4.
  • Select the instance node in the left pane. The data and logs will be automatically selected in the right pane.
  • Click Recover All Selected.

 
5.
  • Choose the Number of streams to use for restore.
  • Select the following options to restore the database.
    • Restore Archive Log
    • Restore Data
    • Recover
  • Verify that the Status of the database is displayed as MOUNTED; if necessary click Refresh to get the latest status.
  • Click OK.
  If the database is not mounted, a warning dialog appears to remind you to set the database in MOUNT mode.

To mount the database, enter the following commands in the machine hosting the database:

[root]# export ORACLE_SID=<instance name>

[root]# sqlplus "/ as sysdba"

[root]# shutdown immediate;

[root]# startup mount;

Once the database is mounted, click OK.
6. You can monitor the progress of the restore job in the Job Controller.
7. The database is restored to the directory where it resides.  

Congratulations -  You have successfully completed your first backup and restore.

If you want to further explore this Agent's features read the Advanced sections of this documentation.

If you want to configure another client, go back to Setup Clients.