Advanced Restore Options (Options)

Use this dialog box to choose additional restore options. Note that all the options described in this help may not be available and only the options displayed in the dialog box are applicable to the agent or feature for which the information is being displayed.

Time Zone

To view the information in the time zone that you require, click a time zone in the list.

Reset Database

Specifies whether the reset database command will direct RMAN to create a new database incarnation record in the Recovery Catalog. Selecting this option will reset the target database, and is to be used only when you open the database with the RESETLOGS option. Read Caution on the Use of RESETLOGS in Books Online before selecting this option.

Open DB

Specifies whether to open the database after the restore/recovery operation has completed. Selecting this option will open the database, and enable the Reset Logs option.

Reset Logs

Lists the following choices for resetting the logs when the database is opened:

  • None - Open the database without any RESETLOGS option.
  • Yes - Open the database with RESETLOGS option.
  • No - Open the database with NORESETLOGS option.

To change the setting, select one from the list. This option is only enabled when the Open DB checkbox is selected.

Switch Database Mode for Restore

When selected, the database mode will be changed automatically for the restore operation.

Backup Validations Only

You can select any of the following validation options to verify whether the backup copies of data and logs required for the restore are intact and usable.

DB Verify

Oracle DBVERIFY utility performs a temporary restore of database backup and verifies the restored backup files for the database block consistency.

After verification, the restored files in the restore directory (sapreorg) are deleted.

RMAN Validate

The Oracle Recovery Manager (RMAN) performs a temporary restore of database backup and verifies the restored backup files for the database block consistency.

Only Backup Inquiry

BACKINT for SAP DB inquires about former backups and displays the list of available backups for validation.