Re: Question on oracle control file

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Fri, 23 Jan 2009 15:09:36 -0800 (PST)
Message-ID: <fa0911c6-b8a6-44ae-9822-3b0f4d5f6cd8_at_b38g2000prf.googlegroups.com>

On Jan 23, 6:09 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Jan 23, 5:23 pm, Totoro <ric..._at_gmail.com> wrote:
>
>
>
> > I have a database with 3 control files on 3 different disk.  They are
> > in location:
>
> > /dbcontrol1
> > /dbcontrol2
> > /dbcontrol3
>
> > As I know, they are mirroring each other.
>
> > Is there any way to disable one of the mirror, let say /dbcontrol2, so
> > that I can change any other bigger hot swap hard drive without
> > shutting down the database?
>
> > It means is there any command to disable one of the control file "on-
> > the-fly"?
>
> > Thanks.
>
> Change your init parameter and/or pfile to reference as many or as few
> of the control files as you wish.  You are going to have to shutdown
> and restart to make this change take.

Sorry spfile ... not pfile. Received on Fri Jan 23 2009 - 17:09:36 CST