Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?

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.

jg

--
@home.com is bogus.
"Try to look unimportant; they may be low on ammo." - Infantry
Journal