Notes for transferring spfile and pfile in RAC Environment

Note: Do not use the "create pfile from spfile;" command to create a PFILE when maintaining the RAC environment.
 
The reason is that in the RAC environment, SPFILE is stored in shared storage by default (on bare devices or ASM disk groups ), each node of RAC uses the PFILE method to point to SPFILE to locate the SPFILE. That is, the pfile file stores the spfile path.
For example:
[Oracle @ rac1] # cat/oracle/app/oracle/product/10.2.0/db_1/dbs/nitracdb1.ora
Spfile = + DATA/racdb/spfileracdb. ora
Once the "create pfile from spfile;" command is used to create a PFILE, the new PFILE overwrites the PFILE in the original dbs directory. In this case, the PFILE file contains specific parameters, instead of the spfile path, the database instance will no longer read the SPFILE on shared storage when it is started, and then read the content of the local PFILE file.
The lab procedure is as follows:
1. By default, the PFILE initracdb. ora in the $ ORACLE_HOME/dbs directory contains only one row of records, recording the SPFILE path pointing.
[Oracle @ rac1] # cat/oracle/app/oracle/product/10.2.0/db_1/dbs/initracdb1.ora
Spfile = + DATA/racdb/spfileracdb. ora
 
2. You can obtain the database started with SPFILE from the database parameters.
SQL> show parameter spfile
NAME TYPE VALUE
--------------------------------------------------------
Spfile string + DATA/racdb/spfileracdb. ora
 
3. If you use the "create pfile from spfile;" command to create a PFILE, The SPFILE point in the original PFIEL will be replaced by the specific database parameters.
When the database is started again, because the SPFILE location cannot be found, the specific parameter values recorded in the PFILE file are used to start the database, this will have a great impact on database management.
SQL> create pfile from spfile;
SQL> show parameter spfile
NAME TYPE VALUE
--------------------------------------------------------
Spfile string/oracle/app/oracle/product/10.2.0/db_1/dbs/initracdb1.ora
 
4. Summary
This article describes a common sense problem. We hope that you will not bring unnecessary trouble to yourself during the maintenance and management of the RAC database.
What should I do if such a problem occurs? The method is relatively simple. Modify the pfile and point it to the spfile path again. spfile = + DATA/racdb/spfileracdb. ora
Restore the PFILE content to the content directed to by SPFILE.

RMAN restoration related concepts, spfile, controlfile Restoration

Oracle startup and spfile files

Use spfile to reset the configured initialization parameters to the default values of the system.

Another spfile setting error causes the database to fail to start.

Pfile parameter of Oracle oradim