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 Redo 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. The Connect 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.


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 in the following cases:

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

Change DBID

This option only applies to cross-machine restores. Select this check box when you want the destination database DBID to be different from the source database DBID. When you select this check box, the software changes the destination database DBID after a cross-machine restore.

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

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