Previous Topic: Review the Prerequisites and ConsiderationsNext Topic: Restore the Parameter File

Using Arcserve UDP Agent (Windows) › Perform a Restore › How to Restore an Oracle Database › Restore the Server Parameter File

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: 
    SQL> SHOW PARAMETER SPFILE;
  3. Shut down the database or the Oracle instance before you begin the restore process: 
    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.

The server parameter file is restored.