Show TOC

Restore of Individual Backup FilesLocate this document in the navigation structure

Use

You can restore individual backups files to your Oracle database. This is intended for experts, so make sure you fully understand how it works before using it.

This section discusses how to approach the restore of individual backup files.

For more information about how to perform a restore of individual backup files, see Restore of Individual Backup Files with BR*Tools.

Prerequisites

  • We recommend you to perform a full online or offline backup. If the database is running, use SAP tools, otherwise use operating system tools.

  • You must have the following data available:

    • The BRBACKUP logs when restoring from a BRBACKUP database backup or an incremental backup

    • The data file backups and an incremental backup if required

Features

The following graphics show how restore of individual backup files works:

Activities

You can perform the following functions to restore individual backup files:

  • Restore files from a BRBACKUP backup

    1. Select BRBACKUP run phase

      You select a BRBACKUP run from the backup list. You can select a BRBACKUP run that finished with an error.

    2. Select backup files for restore phase

      You select files to restore from the list of files backed up in the selected run.

    3. Restore selected files phase

      BRRECOVER calls BRRESTORE to restore the selected files.

  • Restore individual files from tape

    1. Specify file for restore phase

      • You can specify a file on a local or a remote tape device.

      • You can specify not only database files but also nondatabase files and directories or offline redo log files.

      • You must specify the file position on tape and the restore destination.

    2. Restore the file phase

      BRRECOVER calls BRRESTORE to restore the specified file.

  • Restore individual files from disk

    1. Specify file for restore phase

      • You can specify a file on a local or a remote disk.

      • You can specify not only database files but also nondatabase files (but not directories) or offline redo log files.

      • You must specify the backup file name and the restore destination.

    2. Restore the file phase

      BRRECOVER calls BRRESTORE to restore the specified file.

  • Restore individual files from BACKINT backup

    1. Specify file for restore phase

      • You can specify not only database files but also nondatabase files and directories (if supported by BACKINT) or offline redo log files.

      • You must specify the backup file name, the BACKINT backup ID and optionally the restore destination.

    2. Restore the file phase

      To restore the file, BRRECOVER calls BRRESTORE, which then calls BACKINT.

  • Restore and apply incremental backup

    1. Select incremental backup phase

      You select an incremental BRBACKUP run from the backup list. You can select a BRBACKUP run that finished with an error.

    2. Restore and apply incremental backup phase

      BRRECOVER calls BRRESTORE to restore and apply the selected incremental backup.