Create pfile from memory

Published on

June 2, 2014

3,933 hits

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

12 responses to “Create pfile from memory”

SMEs

July 10, 2019

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!

Reply
Arturo Keuper

November 13, 2020

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.

Reply
Jacques

November 16, 2020

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!

Reply
Dannie Bringman

January 5, 2021

very interesting topic, outstanding post.

Reply
Mallory

August 20, 2021

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!

Reply
Epifania

August 24, 2021

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.

Reply
Timmy Parlavecchio

August 28, 2021

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

Reply
Luther Horne

August 29, 2021

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

Reply
Rosalinda

January 27, 2022

Very nice post. I just stumbled upon your weblog and wished
to say that I’ve truly enjoyed surfing around your blog posts.
After all I will be subscribing to your feed and I hope you write again very
soon!

Reply
Anonymous

September 16, 2023

I cannot thank you enough for the blog.Thanks Again. Really Cool.

Reply
捷报比分足球

September 18, 2023

Great, thanks for sharing this blog.Really thank you! Really Great.

Reply
Nevaeh Shepherd

September 20, 2023

Thanks in favor of sharng such a fastidious thinking, post is nice, thats why i have read it fully Kaylil Terrence Raji

Reply