Full System Recovery of SAP Oracle Database: Restoring the SAP Oracle Database from the CommCell Console

Restore the SAP Oracle database to the same or different client in the event of a disaster.

Procedure

  1. From the CommCell Console, navigate to <Client> | SAP for Oracle.
  2. Right-click the instance that contains the data you want to restore and point to All Tasks | Browse and Restore.
  3. From the Time range tab, click View Content.
  4. From the Browse window, 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
  6. Verify that the Status of the database is displayed as MOUNTED; perform the following to change the database status.
    • Click Advanced.
    • On the Advanced Restore Options dialog box, navigate to the Options tab.
    • Select the Switch database for Restore check box.
    • Click OK.
  7. Click the Job Initiation tab.
    • Select Immediate to run the job immediately.
    • 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.

    You can monitor the progress of the restore job in the Job Controller or Event Viewer window of the CommCell Console.

  8. Once the restore job has completed, right-click the entity (e.g. agent, instance) and click View | Restore History and click OK.

    If the entity chosen is the client computer, click View | Job History and click OK.

  9. You can view the following details about the job by right-clicking the job:
    • View Job Details
    • View Events of the restore job.
    • View Log files of the restore job.

Result

The database is restored to the directory where it resides.