Restore Options (Table Restore)

Restore Options (Table Restore)

Use this dialog box to choose the table restore options:

Users/Tables selected for Restore

Displays all selected users and tables.

Auxiliary Instance

Specifies the instance name that is used to duplicate the source database with the required tablespaces to export the table from RMAN backup.

Database Name

Specifies the auxiliary database name.

Database Client

Specifies the auxiliary database client name.


Specifies the initialization parameter init<SID>.ora file for the auxiliary instance.


Click to browse and select the PFile.

Staging Path

Specifies the path used as the staging area to store datafiles for the auxiliary instance and the complete export tables before importing.


Click to browse and select a staging path.

Cleanup Auxiliary

Specifies that the auxiliary instance will be deleted once the restore operation completes. By default, this option is selected.

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.