Disaster Recovery - SAP for Oracle iDataAgent

Table of Contents

Overview

Planning for a Disaster Recovery

Browse Databases

Recover the Oracle Database

Disaster Recovery Using CommCell Console

Disaster Recovery Using SAP Command Line Interface

Overview

The difference between a full Oracle database restore and a full system rebuild is the severity of the problem. Normally, if data is lost or removed, it is recovered from the archives using the restore options available from the SAP command line.

However, when a normal restore operation cannot correct a software and/or hardware corruption problem on the client system (such as a damaged or destroyed operating system, hardware, hard drives, etc.), some level of full system restore is required. To resolve a hardware corruption problem, see the appropriate SAP documentation. 

Planning for a Disaster Recovery

Before you begin a disaster recovery, make sure to do the following:

Browse Databases

This iDataAgent captures the state information for the database at backup time. In the event of system failure, it is critical for administrators to know the current version of the database and any service packs that were installed on the system. If the database is upgraded, the next backup that is run automatically detects the new version that was used during backup. This version is then refreshed in the instance Properties dialog box.

Recover the Oracle Database

Whenever the Oracle database is corrupted and a restore is required, both the Oracle application software and Oracle database must be restored. This can be achieved by using any of the following modes.

Disaster Recovery Using SAP Command Line Interface

To recover the Oracle database using SAP command line interface:

  1. Restore the Oracle application available under the <oracle install> directory using the File System iDataAgent.
  2. Restore the Oracle database files using the SAP command line. To this purpose, use the following general steps in the order presented.
    1. Ensure that the appropriate profiles exist, the profile names are defined appropriately, and the parameters are correctly set. Then use BRRESTORE to restore each required file (including the current summary log and current detail log) individually.
    2. Use BRRESTORE to completely restore the backup (i.e., reset the database to the last online or offline backup).
    3. Use BRRESTORE to restore the required offline redo log files from the BRARCHIVE tape.
  3. To Restore init<SID>.ora file:

    brrestore -d util_file -b2 becmmcsy.anf -m /oracle_setup/dbs/init<SID>.ora

  1. To Restore init<SID>.utl file:

    brrestore -d util_file -b2 becmmcsy.anf -m /oracle_setup/dbs/init<SID>.utl

  1. To Restore init<SID>.sap file:

    brrestore -d util_file -b2 becmmcsy.anf -m /oracle_setup/dbs/init<SID>.sap

  1. To Restore Control File:

    brrestore -d util_file -m 0

  1. To Restore DataFiles:

    brrestore -d util_file -b last -m all -u /

  1. To Restore Archive logs:

    brrestroe -a <From ARCHIVE LOG# - To ARCHIVE LOG#>

  1. After restoring the above files, run recover database manually using backup control file:

    sql>recover database using backup controlfile until cancel;

  1. Reset open DB with RESET LOGS option:

    sql>alter database open resetlogs;

init<SID>.ora, init<SID>.sap and init<SID>.utl can only be restored by SAP Command Line Interface. The remaining files such as control file, data files, archive log files can also be restored from CommCell Console.

For more information on Disaster Recovery using BRRESTORE, refer SAP documentation.

Disaster Recovery Using CommCell Console

To recover the Oracle database using CommCell Console:

1. From the CommCell Browser, right-click the instance, and click Browse Backup Data.
2. From the Browse Options dialog box, select the Specify Browse Time option and then select the date and time to which you wish to view the data in the browse window. Click OK in the Browse Options dialog box to execute the browse.
3. The Backup Data browse window displays the data and logs backed up during the specified time. From the Backup Data browse window, select the objects that you want to restore, and then click Recover All Selected.
4. From the SAP/Oracle Restore Options (General) tab:
  • Select the name of the client computer with the database you want to restore in the Destination Client from the list.
  • Choose the Number of streams to use for restore
  • Select the following options to restore and recover the database.
    • Restore Data
    • Restore Archive Logs
    • Restore Control File
    • Recover
  • Verify that the Status of the database is displayed as STARTED; if necessary click on the Refresh button to refresh the status.
5. From the Advanced Restore Options (Recover) tab, select Recover. Select Current Time to Recover an entire database at the current time and to the original host or to a different host. Select Point In Time option and specify the a specific point in time to restore the database. When you select the To Point in Time option, the backups that are required to restore the database to the indicated time are restored.
6. From the Advanced Restore Options (Ctrl Files) tab, select Restore Control File to restore the control file of the target database. Select Restore Control File As and click Browse to specify the name and location of the Control File.
7. From the Advanced Restore Options (Options) tab, Select  Open DB to open the database after recovering the database. If required, select Reset Logs to reset the logs after opening the database. The system automatically resets the log and the databases. Click OK.
8. Click OK to recover the database.  

Back to Top