Restore of Individual Backup Files

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 on 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 offline or online 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 backup or an incremental backup

Ў        The data file backups and an incremental backup if required

Features

The following graphic shows 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

...

                            a.      Select BRBACKUP run phase

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

                            b.      Select backup files for restore phase

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

                            c.      Restore selected files phase

BRRECOVER calls BRRESTORE to restore the selected files.

·        Restore individual files from tape

...

                            a.      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 non-database files and directories or offline redo log files.

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

                            b.      Restore the file phase

BRRECOVER calls BRRESTORE to restore the specified file.

·        Restore individual files from disk

...

                            a.      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 non-database files (but not directories) or offline redo log files.

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

                            b.      Restore the file phase

BRRECOVER calls BRRESTORE to restore the specified file.

·        Restore individual files from BACKINT backup

...

                            a.      Specify file for restore phase

§         You can specify not only database files but also non-database 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.

                            b.      Restore the file phase

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

·        Restore and apply incremental backup

...

                            a.      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.

                            b.      Restore and apply incremental backup phase

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