To restore Oracle data

1. On the navigation bar, click the arrow next to Restore.

2. Click New Restore Job.

3. On the Properties pane, under Source, click Selections.

4. Click the View by Resource tab.

5. Expand the All Resources icon.

6. Expand the system resource that contains the database instance that you want to restore.

7. Expand the database instance that you want to restore.

   The current state of the database is listed to the right of the database name. The database must be in a Mounted, Nomounted, or Open state. You cannot select databases for restore jobs if they have a status of Down.

8. Expand either the Current Database or Control Files resource.

   If you restore a control file, the entire database reverts to the point in time of the selected control file backup. You cannot use this option to restore an individual tablespace or datafile.

   To restore an individual tablespace or datafile, make your selection from the online database view instead.

9. Select the appropriate items to restore.

10. On the properties pane, under Settings, click Oracle.

11. Complete the appropriate options as follows.

    Restore from full and/or incremental backups	Check Restore from full and/or incremental backups. Select an option to restore data from one of the following: The most recent available backups To a point in time To a specific system control number (SCN) RMAN determines which backup objects are necessary for this restore job, and then Backup Exec restores those objects. You may also need to check a recovery option for recovering from redo logs to complete the restore.
    To the most recent available	Select this option to restore the Oracle database to the most recent full and incremental backups that are available.
    To a point in time	Select this option to restore data up to and including a point in time. After the point in time, recovery stops. In the Date box, select the part of the date that you want to change, and then enter a new date or click the arrow to display a calendar from which you can select a date. In the Time box, select the part of the time that you want to change, and then enter a new time or click the arrows to select a new time.
    To an SCN	Select this option to restore up to and including a specific system control number (SCN). Type the SCN in the field provided.
    Restore read-only files if they are not current	Check Restore read-only files if they are not current to let RMAN examine the headers of all read-only datafiles and restore any that are not current.
    Validate only; do not restore data	Check Validate only; do not restore data to mount all required media and read it as necessary. RMAN selects the backup sets that are necessary to perform the operation, and scans them all to ensure that they are available and not corrupted. No data is written or restored to the database server. Symantec recommends that you select this option to ensure that all required media is available before you attempt to restore to the database.
    Restore/recover data if validation completes without errors	Check Restore/recover data if validation completes without errors to run the restore job immediately if the validation was successful. All options that you have selected for restore and recovery are performed.
    Recover using redo logs	Check Recover using redo logs to recover committed transactions from online and archived redo logs. Select an option to recover transactions up to the most recent available, or to a point in time, or to a specific system control number (SCN). RMAN determines which backup objects are necessary for this restore job, and then Backup Exec restores those objects.
    To the most recent available	Select this option to recover up to the last committed transaction that is available from the online and archived redo logs.
    To a point in time	Select this option to recover committed transactions from the online and archived redo logs up to and including a point in time. After the point in time, recovery stops. In the Date box, select the part of the date that you want to change, and then enter a new date or click the arrow to display a calendar from which you can select a date. In the Time box, select the part of the time that you want to change, and then enter a new time or click the arrows to select a new time. This option is only available when the database is in ARCHIVELOG mode. Caution: When you recover to a point in time by using a control file, make sure that the backup time of the control file is before the specified recovery point in time. The database structure should not have changed between the two times.
    To an SCN	Click this option to recover committed transactions from the online and archived redo logs to a specific system control number (SCN). After the SCN is recovered, recovery stops.
    After recovery, delete archived redo logs that are no longer needed	Check After recovery, delete archived redo logs that are no longer needed to delete older archived redo logfiles and free space on the hard disk.
    Open database after recovery	Check Open database after recovery to ensure that the database is opened as soon as the recovery is finished. Check this option if you want the database to be online after the recovery.

12. Select other restore options from the Properties pane as appropriate, and then start the restore job.

    See Restoring data by setting job properties.

13. Run a full backup of the restored database.