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

Tagged as: ,

8 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!

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

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

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

  7. This will be a excellent blog, would you be interested in doing an interview about how you created it? If so e-mail me!

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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