Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?
Date: Mon, 14 Apr 2008 15:33:38 -0700 (PDT)
On Apr 14, 1:45 am, Woody Ling <woodyl..._at_gmail.com> wrote:
> On Apr 14, 4:35 pm, blueprinc..._at_gmail.com wrote:
> > On Apr 14, 12:07 pm, rgvguplb <rgvgu..._at_gmail.com> wrote:
> > > On Apr 13, 8:50 pm, Woody Ling <woodyl..._at_gmail.com> wrote:
> > > > I find that many spfile and pfile coexist in one system. How do I know
> > > > which one is used by the DBA to startup the database?
> > > > If the database is started, I can type "show parameter spfile" to
> > > > check the location of spfile. But it show nothing if pfile is used.
> > > > Besides, any way or log files to check which one is used last time if
> > > > database is down?
> > > > Thanks.
> > > > Woody Ling
> > > > Hong Kong
> > > you MAY be able to get a clue from the alert log as well, but not too
> > > sure.
> > You can't get the answer what you want.The best way is to delete
> > unused pfile and spfile on the database.- Hide quoted text -
> > - Show quoted text -
> Yes, but first of all I need to know which pfile is in used.
> Are there any entries in the trace log file indicate which pfile was
> just used to startup the database?
Well, you could create one in a place where no one would think it is the real one, and compare to all the others you find. I think this is why there are so many floating about.
-- @home.com is bogus. "Try to look unimportant; they may be low on ammo." - Infantry JournalReceived on Mon Apr 14 2008 - 17:33:38 CDT