Many a times situation comes when database initialization parameter file gets accidentally removed or overwritten.
From version 11g Oracle has came up with solution of recreating parameter file from memory if database is up & running.
Oracle already has functionality of creating pfile from spfile & vice-versa. But now with almost similar syntax u can create pfile from memory.
SQL> select version from v$instance; VERSION ---------------- 11.2.0.3.0 SQL> SQL> !pwd /home/oracle/pfile SQL> !ls -lrt total 0 SQL> create pfile='/home/oracle/pfile/initORACLE.ora' from memory; File created. SQL> !ls -lrt total 8 -rw-r--r-- 1 oracle oinstall 6431 Jun 2 21:33 initORACLE.ora SQL>
Hope so this feature will be useful for you. 🙂
Cheers
Regards,
Adityanath
Categories: Administration
Adityanath's Oracle Blog 
Hey! This is my 1st comment here so I just wanted to give a quick shout out and say I truly enjoy
reading through your posts. Can you suggest any other blogs/websites/forums that cover
the same subjects? Thanks!
After research just a few of the weblog posts on your web site now, and I really like your approach of blogging. I bookmarked it to my bookmark web site record and can be checking again soon. Pls take a look at my web site as properly and let me know what you think.
This is very interesting, You are a very skilled blogger.
I’ve joined your feed and look forward to seeking more of your wonderful
post. Also, I’ve shared your website in my social networks!
very interesting topic, outstanding post.
I like the valuable information you provide in your articles.
I’ll bookmark your blog and check again here frequently.
I’m quite certain I’ll learn many new stuff right here!
Good luck for the next!
Hi there, You’ve done a great job. I’ll certainly
digg it and personally suggest to my friends. I’m confident they’ll be benefited from this site.
Wonderful blog! I found it while surfing around on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Appreciate it
This will be a excellent blog, would you be interested in doing an interview about how you created it? If so e-mail me!