Re: Question on oracle control file

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Fri, 23 Jan 2009 15:09:04 -0800 (PST)
Message-ID: <075cb708-4776-46d9-8451-bd9157becc54_at_i20g2000prf.googlegroups.com>

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. Received on Fri Jan 23 2009 - 17:09:04 CST