Use this dialog box to restore data and archive logs. Note that all the options described in this help may not be available and only the options displayed in the dialog box are applicable to the agent or feature for which the information is being displayed.
Restore Data
Specifies whether to restore data files from the specified full backup. When cleared, the system does not restore data files.
Data is restored from the latest full backup only. If you have performed incremental backups and need to apply this data to the full backup, see the description of the Recover option below.
-
To Point In Time
Specifies that the system will restore data files from the full backup created at or before the point-in-time based on the date and time that you specify. For a Point-In-Time recovery, you should have all log files available up to that time.
To change the date, click one in the list. Also, use the space to set the appropriate time. Ensure that the date/time that you enter is equal to or later than the date and time that the backup completed. Also, ensure that the date/time to which the data files are restored is earlier than or equal to the date and time of the control files restore.
-
Tag
Specifies that the backup tag assigned to the specific backup that you want to restore will be entered. Tags are constructed at the time of backup. Since data is restored from full backups only, ensure that the tag you select is the tag for a full backup. Use the space to type the backup tag.
-
From the Latest Backup
Specifies that data files will be restored from the latest full backup.
-
Check READ ONLY
Specifies whether the read-only tablespaces are checked for consistency. If the tablespaces are not consistent, or if they are missing, they are restored. Otherwise, they are not restored.
When cleared, the read-only tablespaces are not checked for consistency and restored from the backup.
Restore Archive Log
Specifies whether to restore the archive log files.
-
If the archived log files exist in the LOG_ARCHIVE_DEST location and are not corrupted, the backed up archive log files are not restored.
-
If the archive log files do not exist or are unusable, the backed up archive log files are restored to the directory specified in LOG_ARCHIVE_DEST.
When cleared, the system does not restore the archive log files.
-
By Log Time
Specifies that the archive log files will be restored based on the specified dates and times that you specify.
-
Start
When selected and used without the End Log Time option, specifies that the system will restore all archive log files starting from the date and time that you specify and up to the current date. When selected and used with the End Log Time option, specifies that the system will restore all archive log files starting from the date and time that you specify and up to the date specified by End Log Time.
To change the start date, click one in the list. Also, use the space provided to enter a new start time.
-
End
When selected and used with the Start Log Time option, specifies that the system will restore archive log files starting from the date and time specified by Start Log Time up to the date and time specified by End Log Time. When selected and used without the Start Log Time option, specifies that the system will restore archive log files from the oldest active backed up archive log file up to the date and time specified by End Log Time.
To change the end date, click one in the list. Also, use the space provided to enter a new end time.
-
By LSN
Specifies that the system will restore the archive log files based on the specified Log Sequence Numbers (LSNs) that you specify.
-
Start
When selected and used without the END LSN option, specifies that the system will restore archive log files starting from the log file with the sequence number that you specify in START LSN and ending with the current log file.
When selected and used with the END LSN option, specifies that the system will restore archive log files starting from the log file with the sequence number that you specify in START LSN and ending with the log file sequence number that you specify in END LSN. Use the space to enter the start LSN.
-
End
When selected and used without the START LSN option, specifies that the system will restore archive log files from the oldest available archive log file and ending with the sequence number that you specify in END LSN. All the Log Sequence Numbers from log #1 must be backed up to tape. Use the space to enter the end LSN.
-
Auto Detect Device
For SAP for Oracle, specifies whether the system should automatically detect the device that was used for the backup. This field is selected by default. If you have old data, you may need to use the SAP Device Type field below as an alternative.
-
SAP Device Type
For SAP for Oracle, click to manually select the device that was used for backup. If you have old data, you may need to use this field as an alternative to the Auto Detect Device field above.
-
By Tag
Specifies that the system will restore the archive log files based on the tag name that you specify. Use the space provided to enter the tag name.
-
Target Directory
Use this space to type the specified destination directory to which the archive log files will be restored. Alternatively, click Browse for this purpose.
If you leave this field blank, the archive log files are restored to the LOG_ARCHIVE_DEST location.
-
Browse
Click to establish the directory for restoring the archived log files.