Entering content frameProcedure documentation Restoring the Backup Files Locate the document in its SAP Library structure

Use

You restore the 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

Procedure

  1. Choose Restore/recovery ® Partial restore and complete recovery ® Restore backup files in SAPDBA.
  2. If required, choose Specify restore parameters to change the restore parameters:

This is normally init<DBSID>.sap.

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

Language of BRRESTORE messages.

  1. Choose Start restore of backup files to start the restore.
  2. SAPDBA checks whether the files to be restored are still available. SAPDBA warns you that they will be overwritten.

    SAPDBA checks whether there is a backup file for each data file that was lost. If a backup file is missing, the restore process is terminated.

    SAPDBA starts the SAP tool BRRESTORE to restore the files.

  3. 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:

Leaving content frame