Restore Options (Database)

Oracle | DB2 | SQL

Use this dialog box to restore DB2 database files and specify the destination for the restore.

Restore Data

Specifies that you can activate the appropriate restore mode(s) from the following.

• Entire Database

  Specifies whether to restore all of the data in the backup set. An entire DB2 database can be restored only if the affected database is offline.

• Database Subset

  Specifies whether to activate the backup set and its contents and to establish the restore of a subset of database objects. This restore mode can be implemented with the database either online or offline.

• History Files

  Specifies whether to restore the DB2 history files. These files contain database records regarding recovery and administration events.

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

  Click to refresh the screen with the current status of the database

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:

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

Destination Instance

Lists the names of the instances to which you can restore the data. To change a destination instance, click one in the list.

Target Database Name

Displays the name of the backup set that contains the data to be restored. You can use this space to change this name as long as the corresponding backup set has been created.

Target Database Path

Displays the location of the target database. You can use this space to change this location.

For DB2 or DB2 DPF on Windows only, be sure to include in this field just the letter of the appropriate drive followed by a colon (e.g., L:). Otherwise, the target database will not be accessed.

Browse

Click to browse for the location of the target database.

Advanced

Click to select additional restore options.

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.