11g new feature (Creating Pfile)

11g New Feature in case lost pfile or spfile.

Create pfile from your your memory (from alert.log)

when instance startup, all parameter setting goes to alert.log file.

Command for create pfile in 11g.

SQL> create pfile='ORACLE_HOME/dbs/initofdev.ora' from memory;

SQL> create pfile='ORACLE_HOME/dbs/spfileofdev.ora' from memory;

SQL> create spfile from pfile;

---------------------------------------------------------------------