Recently I’ve been playing Tetris with my databases. Duplicating databases and reconciling differences due to a change management system with significant gaps. During one of these fun moments I ended up with a database using a SPFILE, but the SPFILE didn’t actually exist. Simple fix:
create pfile from memory;
All was well as it saved me from having to re-create the pfile using the alert.log. The SPFILE can be created this way as well provided you are using a pfile:
create spfile from memory;
Every minute I can save with little tidbits such as the above is precious.