Previous Topic: Restore the Server Parameter FileNext Topic: Restore the Archived Redo Logs

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

Restore the Parameter File

The parameter file includes a list of initialization parameters and values for each 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 parameter file (pfile).

    Typically, the pfile (INIT<SID>.ORA) is located in the %ORACLE_HOME/database directory. You can type "INIT<SID>.ORA" to locate the pfile.

  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 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 parameter file.

The parameter file is restored.