Previous Topic: Restore From Latest Backup OptionNext Topic: Restore from Backup Tag Option


Restore From Backup Made On Option

When you select the Restore From Backup Made On option, you specify the date and time as the upper time limit of the backup from which you want to restore. RMAN will perform the operation on files up to, but not including, the specified time. This option is useful when you have a database that you must bring back to a known state (consistency level).

Another time you may want to use this option is when you know the latest backup is inaccessible. In that case, you can use this option in conjunction with the Until End of Logs recovery option to restore the database from an older backup set and "replay" all transactions to bring the database to its latest state.

Avoid confusing this option with the Recover Until Time (Whole DB Only) field that was available in earlier versions of the agent. It does not refer to which point in time the database will be recovered. It is used simply to select from which backup the data will be restored (Restore Until Time).

Note: No Recovery is the default selection in the Recovery Types section of the Oracle Restore Options tab. Be sure to select one of the other Recovery Types if you want to recover your database after restoring it.