HP OpenView Storage B6960-96008 manual Restoring the Control File, 210

Integrating SAP R/3 and Data Protector

Restoring an SAP R/3 Database

Check the instructions from the database/application vendor on how to prepare for a disaster recovery. See also the HP OpenView Storage Data Protector Disaster Recovery Guide for instructions on how to approach system disaster recovery using Data Protector.

This is a general procedure for recovering an application:

1.Complete the recovery of the operating system.

2.Install, configure, and initialize the database/application so that data on the Data Protector media can be loaded back to the system. Consult the documentation from the database/application vendor for a detailed procedure and the steps needed to prepare the database.

3.Ensure that the database/application server has the required Data Protector client software installed and is configured for the database/application. Follow the procedures in this chapter and in the troubleshooting section.

4.Start the restore. When the restore is complete, follow the instructions from the database/application vendor for any additional steps required to bring the database back online.

Restoring the Control File

The control file contains all the information about the database structure. If the control file has been lost, you must restore it before restoring any other part of the database.

Perform the following steps:

1.Restore the control file using the standard Data Protector restore procedure.

The control files (ctrl<ORACLE_SID>.dbf) are by default restored to the directory defined by the SAPBACKUP variable. If the variable is not set, the control files are restored to the following directories:

•/var/opt/omni/tmp (HP-UX and Solaris systems),

•/usr/opt/omni/tmp (other UNIX systems), or

•<Oracle_home>\tmp (Windows systems).

210 Chapter 2