Oracle Restore Options (General)

Use this dialog box to select restore options.

Destination Client/Computer/Server

Displays the name of the client computer to which the selected data will be restored. To change the destination computer, select one from the list. The list includes 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.

You can use the three fields (spaces) to enter 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 to its original location.

Restore Archive Log

Specifies whether to restore the archived redo log files based on the following:

Restore SP File

Specifies whether to restore the server parameter file (SP File). Selecting this option will cause the Advanced button when clicked to display the Ctrl & SP Files tab, allowing you to choose options for restoring the server parameter file and control file.

Restore Data

Specifies whether to restore the database based on the selected options.

Recover

Specifies whether to recover the database by applying any incremental backups and archive redo logs that are needed to bring the database back to the current time.

Before using the Recover option in combination with the Point-In-Time option to recover the Oracle database to a point-in-time, read Caution on the Use of RESETLOGS.

Duplicate DB

Specifies whether to create a duplicate database. Selecting this option will cause the Advanced button when clicked to display the Duplicate and Duplicate DB Options tabs, allowing you to choose options for creating a duplicate database.

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.

For Oracle and Informix, if you specify a point-in-time by clicking the New Browse button, 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 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 options to restore from either the:

The database tree displayed in the latest backup data pane is suitably refreshed based on the selected option.

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.

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.

Back to Top