Above is the one way to create spfile from pfile.
SQL> shutdown immediate; SQL> startup nomount pfile='/u01/app/oracle/admin/PRIMARY/pfile/initPRIMARY.ora'; SQL>create spfile from pfile='/u01/app/oracle/admin/PRIMARY/pfile/initPRIMARY.ora'; -- Restart the Primary database using the newly created SPFILE. SQL>shutdown immediate; SQL>Startup;
what are the difference between above two ways of create spfile from pfile and which one is better.
startup pfile ='/u01/app/oracle/admin/PRIMARY/pfile/initPRIMARY.ora'; create spfile from pfile;