If a Server Parameter (SP) File is lost, you can choose to restore from IntelliSnap backup, auto backup, or backup piece. Ensure that the database is in SHUTDOWN mode while restoring the SP file. If you are trying to restore the SP file from a VSS IntelliSnap backup, the database is automatically set to STARTED mode after the SP file is restored.
Use the following steps to restore an SP file from a backup:
-
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.
-
Optional: Use non-default browse and restore options. For more information, see Browse and Restore.
-
Select the database, and then click the Recover All Selected button.
The Oracle Restore Options dialog box appears.
-
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.
-
Select the Restore SP File check box.
-
If you are using a backup copy for the restore do the following:
-
Click Advanced.
-
Click the Copy Precedence tab and select the Restore from Copy Precedence check box.
-
In the Copy Precedence box, type the copy precedence number for the backup copy and click OK.
-
-
Click OK.