If you perform a revert from an IntelliSnap job from a schedule policy, it will revert all the databases which were snapped in that IntelliSnap backup job to the same point-in-time. Ensure that you have performed an IntelliSnap backup for all the databases which share the same LUNs.
Ensure that both the data and log volumes are reverted for successful revert operation. By default, only the data volumes are reverted. Set the sREVERTARCHIVELOG additional setting to also revert the log volumes, in addition to data volumes.
To add or edit an additional setting, follow the steps in Add or Modify an Additional Setting.
Use these arguments:
-
In the Name box, type sREVERTARCHIVELOG. The Category and Type keys are automatically populated.
-
In the Value box, type Y.
Before You Begin
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.
Note
Even if you select one instance, it will revert all the databases that are included in the IntelliSnap job.
-
Click Restore in place, and then click Next.
The Oracle In Place Restore Options dialog box appears.
-
On the General tab, select Restore Control File.
-
Click Advanced.
The Advanced Restore Options dialog box appears.
-
Select the Use hardware revert capability if available option.
A message warns that the Oracle multi-instance snap optimization feature is enabled and that selecting the hardware revert option will result in restoring all the instances which are included in the shared IntelliSnap backup. The message informs you that the hardware revert can only be performed in-place and it will be automatically selected. The message also warns you that the selection of the revert option will overwrite the entire disk and all the existing data will be lost. Select Yes if you still want to continue. Select No if you do not want to continue.
-
On the Options tab, select Yes from the Reset Logs list.
-
Select Switch Database Mode for Restore.
-
Click OK to close the Advanced Restore Options dialog box.
-
Click Script Preview to verify the instances that are being reverted in the revert operation.
-
Click OK to start the revert operation.
Note
if the database is in mount mode while taking an IntelliSnap backup, then the same status is preserved even after the revert operation.
Once a revert is completed, resync the catalog using RMAN to register the new incarnation.
Example:
[oracle@brahmani64 ~]$ export ORACLE_SID=par2
[oracle@brahmani64 ~]$ rman target / catalog snap/snap@test
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jul 13 10:04:19 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: PAR2 (DBID=1259990815)
connected to recovery catalog database
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
RMAN>