Advanced Restore (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.

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.

No Re-do Logs

Specifies whether you will perform a point-in-time restore when the database is in NOARCHIVELOG mode. If you do not select this option, the point-in-time recovery will fail.

Validate

Specifies whether to run a validate restore job, which will cause RMAN to simulate a restore job for the purpose of determining whether copies of data required for the restore are intact and usable.

Switch Database Mode for Restore

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

When this option is selected, one of the following must be configured for the database being restored.

  1. There must be a static TNS listener defined for the database (See When do we configure a static listener for additional information), or
  2. The Connect String for the database must be set to a "/".

Disable Oracle Channel Restore Failover

When selected, prevents RMAN to failover to the previous backup to complete the restore operation for Oracle 10g or higher version. This will avoid job delays caused by the failover operation.

Set DBID

Specifies to set the DBID of the target database to perform restore of control file and/or spfile from autobackup. This option is primarily used

  • when there is no catalog and you need to restore the control file or spfile from autobackup.
  • when you need to restore the control file when there are multiple databases with the same name in the catalog.

Max Open Files

Use this space to specify the maximum number of concurrent open datafiles that RMAN can read from simultaneously during a restore operation.

Set DB Incarnation

Specifies the database incarnation value to be reset in order to restore the database to a point-in-time before the last reset logs