Create pfile from memory

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;
SQL> !pwd
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

Hope so this feature will be useful for you. 🙂



Categories: Administration

Tagged as: ,

4 replies

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

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

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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s