Restoring Incremental Backups (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Restoring Incremental Backups

Use

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

The restore described in this procedure is part of the partial restore and complete recovery. That is, you must perform a recovery afterwards. To perform a restore independently of a recovery, see the other menu options in Database Restore and Recovery with SAPDBA.

Caution

Restoring a data file overwrites existing data files, since files are restored to their original location.

Prerequisites

You have found incremental backups.

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

During a restore, the SAP tool BRRESTORE physically restores the backup. If space problems occur during a restore of data files, you must use operating system tools to provide the required space.

Procedure

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

If required, choose Specify restore parameters to change the default restore parameters.

BRBACKUP Profile

This is normally init<DBSID>.sap.

Backup utility parameter file

This is normally init<DBSID>.utl. For more information, see Disaster Recovery.

Language

Language of BRRESTORE messages.

Choose Start restore incr. backup run to restore the incremental backup.

SAPDBA starts BRRESTORE to restore the files.

Choose Return to continue with the recovery.

Result

When the backup files have been successfully restored, SAPDBA sets the Status of Restore backup files to finished.

To continue with the partial restore and complete recovery, perform Finding the Offline Redo Log Files.