On Tue, 27 Jan 2004 16:16:37 +0100, Peter Sylvester wrote
(in message <bv5vcl$380$1_at_newslocal.mitre.org>):
> I had something similar happen on a Solaris box after there was a crash
> or power outage, and the spfile evidently got corrupted. Replacing with
> a good old fashion init.ora fixed it (and no more spfiles for me!).
>
> --Peter
>
> Forte Agent wrote:
>> One of my database is refusing to be started on Windows 2000,
>> complaining a parameter value in SP file is invalid. I tried to
>> modify the parameter value using "alter system set xxxx=xxxx
>> scope=spfile", but of course, it refuses to update it saying database
>> is not up. So basically, I am stuck. What should I do to change this
>> value in SPFILE so that I can open it? Thank you in advance.
>>
>>
>
How about just backing the spfiles up ? Can be included in rman backup, can
also create pfile from spfile. I see no reason to not use spfiles.
--
With kind regards,
Ronald
http://ronr.nl/unix-dba
Received on Tue Jan 27 2004 - 13:39:59 CST
