Oracle Restore Options (General)

Updated

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:

  • Which are established as clients within the CommCell.

  • Clients with Operating Systems that support the cross-platform restore operation from this client.

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

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)

Refresh

Click to display the most 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:

  • Latest backup, or a

  • Backup from a specific point in time.

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. You can include information such as the entity's content, and cautionary notes.

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 box, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be run from the Command Line Interface using qoperation execute command.

When you save an operation as a script, each option in the dialog box has a corresponding XML element in the script file. When you run the script, you can modify the value in any of these XML elements.

For more information about restores performed from the command line, see the following documentation:

Was this page helpful?