You can set the following options when you create a restore job for Oracle.
See Restoring Oracle data.
Table: Oracle restore options
|
Item
|
Description
|
|
Restore from full and/or incremental backups |
Specifies a restore method.
Select an option to restore data from one of the following:
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 |
Restores the Oracle database to the most recent full and incremental backups that are available.
|
|
To a point in time |
Restores 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 |
Restores 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 |
Enables RMAN to examine the headers of all read-only data files and restore any that are not current.
|
|
Validate only; do not restore data |
Mounts all required media and reads 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. Validation of the control file is not supported.
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 |
Lets you run the restore job immediately if the validation was successful.
All options that you have selected for restore and recovery are performed.
|
|
Restore the control file only |
Recovers the control file for the Oracle database, but does not include the tablespaces or the associated data files.
|
|
Recover using redo logs |
Recovers 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 |
Recovers up to the last committed transaction that is available from the online and archived redo logs.
|
|
To a point in time |
Recovers 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 |
Recovers 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 |
Deletes older archived redo log files and free space on the hard disk.
|
|
Open database after recovery |
Ensures 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.
|
Oracle restore options