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
Printable View
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
create spfile from pfile;
that is if you still have one around.
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.
open it with wordpad and create pfile from it's contents to get you back in business
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)Quote:
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
copy--> paste
this also a good ideaQuote:
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.
the best is, of course , if still have the init.ora...:cool:
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 thingQuote:
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
I know whats in it, my point was why anyone would go editting it when it clearly looks like it shouldnt be editedQuote:
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...:cool:
Absolute stupidity..Quote:
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