Advanced Restore Options (Recover)

Use this dialog box to recover the database.

Recover

Specifies whether to recover the database with the options below. 

  • Current Time

    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.

Before using the Recover option in combination with the Point-In-Time option to recover the Oracle database to a point-in-time, read Caution on the Use of RESETLOGS in Books Online.

  • SCN

    Specifies that the database will be recovered to the System Change Number that you specify. Use the space to enter the SCN.