Re: Data Guard 10g: RAC switchover to single instance

On Oct 24, 10:11 pm, vick <gmerv..._at_gmail.com> wrote:
> On Oct 24, 5:03 pm, "Pete's" <empete2..._at_yahoo.com> wrote:
>
>
>
> > On Oct 24, 2:30 pm, vick <gmerv..._at_gmail.com> wrote:
>
> > > Hi,
> > > I have a 2-node primary RAC and a single physical standby instance.
>
> > > If I perform a switchover, I would like to know what's the new
> > > configuration will be:
>
> > > 1) single primary instance and single standby instance
>
> > > or
>
> > > 2) single primary instance and 2-node standby instance
>
> > > I think it (2) but I'm not sure.
>
> > > Thanks.
>
> > To perform the switchover, you need to shutdown and disable one of the
> > RAC primary's.  Then perform the switchover to the physical standby.
> > After the switchover, I have only left one of the former primary RAC
> > instances running.
>
> > HTH,
> > Pete's
>
> Thanks for your response.
> When you said "shutdown and disable one of the RAC primary's", do you
> mean
> 1) shutdown the instance followed by
> 2) disable the instance and then
> 3) shutdown the server?
>
> Are the following the correct steps when I'm switching back to the 2-
> node primary RAC?
> 1) Leaving one of the RAC nodes down, perform the switchover
> 2) startup the server
> 3) enable the instance
> 4) startup the instance
>
> Thanks again.

Shutdown the instance then disable the instance, you do not need to shutdown the server. For switching back to the RAC cluster, leave only one RAC instance running. Perform the switch back, once complete, enable the remaining RAC instance and start it.

BTW, there is a document on technet.oracle.com detailing this procedure, in fact, it's detailed for Physical & Logical Standy's. Look for MAA(Maximum Availability Architecture, I think) white papers.

HTH,
Pete's Received on Sun Oct 26 2008 - 20:15:01 CDT