Integrating SAP R/3 and Data Protector

Examples of SAP R/3 Database Restore

After you have opened a database with the RESETLOGS option, it is strongly recommended to perform a whole database backup immediately.

If the database is opened with the RESETLOGS option, the old redo log files are overwritten. Back up the offline redo log files before you open the database.

Example of Partial Restore

To perform a partial restore and recovery, you need to determine whether you need to restore a backup file or an archive redo log. The task of the SAPDBA recovery function is to fix certain media and user errors. When such errors occur, they usually involve the loss of database files, which contain many various types of objects: Oracle Dictionary segments, temporary segments, rollback segments, or user segments (tables and indexes).

SAPDBA utility supports restoring the database after the loss of the following files:

•SAP tablespaces data file (PSAP<name>D/I)

•System tablespace files (SYSTEM)

•Rollback tablespace files (PSAPROLL)

•Temporary tablespace files (PSAPTEMP)

The menu option Check (and repair) database only enables the recovery of the database up to the present time.

Example of Lost Files Restore

To restore the lost files, follow the steps below:

1.Define the time period within which you want SAPDBA to search for the backup files. The default value is 30 days. Then select the Start finding backup files menu option. SAPDBA utility uses the BRBACKUP log files to find the backup files.

If the SAPDBA utility finds backup files, the necessary log sequence number is determined by SAPDBA as follows: SAPDBA searches for the most recent BRBACKUP file for each lost file and then selects the lowest of the respective log sequence numbers.

Chapter 2

245