Restoring the Offline Redo Log Files 

Use

You restore the offline redo log files when using SAPDBA to perform a partial restore and complete recovery of your Oracle database.

During a restore, BRRESTORE restores backups of the offline redo log files. If SAPDBA determines that the archiving directory <SAPDATA_HOME>/saparch does not have enough space to restore all the necessary redo log files, the redo logs that have already been used are deleted and the next required redo logs are restored during the subsequent recovery.

• You have found the offline redo log files.

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

1. Choose Restore/recovery ® Partial restore and complete recovery ® Restore offline redo logs in SAPDBA.

2. If required, choose Specify restore parameters to change the restore parameters. However, this is not usually necessary since the parameters are based on the backup logs.
3. Choose Start restore of offline redo logs.



You have to use this procedure when the recovery requires offline redo log files that are no longer in the archiving directory. You cannot start the recovery until the necessary archived redo logs are restored, either now or continuously during the recovery.

BRRESTORE restores the required files.

If the redo logs are still available on disk, they do not have to be restored. SAPDBA flags such files with the comment (still on disk - not restored).

4. Choose Return to continue with the recovery.

To continue with the partial restore and complete recovery, perform Recovering the Database.