Advanced Restore Options (Control and SP Files)

Use this dialog box to restore the control file and the server parameter file.

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.

From Autobackup

Specifies whether to restore the control file from the latest autobackup.

Replicate

Specifies whether to copy the restored control file to the locations specified in the CONTROL_FILES initialization parameter of the target database.

To Point In Time

Specifies whether the system will restore the control file to a specific point in time that you specify. To change the date, click one in the list. Also, use the space to enter the appropriate time. The date and time to which the control files will be restored must be later than or equal to the date and time to which the database datafiles will be restored. Synchronize the time between the computers hosting your CommServe and Oracle client before you specify the date and time for the point-in-time restore.

Restore Control File As

Specifies whether the system will restore the control file to the name and location that you specify. If you select this option, either use the space to type the desired location or click Browse to find this location. The restored control file will not be automatically replicated to the control files of the database, but this can be done manually. Restoring a control file to a new location can be performed even without a recovery catalog. The database should be mounted for this type of restore.

Browse

Click to restore to the specified destination directory and enter a name for the control file.

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.

From Autobackup

Specifies whether to restore the server parameter file from the latest autobackup.

To Point in Time

Specifies whether to restore the server parameter file to a specific point in time that you specify. To change the date, click one in the list. Also, use the space to enter the appropriate time. The date and time to which the server parameter file will be restored must be later than or equal to the date and time to which the database datafiles will be restored. Synchronize the time between the computers hosting your CommServe and Oracle client before you specify the date and time for the point-in-time restore.

Restore SP File As

Specifies whether the system will restore the server parameter to the name and location that you specify. If you select this option, either use the space to type the desired location or click Browse to find this location.

Browse

Click to restore to the specified destination directory and enter a name for the server parameter file.

Back to Top