Filter
Top Products
Integrating SAP R/3 and Data Protector
Examples of SAP R/3 Database Restore
Chapter 2 245
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.