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
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.