Oracle SPFile and PFILE

CREATE spfile FROM pfile;

You can also create a new init.ora file from the SPFILE in the default location by using the following command:

SQL> CREATE pfile FROM spfile;
File created.
SQL>

or use specify a file

CREATE PFILE = '$ORACLE_HOME/dbs/my_pfile.ora' FROM SPFILE;