Use this dialog box to select restore options.
Destination Client
Displays the name of the client computer to which the selected data will be restored. Select a client from the list to change the destination computer.
The list includes the following clients:
By default, data is restored to the same computer from which it was backed up.
Number of streams to use for restore
Use this space to set the number of data channels through which data is restored.
Catalog Connect
Displays the connect string for the catalog database. The recovery catalog contains metadata about RMAN operations for each registered database. This metadata information is useful when you want to restore and recover the database after a crash or corruption.
Use the three fields (spaces) to type the connect string for the catalog database. Use the first field to type the recovery catalog database user ID. Use the second field to type the password for the user ID, and use the third field to type the recovery catalog service name.
When restoring backups with recovery catalog, the connect string details used during the backup will get automatically displayed here.
Restore Control File
Specifies whether to restore the control file from the latest control file backup or from a backup piece to its original location or to a new location.
Restore Archive Log
Specifies whether to restore the archived redo log files. Selecting this option will allow you to choose the options for restoring the archive logs.
Restore SP File
Specifies whether to restore the server parameter file (SP File). Selecting this option will allow you to choose the options for restoring the server parameter file.
Restore Data
By default, this option is selected along with Recover option. Selecting this option will allow you to choose the options for restoring the datafiles.
Recover
By default, this option is selected along with Restore Data option. Selecting this option will allow you to choose the options for recovering the database after a restore.
Duplicate DB
Specifies whether to create a duplicate database. Selecting this option will display the Duplicate and Duplicate DB Options tabs in Advanced Restore options allowing you to choose options for creating a duplicate database.
NO CATALOG
Specifies whether the system will refer to the Recovery Catalog database when recovering the target database. If this option is selected, the system will instead refer to the target database's control files. Use this option if the Recovery Catalog database has been corrupted or if you did not use the Recovery Catalog database to back up the data.
When cleared, the system looks up the Recovery Catalog database when recovering the target database. This option can be used only if the CONTROL FILE exists.
The Latest Database View
By default, displays the database tree as it existed in the latest backup. Use the tree structure to establish either an entire or partial database restore by selecting the appropriate entity.
If you specify a point-in-time when you click New Browse, the database tree as existing in the specified point-in-time is displayed.Status
Displays the state of the database. (OPEN, MOUNTED, STARTED or SHUTDOWN)
RefreshClick to refresh the screen with the current status of the database
New Browse
Click to display the Specify Point-In-Time dialog box, which allows to you to select the options to restore from either the:
By default, the database tree is displayed in the latest backup data pane. It is suitably refreshed based on the selected option.
Description
Use this field to enter a description about the entity. This description can include information about the entity's content, cautionary notes, etc.
Advanced
Click to select additional restore options.
Script Preview
Click to display the restore script, based on the selected restore options, that will be submitted to RMAN when restores are performed for the selected Oracle client.
Save As Script
Click to open the Save As Script dialog, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be executed from the Command Line Interface using qoperation execute command.
When you save an operation as a script, each option in the dialog will have a corresponding xml parameter in the script file. When executing the script, you can modify the value for any of these XML parameters as per need.
To view the XML values for each of the options in the dialog, see the following: