Losing your SPFILE

If you have lost your spfile it is possible to restore it using the DBID and a control file.
However, things become complicated if the DBID is not available or autobackups are not taken.


If you still have the pfile or have an init file for the database from a previous occasion then the following command can be used to restore spfile using that init file.

--#create new spfile from pfile

create spfile = 'spfileinstance' from pfile = 'init.ora'

The init file can be found in
/u01/app/oracle/admin/instance/pfile/init.ora