Re: Help:RAC and single instance standby database

"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 - 15:54:31 CST