Updating spfile dating advice posts

When an Oracle Instance is started, the characteristics of the Instance are established by parameters specified within the initialization parameter file. SPFILEs provide the following advantages over PFILEs: A PFILE is a static, client-side text file that must be updated with a standard text editor like "notepad" or "vi". An SPFILE (Server Parameter File), on the other hand, is a persistent server-side binary file that can only be modified with the "ALTER SYSTEM SET" command.These initialization parameters are either stored in a PFILE or SPFILE. This file normally reside on the server, however, you need a local copy if you want to start Oracle from a remote machine. This means you no longer need a local copy of the pfile to start the database from a remote machine.Tagged: duplicate database, ORA-65500: could not modify DB_UNIQUE_NAME, resource exists, RMAN-03009, RMAN-03015, RMAN-11003.

updating spfile-7

You can leave a response, or trackback from your own site.

Now edit the pfile in notepad to make the changes need to allow Oracle to start. These parameters help the Oracle programs know how to start.

The SID parameter (optional; only used with RAC) indicates the instance for which the parameter applies (Default is *: all Instances).

Use the following syntax to set parameters that take multiple (a list of) values: RMAN (Oracle's Recovery Manager) will backup the SPFILE with the database control file if setting "CONFIGURE CONTROLFILE AUTOBACKUP" is ON (the default is OFF). Look at this example: Hi, I am running Oracle 10g and used the Oracle Enterprise Manager to alter my UTL_FILE_DIR parameter.

As the PFILE is text based, one can edit it in an editor like vi on UNIX or Notepad on Windows.