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.

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.


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. TheConnect String for the database must be set to a "/".

Disable Oracle Channel Restore Failover

When you select this check box, the Commvault software does not restore from a failover backup piece. The Oracle behavior remains the same, that is it fails over to another backup piece name.

The Commvault software enables this option by default because it might print restore database corruptions.


Set the DBID of the target database to perform a restore of the control file and/or spfile from autobackup. Use this option:

  • 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 data files 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.

Last modified: 7/2/2018 7:06:30 PM