Re: How do I know which one is used to startup database by DBA if many spfile and pfile coexist?
From: rgvguplb <rgvguplb_at_gmail.com>
Date: Sun, 13 Apr 2008 21:07:46 -0700 (PDT)
Message-ID: <06956f84-a103-46d0-8b96-f571d8adffd7@w1g2000prd.googlegroups.com>
Date: Sun, 13 Apr 2008 21:07:46 -0700 (PDT)
Message-ID: <06956f84-a103-46d0-8b96-f571d8adffd7@w1g2000prd.googlegroups.com>
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. Received on Sun Apr 13 2008 - 23:07:46 CDT