Control files are required to recover a database to the current state. Restore control files when the control file is lost and you need to restore the backup repository contained in the control file.
Configure an auto backup of control files to restore the control file from auto backup. The control file restore destroys all the previous backups.
If your database consists of multiple control files copies, you can replace a corrupted control file by manually copying an existing control file, and then restoring it.
Before You Begin
-
Perform a full backup.
-
Place the database in NOMOUNT mode, or set the Commvault software to automatically move the database to the correct mode before the restore.
Procedure
-
From the CommCell Browser, expand Client Computers > client> SAP for Oracle.
-
Right-click the instance, point to All Tasks and then click Browse and Restore.
-
Select Latest Backup and click View Content.
-
Optional: Use non-default Browse and Restore options. See Browse and Restore.
-
In the right pane of the CommCell Browser window, select all the database, and click Recover All Selected.
-
To restore the latest backup to the same location, on the Restore Options dialog box, select the Restore Control File check box and click OK.
-
For all other restore options, on the Restore Options dialog box, select the Restore Control File check box and then click Advanced.
The Advanced Restore Options dialog box is displayed.
-
On the Ctrl Files tab, select the Restore Control File and Restore Control File As check boxes and then enter the full path where you want to restore the control file.
-
Click OK to close the Advanced Restore Options dialog box.
-
Click OK to close the Restore Options dialog box and start the restore.
What to Do Next
-
Place the database in MOUNT mode.