Re: Question on oracle control file
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Fri, 23 Jan 2009 21:02:11 -0600
Message-ID: <5xvel.1958$PE4.1187_at_nlpi061.nbdc.sbc.com>
Totoro 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.
Date: Fri, 23 Jan 2009 21:02:11 -0600
Message-ID: <5xvel.1958$PE4.1187_at_nlpi061.nbdc.sbc.com>
Totoro 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.
The simple answer to your question is NO.
If the control file is the only thing on that disk, when you "pull it" Oracle will flag it as missing in the alert log. You will only be able to recover it after you shutdown your database.
Assuming 10gR2 because you did not specify a version... See: http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/control.htm#i1006456
If you were using 10g+ASM you could potentially not have this problem. Received on Fri Jan 23 2009 - 21:02:11 CST