When restoring data from a snapshot, note the following:
-
If the selected backup (latest or point-in-time) was an IntelliSnap backup, the subsequent restore will be an IntelliSnap restore.
-
During Snapshot restore operations, the database is shutdown first and then the snapshots are restored. Once restored, the database is changed to mount mode for the recover operation.
Snapshots are mounted on the destination client where the restore is performed. Hence, destination client should have access to the storage array/filer where snapshot was taken. If the destination client does not have access to storage device, then you should restore the data from snapshot using proxy computer. You can restore an oracle database on a ASM disk group using RMAN.
Restore - Restore Data from a Snapshot Using RMAN
Use the following steps to restore data from a snapshot using RMAN scripts:
-
From the CommCell Browser, go to Client Computers > RAC client.
-
Right-click the instance, then go to All Tasks > Browse and Restore.
The Browse and Restore Options dialog box appears.
Note
Restoring log data using RMAN is not supported.
-
Select Latest Backup, and then click the View Content button.
-
Select the database, and then click the Recover All Selected button.
The Oracle Restore Options dialog box appears.
-
Select the option for the type of restore operation, and then click Next.
An Oracle restore options dialog box appears.
-
From the General tab, select the Use Snap Restore check box.
-
Click Advanced.
The Advanced Restore Options dialog box appears.
-
Click Use RMAN Restore.
-
Click OK to save the settings and close the Advanced Restore Options window.
-
Click OK to close the Restore Options window and initiate the restore job.
Restore - Restoring and Recovering an Entire Database to the Same Host
When the database is corrupted or lost, you can restore and recover it from the latest offline or online full backup (depending on how the subclient was configured for backups).
By default, the database is restored to the same location from where it was backed up. Once the database is restored, it is recovered to the current time.
Use the following steps to restore and recover a database to the same host:
-
From the CommCell Browser, go to Client Computers > RAC client.
-
Right-click the instance, then go to All Tasks > Browse and Restore.
The Browse and Restore Options dialog box appears.
-
Select Latest Backup, and then click the View Content button.
-
Select the database, and then click the Recover All Selected button.
The Oracle Restore Options dialog box appears.
-
Click Restore in place, and then click Next.
The Oracle In Place Restore Options dialog box appears.
-
On the General tab, verify that the Restore Data and Recover options are selected.
-
Select the Restore Control File check box.
-
Click OK.
Reverting an Entire Database to the Same Host
You can use the revert operation to bring the Oracle database back to the point in time when the IntelliSnap backup was taken. However, the log volume will not be reverted. You can use either the file system or RMAN to restore the logs after you revert the data volume.
For more information, see Supported Volume Managers.
For more information on supported configurations for revert operation, see Revert for Storage Arrays.
-
From the CommCell Browser, go to Client Computers > RAC client.
-
Right-click the instance, then go to All Tasks > Browse and Restore.
The Browse and Restore Options dialog box appears.
-
Select Latest Backup, and then click the View Content button.
-
Select the database, and then click the Recover All Selected button.
The Oracle Restore Options dialog box appears.
-
Click Restore in place, and then click Next.
The Oracle In Place Restore Options dialog box appears.
-
Click Advanced.
The Advanced Restore Options dialog box appears.
-
Select the Use hardware revert capability if available option.
Note: The restore control file option is automatically selected once the Use hardware revert capability if available option is selected. This is because in most cases the control file is present on data volumes. You can select control file restore from autobackup/backup piece in advanced options if you don’t want to restore from snap. If you don’t want to restore the control file or it is outside of the data and log volumes, you can unselect the restore control file option.
-
Click OK.
-
Click OK to confirm the revert operation.
Restoring from a IntelliSnap and RMAN Mixed Environment
Case 1: Jobs run as follows:
-
Snap full job (data and log)
-
Streaming archive log only jobs
Restore/Revert can be performed from the snap job and control file/SP file restore can be done from the Streaming archive log jobs using autobackup/backup piece option.
Considerations:
- If archive log only restore are submitted, then it also uses the snap job only and restore archive logs which were included in the snap job. To restore archive logs from Streaming RMAN archive log jobs, select the copy precedence as the Primary copy of archive log storage policy and submit the restore.
Case 2: Jobs run as follows:
-
Snap full job (data and log)
-
Streaming RMAN full job (data and log)
-
Streaming archive log only jobs
Restore/Revert can be performed from the snap job and control file/SP File restore can be done from Streaming RMAN jobs using autobackup/backup piece option.
Considerations:
-
Restore job will pick the latest job for the specified time (it could be either snap or traditional RMAN) and use that job for restore.
-
If both the snap full job and traditional RMAN full job run parallel and complete at the same time, then the restore always picks the snap job only if you do restore from the instance level. To use the traditional RMAN backup, submit the restore from backup history after browsing the traditional RMAN job.
Restoring and Recovering an Entire Database to a Previous Point-in-Time
The point-in-time restore is useful in the following scenarios:
-
If any undesired transaction occurs in the database, you can revert the database to a state just before the transaction.
-
If a database fails, you can restore to the state just before the point of failure.
When you restore and recover an entire database to a previous point-in-time from an online backup or offline backup (depending on how the subclient was configured for backups) to the original host, it is recommended to use the control files.
Note
When you perform a point-in-time restore for a database, the next scheduled backup for that database will automatically convert to a full backup.
Use the following steps to restore and recover a database to a previous point-in-time:
-
From the CommCell Browser, go to Client Computers > RAC client.
-
Right-click the instance, then go to All Tasks > Browse and Restore.
The Browse and Restore Options dialog box appears.
-
Select Latest Backup, and then click the View Content button.
-
Select the database, and then click the Recover All Selected button.
The Oracle Restore Options dialog box appears.
-
Click Restore in place, and then click Next.
The Oracle In Place Restore Options dialog box appears.
-
Select the Restore Control File check box, if you want to restore the control files.
-
Click Advanced.
The Advanced Restore Options dialog box appears.
-
On the Restore tab, click To Point-in-Time and select the date and time.
-
On the Recover tab, click the Point-in-Time and select the date and time.
-
On the Ctrl & SP Files tab, if you have selected to restore the control files, select the Restore From check box.
-
Select To Point In Time and select the date and time.
You must restore the control files to a point-in-time later than or equal to the point-in-time set in the Restore tab.
-
Click OK.
-
Click OK.