OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » spfile recovery

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

spfile recovery [message #320937]

Fri, 16 May 2008 15:44

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi,

suppose my spfile is missing.none other paramerter file is available in database ,then how to recover spfile??

Regards,

Balaji

Report message to a moderator

Re: spfile recovery [message #320939 is a reply to message #320937]

Fri, 16 May 2008 15:46

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create a init.ora from alert.log and then create a spfile from this init.ora

Regards
Michel

Report message to a moderator

Re: spfile recovery [message #320940 is a reply to message #320937]

Fri, 16 May 2008 15:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When the database is started, the non-default parameters & their values are written to the alert_SID.log file.
So you should be able to obtain everything you desire from the Alert Log File!

Report message to a moderator

Re: spfile recovery [message #321068 is a reply to message #320940]

Sun, 18 May 2008 22:33

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thanks for the reply.

Report message to a moderator

Re: spfile recovery [message #347791 is a reply to message #321068]

Sun, 14 September 2008 00:25

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Can anybody tell me how to recover a lost spfile using rman?

Regards,

Report message to a moderator

Re: spfile recovery [message #347794 is a reply to message #347791]

Sun, 14 September 2008 00:39

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Oracle version?

Regards
Michel

Report message to a moderator

Re: spfile recovery [message #347795 is a reply to message #347791]

Sun, 14 September 2008 00:40

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Can anybody tell me how to recover a lost spfile using rman?
"restore spfile from autobackup;"
"restore spfile from 'flash_recovery_area';"
"restore spfile from 'backupfile_path';"

Report message to a moderator

Re: spfile recovery [message #347796 is a reply to message #347795]

Sun, 14 September 2008 00:43

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

oracle 10g,

os- solaris

Report message to a moderator

Re: spfile recovery [message #347797 is a reply to message #347796]

Sun, 14 September 2008 00:45

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

4 decimals

Regards
Michel

Report message to a moderator

Re: spfile recovery [message #347798 is a reply to message #347797]

Sun, 14 September 2008 00:54

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

sorry, i dont get you.

Report message to a moderator

Re: spfile recovery [message #347799 is a reply to message #347798]

Sun, 14 September 2008 01:15

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thanks for the information provided by taj

Report message to a moderator

Re: spfile recovery [message #347827 is a reply to message #347799]

Sun, 14 September 2008 06:26

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I amaze that with 175 posts you don't know:
* you have to ALWAYS post your version, and with 4 decimals
* how to search:
question: how to restore spfile with rman
answer: restore spfile
Just opening backup and recovery book will give you the answer.

How do you qualify your skills?

Regards
Michel

[Updated on: Sun, 14 September 2008 10:51]

Report message to a moderator

Re: spfile recovery [message #347847 is a reply to message #320937]

Sun, 14 September 2008 09:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How(sic) do you qualify your skills?
I have 20 years of experience; 1 years of bad experience repeated 20 times.

Report message to a moderator

Previous Topic:	Regarding RMAN catalog database with different OS user.
Next Topic:	ORA-19513: failed to identify sequential file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 13:00:48 CST 2024