Home » RDBMS Server » Backup & Recovery » spfile recovery
spfile recovery [message #320937] Fri, 16 May 2008 15:44 Go to next message
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
Re: spfile recovery [message #320939 is a reply to message #320937] Fri, 16 May 2008 15:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a init.ora from alert.log and then create a spfile from this init.ora

Regards
Michel
Re: spfile recovery [message #320940 is a reply to message #320937] Fri, 16 May 2008 15:48 Go to previous messageGo to next message
BlackSwan
Messages: 25041
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!
Re: spfile recovery [message #321068 is a reply to message #320940] Sun, 18 May 2008 22:33 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks for the reply.
Re: spfile recovery [message #347791 is a reply to message #321068] Sun, 14 September 2008 00:25 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

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

Regards,
Re: spfile recovery [message #347794 is a reply to message #347791] Sun, 14 September 2008 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version?

Regards
Michel
Re: spfile recovery [message #347795 is a reply to message #347791] Sun, 14 September 2008 00:40 Go to previous messageGo to next message
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';"

Re: spfile recovery [message #347796 is a reply to message #347795] Sun, 14 September 2008 00:43 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

oracle 10g,

os- solaris
Re: spfile recovery [message #347797 is a reply to message #347796] Sun, 14 September 2008 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
4 decimals

Regards
Michel
Re: spfile recovery [message #347798 is a reply to message #347797] Sun, 14 September 2008 00:54 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

sorry, i dont get you.
Re: spfile recovery [message #347799 is a reply to message #347798] Sun, 14 September 2008 01:15 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks for the information provided by taj
Re: spfile recovery [message #347827 is a reply to message #347799] Sun, 14 September 2008 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
BlackSwan
Messages: 25041
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.
Previous Topic: Regarding RMAN catalog database with different OS user.
Next Topic: ORA-19513: failed to identify sequential file
Goto Forum:
  


Current Time: Tue Dec 06 12:15:41 CST 2016

Total time taken to generate the page: 0.22560 seconds