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.
Note: If you are using ONTAP version 8.3 and OCUM 6.2, revert is supported from the secondary snap for restores on NFS volumes.
Revert operations cannot be performed in a Windows cluster environment.
On UNIX clusters, use pre-process and post-process scripts to freeze and unfreeze the cluster for revert operations. For example, on Red Hat Linux cluster, use the following commands in the pre-process and post-process scripts:
clusvcadm -Z <group> to freeze the cluster
clusvcadm -U <group> to unfreeze the cluster
Freezing is required during the revert operation because the application is shut down and the corresponding volumes are unmounted. Under these conditions, the cluster automatically switches to failover to another node and prevents the revert operation.
Before You Begin
-
Shut down the database, or set the Commvault software to automatically move the database to the correct mode before the restore (Advanced Restore dialog box, Options tab, Switch Database Mode for Restore check box).
-
Review the supported configurations for revert operation. For more information, see Revert for Storage Arrays.
Procedure
-
From the CommCell Browser, go to Client Computers > client > Oracle.
-
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, select the Use Snap Restore check box.
-
Click Advanced.
The Advanced Restore Options dialog box appears.
-
On the General tab, select the Use hardware revert capability if available option.
Note: The restore control file option is automatically selected when 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 the 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 at all or it is outside of the data and log volumes, you can unselect the restore control file option.
-
To set the Commvault software to automatically move the database to the correct mode before the restore, on the Options tab, select the Switch Database Mode for Restore check box.
-
Click OK.
-
Click OK to confirm the revert operation.