IMPORTANT

Integrating SAP R/3 and Data Protector

Examples of SAP R/3 Database RestoreExamples of SAP R/3 Database Restore

This section describes some examples of how you can restore an SAP R/3 database. The following examples are given:

•“Example of Full Database Restore and Recovery” on page 241

•“Example of Partial Restore” on page 245

•“Example of Lost Files Restore” on page 245

•“Example of Archive Log Files Restore” on page 247

The restore of an SAP R/3 database can be performed using SAP R/3 utilities, which are not a part of Data Protector. This section only describes examples of how you can perform a restore using the BRRESTORE utility from SAPDBA. The examples provided do not apply to all situations, where the restore is needed. For additional information on how you can restore an SAP R/3 database using the BRRESTORE utility, refer to the SAP R/3 documentation.

Preparing the SAP R/3 Database for Restore

If you are performing a full database restore, you need to know how the backup was performed; whether you have used the Oracle RMAN channels or only BRBACKUP tools. If you used RMAN, use svrmgrl (Oracle8/8i) or sqlplus (Oracle9i), and RMAN commands to perform the restore. If you have used BRBACKUP utility, use SAPDBA to perform the restore.

If you are performing a partial restore, you can use BRRESTORE tools that come with the SAP R/3 BRBACKUP utility.

The following environment variables must be set before performing the restore:

•ORACLE_SID: system ID of the database instance

Example: P01

Chapter 2

239