Finding the Backup Files (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Finding the Backup Files

Use

You find the backup files when using SAPDBA to perform a partial restore and complete recovery of your Oracle database.

SAPDBA attempts to locate the backup files by scanning previous BRBACKUP logs (of a specified period) for valid backups of the damaged data files. If the backup was performed with an external backup program, SAPDBA attempts to establish a link to that backup program and find the files in this way.

The information on the location of these files is important for the subsequent phases of the recovery process.

Prerequisite

You have checked the database.

You have configured and started SAPDBA. Refer to Getting Started with SAPDBA.

Procedure

Choose Restore/recovery ® Partial restore and complete recovery ® Find backup files in SAPDBA.

Choose Start finding backup files.

If you used a non-SAP backup program for the backup, SAPDBA also attempts to obtain the corresponding information from this program.

Define the period for which you want SAPDBA to search for the backup files. The default value is the previous 30 days.

SAPDBA uses BRBACKUP logs to find the backup files.

If SAPDBA finds backup files, it determines the necessary log sequence number by finding the most recent BRBACKUP file for each lost file and then selecting the smallest of the respective log sequence numbers.

Choose one of the following to display the backup files found by SAPDBA:

Show the list of damaged files

SAPDBA lists the lost or damaged files and their backup files.

Each of the files shown in the list contains one of the following comments:

Backup file: <name> on <tape/disk>

The file must be restored from tape or disk.

backed up by <name of external backup program>

The file was backed up using the specified program. This comment appears when the parameter backup_util_name of profile init<DBSID>.dba contains the name of the external backup program. Otherwise, the following comment is displayed:
ext. backup utility

no restore of a backup file required

The existing file can be used. It is simply an older version and must be recovered.

No backup file found

No backup was found for this file in the specified period.

Show the list of backup files

Specify the lost or damaged files for which you would like to see the available backup files. Each file that has been lost can have several backup files.

Select a backup file for the restore by choosing Select a backup file for restore.

This lets you change the SAPDBA proposal for which backup file is restored. The file that is finally selected for the restore process is flagged with (SELECTED FOR RESTORE).

Select a BRBACKUP run for the restore by choosing Select a BRBACKUP run for restore.

SAPDBA suggests the newest backup found for each individual file from which the requested files (SELECTED FOR RESTORE) can be restored. You can change this setting, for example, if all the files for the restore were backed up in one backup run and you only want to specify that one backup run (perhaps to avoid changing tape, which is often necessary if the files belong to different backup runs).

The following information is given:

Sequential number of the backup file found (No.)

Coded time stamp (coded timestamp), date (date), and time (time) of the backup
The backup medium

The number of files found in this backup that are to be restored (backup files found): <files found>/ <total files for restoring>. When n/n is displayed, this means that all the selected files were found in this backup.

Choose Return to continue with the recovery.

Result

SAPDBA sets the Status of Find backup files to finished.

To continue with the partial restore and complete recovery, perform Restoring the Backup Files.