Restore Options

Restore Options

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

Use Snap Restore

This option is applicable when SnapProtect backup is configured for the agent.

After selecting this option, the advanced restore dialog box will display only the options applicable for snap restore.

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 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:

  • 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. This description can include information about the entity's content, cautionary notes, etc.

Advanced

Click to select additional restore options.

Archive

Archived Database

Restore to the archived database.

  • Client

    Specifies the client that contains the archived database

  • Database Name

    Specifies the archived database.

Source Database

Restore to the Source Database.

Restore to the source database.

Redirect Path for archive data files

Specify the path used for redirecting the archive data files.  Use Browse to locate it.

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.

For more information on restores performed from the command line, see Command Line Interface for Oracle iDataAgent.