Corrupt SPFILE & no back up - now what?

[danielrc15]

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

The DB will not startup, all I can do is SQLPLUS /NOLOG.

How can I start my DB back up?

Thanks

Daniel

[OracleDoc]

create spfile from pfile;

that is if you still have one around.

[bazza]

Um, at least you know to take regular backups now

I have to admit I fell foul of this when I did some tesing ages back, but at the moment we don't use spfiles in production.

I guess someone may have a bright idea, I'm just wondering if you could recreate it manually using info from the alert log from the last time the database was started up, it should list all the non default parameters.

[stmontgo]

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

[davey23uk]

why on earth would you edit an spfile, open it up and you see loads of junk at the top - isnt that enough to at least think about what you are doing

[simply_dba]

why on earth would you edit an spfile, open it up and you see loads of junk at the top - isnt that enough to at least think about what you are doing

Yes it contains junks but it also coantains relevent parameters and their values (somewhere doen below)
copy--> paste

I'm just wondering if you could recreate it manually using info from the alert log from the last time the database was started up, it should list all the non default parameters.

this also a good idea

the best is, of course , if still have the init.ora...

[danielrc15]

Hi,

Thanks for all your help.

I ended up solving my problem by using another XP machine, installing 10G again with exactly the same folders and set up as my problem machine, I then copied over the SPFILE to the problem machine and it started working again.

Daniel

[davey23uk]

Originally posted by danielrc15
Hi,

Thanks for all your help.

I ended up solving my problem by using another XP machine, installing 10G again with exactly the same folders and set up as my problem machine, I then copied over the SPFILE to the problem machine and it started working again.

Daniel

wow major overkill for such a simple thing

[davey23uk]

Originally posted by simply_dba
Yes it contains junks but it also coantains relevent parameters and their values (somewhere doen below)
copy--> paste


the best is, of course , if still have the init.ora...

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

[abhaysk]

Originally posted by danielrc15
I ended up solving my problem by using another XP machine, installing 10G again with exactly the same folders and set up as my problem machine, I then copied over the SPFILE to the problem machine and it started working again.

Daniel

Absolute stupidity..