Re: Help:RAC and single instance standby database

First of all, I am saying RAC, which means 9i, actually, I am using 9.2 on linux.

Oracle documents did not say anything about switchover back and forth between two instance RAC and one instance standby, aparently there is some issue with the online redo log file, I do not know where here is any people who have some experience with it.

Thanks for sharing it with me if you have.

"Pete's" <empete2000_at_yahoo.com> wrote in message news:6724a51f.0212271354.4b1b24b2_at_posting.google.com...
> "cs charlie" <cfs3526(no_spam)@hotmail.com> wrote in message
news:<07_O9.302$ac.111_at_nwrddc01.gnilink.net>...
> > I have finish to make a single standby database from RAC using RMAN,
thanks
> > for the help from this group.
> >
> > But at primary site, after I shut down the 2nd instance, I issued
> > SQL>alter database commit to switchover to standby;
> > ERROR at line1:
> > ORA16014: log 4 sequence 17 not archived, no availabel destinations
> > ORA-00312 online log thread 2: '/dev/raw/ora_redo04'
> >
> > Aparantly it is because instance 2 was shutdown, oracle does not know
where
> > to archive the logfile belonging to thread2.
> >
> > I was trying to drop the logfile,
> > SQL> alter database drop logfile group 4
> > ERROR line 1:
> > ORA 01623: log 4 is curren t log for thread2, can not drop.
> >
> > then I was trying to disable thread 2, and drop the logfile again, I
still
> > got the same error.
> >
> > Could somebody help me?
>
> First, what's your database version and more of the particulars. I'm
> not looking for exact details of your environment, but, it helps to
> know db version and platform.
>
> For the first problem, to do a 'switchover' both databases need to be
> running. However, it is possible to do a failover which means that if
> you ever want to switch back to the primary site, you need to setup
> the primary site with a standby database and do a switchover or
> failover. Check out Oracle's documentation on Dataguard, specifically
> on switchover and failover. It walks you through on how to do both.
>
> Your second problem, how have you setup Dataguard? Is this a
> No-Data-Loss configuration???? If so, when you shutdown your standby
> instance, your primary instance will also stop and would probably not
> allow you to drop the redo log group because the standby needs to be
> available.
>
> HTH,
> Pete's
Received on Fri Dec 27 2002 - 21:59:22 CST