Use notes for spfile and pfile in Oracle

Check whether the system is started with pfile or spfile.
Select isspecified, count (*) from v $ spparameter group by isspecified;
If true exists in isspecified, the specified configuration is performed with spfile.
If all values are false, pfile is enabled.

Benefits of using SPfile
Spfile corrected the confusion of pfile management. In a multi-node environment, pfile has multiple images.
The latest image needs to be tracked during startup. This is a cumbersome process.
After spfile is used, all parameter changes are written to spfile (as long as scope = spfile or both is defined). The parameter configuration has an authoritative source.

View spfile location
Show parameter spfile

Get pfile from spfile
Create pfile = 'd: pfileSID. ora 'from spfile;
Create pfile = 'd: pfileSID. ora 'from spfile = 'spfile _ location ';

Get spfile from pfile
Create spfile from pfile = 'your _ pfile_location'
Create spfile = 'spfile _ location' from pfile = 'your _ pfile_location'

Dynamic Parameter Modification
Alter system set parameter = Value scope = spfile | both | memory

When Startup nomount, spfile or pfile needs to be read. The two coexist, and spfile takes precedence.

Force start with pfile
SQL> startup pfile = 'your _ Pfile. ora'
Startup spfile = '/data/Oracle/product/10.2.0/db_1/dbs/spfile_mqq.ora' force

Use pfile to connect to spfile to start
Modify pfile