Backup Recovery   «Prev 

Oracle Recovery Wizard

Using the Recovery Wizard

View the images below for an explanation of the recovery selection process using the Recovery Wizard for recovering tablespaces and datafiles. You can recover the entire database to the latest time or to a point in time if the database is in ARCHIVELOG mode and MOUNT state.

Because the database is in OPEN state, it is only possible to recover tablespaces or datafiles
A tablespace backup is a backup of a subset of the database. Tablespace backups are generally valid if the database is operating within the ARCHIVELOG mode.

The Original Name field specifies the full path and filename of the selected data files. You can not edit this field.

Oracle Backup and Recovery
Choose the configuration for this backup and click the Finish button.

Because the database is in OPEN state, it is only possible to recover tables spaces or datafiles.

A datafile recovery is the recovery of a single datafile. Datafile recoveries, which are not as common as tablepsace recoveries, are generally valid if you run the database within the ARCHIVELOG mode.

The Rename page enables you to restore the selected datafile(s) to a new location. When datafiles are restored to a new location, they are considered datafile copies. For this reason, a switch is automatically performed.

Choose the configuration for this backup and click the Finish Button.

Oracle RMAN Backup and Recovery

Restore and recover the database using the default disk channel

To restore and recover the database using the default disk channel, perform the following steps:
  1. From the Backup Management menu, choose Recover to access the Recovery Wizard.
  2. On the Operation Selection page, select either Restore and recover, Restore only, or Recover only.
  3. On the Object Selection page, select Entire Database.
  4. Specify a range (recovery until time) on the Range Selection page of the Recovery Wizard.
    You can select to recover the database to a point-in-time in the past if you have selected Restore and recover or Recover only on the Operation Selection page, and the database is in the MOUNT state and ARCHIVELOG mode.
  5. You can specify a point-in-time in the past by giving a time, an SCN or a log sequence number if you had selected Restore only in the Operation Selection page.
  6. Later, in the process, wizard pages will appear in which you will have the option to perform the following tasks:
    1. Specify to restore the files to a different location and rename them; thereby making datafile copies.
    2. Select the default configuration or any of the user created configurations for the backup. A default configuration is created by Enterprise Manager for each target database.