Advanced Restore Options (Options)

Use this dialog box to choose additional restore options.

Time Zone

Lists the time zones. To change the time zone, click one 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.

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.

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