Restore the Server Parameter File

The server parameter file is a repository for initialization parameters. Before you restore, you must locate the file. When you locate the files, ensure that the database is in the Open state.

Follow these steps:

  1. Log in to the computer where you want to restore the files.
  2. Locate the server parameter file using the following command:

    3. SQL> SHOW PARAMETER SPFILE;

  3. Shut down the database or the Oracle instance before you begin the restore process:

    4. SQL> SHUTDOWN IMMEDIATE;

  4. Log in to the Arcserve UDP Console.
  5. Restore the server parameter file using the Restore Wizard. For more information on the restore process, see How to Restore From a Recovery Point.
  6. Log in to the destination computer.
  7. Navigate to the specific folders and verify that the files are restored.
  8. Connect to SQL*Plus to restart the Oracle instance with the restored server parameter file.

    9. The server parameter file is restored.