Oracle 11g create spfile from memory.

In pre Oracle 11g releases we had the feature of conversion from SPFILE to PFILE and vice versa. But Oracle 11g has gone one step further, SPFILE can now be created directly from memory.

SQL> create spfile=’/u01/app/spfileorcl.bak’ from memory;

This command will capture all the settings from the memory and dump them to an SPFILE. This is a very useful utility to take backup of your SPFILE before any changes are made using ‘alter system’ command. In order to check and read the new created file the following command can be used : -

 
SQL>!strings /u01/app/spfileorcl.bak