Corrupt SPFILE & no back up - now what?

[OracleDoc]

Originally posted by abhaysk
Absolute stupidity..

And you wonder why companies don't do a more through check on the people whom they trust to run the heart beat of the company.

You know, I really don't know if having people who know nothing about Oracle database administration being in such a position is good for us (the people who know wtf they're doing). If it will hurt us in the long run or benifit us (at least financially)?

[jovery]

I think some of you are being a bit over critical, the poster does'nt claim to be an expert or running this on behalf of a company so why the attack. Sure thier way of solving the problem was not perfect but "absolute stupidity" I think not!

Remeber all of us have to start somewhere and all of us at some time have overworked a solution.

And to be fair it is running on Windoz where basically the answer to most problems is to reinstall

[simply_dba]

I know whats in it, my point was why anyone would go editting it when it clearly looks like it shouldnt be edited

It was not the question of editing the spfile .Rather copying parameters from it and creating a new pfile since the spfile was not working

[davey23uk]

Originally posted by danielrc15
I am running 10G on Windows XP, I edited my SPFILE by mistake, and now I believe it is corrupt.

Daniel

he edited it, he wasnt copying contents from it - he was editing it, which is stupidity as it clearly shouldnt be edited

Read what is written next time

[bazza]

Originally posted by davey23uk
he edited it, he wasnt copying contents from it - he was editing it, which is stupidity as it clearly shouldnt be edited

Read what is written next time

I may be way off the mark here (its been a while since I played with SPfiles) but isn't it possible to corrupt them if you alter a parameter online and do a typo on the parameter value whilst doing it?

Apologies in advance if I'm talking crap.

[davey23uk]

Originally posted by bazza
I may be way off the mark here (its been a while since I played with SPfiles) but isn't it possible to corrupt them if you alter a parameter online and do a typo on the parameter value whilst doing it?

Apologies in advance if I'm talking crap.

Think here we are talking about editing the actual file, perfectly possible to corrupt it then

No, not possible to corrupt it using alter system = ... as any invalid parameter wont be written to the file.

although you can make it so your instance doesnt start that way - but the file itself is still valid

[bazza]

Originally posted by davey23uk
Think here we are talking about editing the actual file, perfectly possible to corrupt it then

No, not possible to corrupt it using alter system = ... as any invalid parameter wont be written to the file.

although you can make it so your instance doesnt start that way - but the file itself is still valid

Right fair enough, I was a tad hazy on that. Better rtfm if I ever use a SPFILE

[simply_dba]

Originally posted by stmontgo
open it with wordpad and create pfile from it's contents to get you back in business

he edited it, he wasnt copying contents from it - he was editing it, which is stupidity as it clearly shouldnt be edited
Read what is written next time

He edited it alright.
It was stupidity alright.
But he has already done it and the talk was going on how to create pfile from a busted spfile.

You should read the posts and not only the mesgs

[davey23uk]

Originally posted by simply_dba
He edited it alright.
It was stupidity alright.
But he has already done it and the talk was going on how to create pfile from a busted spfile.

You should read the posts and not only the mesgs

YOU replied to MY posts about him being stupid - which were nothing to do about recovering the file, therefore you were questioning what I had said

[simply_dba]

YOU replied to MY posts about him being stupid - which were nothing to do about recovering the file, therefore you were questioning what I had said

No I wasn't .I just gave an idea to recreate the pfile from the spfile.Does that make u angry?