Loading...

Restoring Control and Server Parameter Files for Oracle

Control and SP files are required to recover a database to the current state. Restore control and SP files in the following scenarios:

  • The control file is lost and you need to restore the backup repository contained in the control file
  • The recovery catalog is lost
  • The recovery catalog was never used
  • The catalog connect string is not specified for the instance during the backup

Configure an autobackup of control files to restore the control file from an autobackup. 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

  1. Perform a Control File Backup.
  2. Place the database in NOMOUNT mode, or set the Commvault software to automatically move the database to the correct mode before the restore.
  3. Optional: When the backup pieces are unknown to the RMAN repository, catalog the backup pieces. For more information, see Cataloging RMAN Backup Pieces.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. Select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. In the right pane of the CommCell Browser window, select the database, and click Recover All Selected.
  6. Depending on the type of restore to be run, click Restore in place or Restore out of place, and then click Next.

    The Oracle In Place Restore Options or Oracle Out of Place Restore Options dialog box appears.

  7. 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.
  8. For all other restore options, on the Restore Options dialog box, select the Restore Control File and Restore SP Files check boxes and click Advanced.
  9. On the Advanced Restore Options dialog box, click the Ctrl & SP Files tab and then select the Restore Control File and Restore From check boxes.
  10. Select the method to use when restoring the control file.

    Restore the control file to the latest backup

    Restore the control file to a specific backup piece

    Restore the control file to a point-in-time

  11. To restore the control file to a new location, on the Ctrl & SP Files tab in the Restore Control File section, select the Restore SP File As check box and enter the path in the box.
  12. To set the Commvault software to automatically move the database to the correct mode before the restore, select the Switch Database Mode for Restore check box.
  13. Optional: Select the restore options.

    Set the Oracle Database ID

    Reset the database and logs.

    Perform a point-in-time restore of a database that was backed up in NOARCHIVELOG mode

    Prevent RMAN failovers to the previous backup for Oracle 10g databases or higher

    Validate the restore

    Configuring Pre- and Post-Processes

    Restore from a copy precedence

    Restore from a specific backup

    Open the database after the restore

  14. Click OK to close the Advanced Restore Options dialog box.
  15. Optional: View or customize the RMAN script that is automatically generated from the selected options. For more information, see Viewing Oracle Restore RMAN Scripts and Customizing Oracle Restore RMAN Scripts.
  16. Click OK to close the Restore Options dialog box and start the restore.

What to Do Next

  1. Place the database in MOUNT mode.
  2. Perform a full database restore.

Last modified: 6/4/2019 6:05:38 PM