Restore Options (Database)

Oracle |  DB2

Use this dialog box to restore Oracle database files. For Oracle, a catalog connect string must be entered.

Destination Client

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:

  • Which are established as clients within the CommCell.
  • Clients with Operating Systems that support the cross-platform restore operation from this client. (Refer to the topic titled Cross Platform Restore Operations in Books Online for additional information.)

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 the system will restore the control file of the target database. If the To Point in Time and the Restore Control File As options are not selected, the control files is restored from the latest control file backup to its original location. When cleared, the system will not restore the control file of the target database.

Restore Archive Log

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

  • If the archived redo log files exist in the LOG_ARCHIVE_DEST location and are not corrupted, the backed up archived redo log files are not restored.
  • If the archived redo log files do not exist or are unusable, the backed up archived redo log files are restored to the directory specified in LOG_ARCHIVE_DEST.

Restore SP File

Specifies whether to restore the server parameter file (SP File) of the target database. If the To Point in Time and the Restore SP File As options are not selected, the server parameter file is restored from the latest backup to its original location. When cleared, the system will not restore the server parameter file of the target database. Keep in mind that RMAN cannot overwrite a server parameter file currently in use by the target database.

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 logs that are needed to bring the database back to the current time.

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.

Advanced

Click to select additional restore options.

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.