Restore and Application of Offline Redo Log Files

Use

You can restore and apply offline redo log files – called archivelog files in the BR*Tools menus – 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 restore and application of redo log files.

For more information on how to perform a restore and application of redo log files, see Restore and Application of Offline Redo Log 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.

Ў        Back up all offline redo log files using BRARCHIVE. For more information, see -a|-archive.

·        You must have the BRARCHIVE logs available.

Features

The following graphic shows how restore and application of  individual backup files works:

Activities

You can perform the following functions to restore and apply offline redo log files:

·        Restore offline redo log files

...

                            a.      Specify offline redo log files for restore phase

You specify the offline redo log files that you want to restore.

                            b.      Restore offline redo log files phase

BRRECOVER calls BRRESTORE to restore the specified offline redo log files.

·        Apply offline redo log files

...

                            a.      Specify offline redo log files for application phase

You specify which offline redo log files you want to apply.

                            b.      Apply offline redo log files phase

BRRECOVER calls SQLPLUS to apply the offline redo log files.

·        Open database (optional)

...

If required, you can open the database after applying the offline redo log files.