Advanced Restore (Recover)
Use this dialog box to recover the database. Note that all the options described in this help may not be available and only the options displayed in the dialog box are applicable to the agent or feature for which the information is being displayed.
For information on how to recover an Oracle database, see Recovering an Oracle Database
Specifies whether the system will recover the database. Recover applies and restores any incremental backups and archived redo log files that are needed to bring the database back to the specified time/System Change Number (SCN).
Specifies that the database will be recovered to the current time.
Point In Time
Specifies whether the system will recover the database 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 database is recovered must be later than or equal to the date and time of the control files restore.
Specifies that the database will be recovered to the System Change Number that you specify. Use the space to enter the SCN.
Latest Backup Time
The latest backup job's end time is passed to the recover operation. This is the End Time on the Details Tab of the Job Details dialog box, which you can see by right-clicking the job and selecting View Job Details.
Latest SCN Number
The latest backup job's Next SCN number time is passed to the recover operation. This is the Next SCN on the General Tab of the Job Details dialog box, which you can see by right-clicking the job and selecting View Job Details.
Relative to System Date
Recover to the number of days or hours relative to the current system date. The default option is to recover relative to the number of days.
If you select the Days option, the valid values are 0-7.
If you select the Hours option, the valid values are 0-23.