Changing the Restore and Recovery Options (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Changing the Restore and Recovery Options

Use

You can change the options when using SAPDBA to perform a partial restore and complete recovery of your Oracle database.

Procedure

Choose Restore/recovery ® Partial restore and complete recovery ® Options in SAPDBA.

SAPDBA displays the current option values.

Set the parameters as required:

Use incremental backups for recovery

If incremental backups are available and you do not want to use them during the recovery for some reason, set this to no.

Recovery by reorganization (for index and empty data files)

If you want the recovery to be performed by reorganization instead of by applying the redo log files, set this to yes.

Use backup from external backup tool to restore files

If you have an external backup tool, set this to yes.

Use inquire function of backint (relying on BR* log information)

This option only appears if you have set the previous option to yes. It means that BACKINT is used to find the files that have been saved us an external backup tool, so that you can decide if you want to use these for the restore.

Choose Return to continue with the restore or recovery.