From oracle-l-bounce@freelists.org Wed Dec 7 08:48:38 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jB7Emc0A000734 for ; Wed, 7 Dec 2005 08:48:38 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jB7EmaAX000727 for ; Wed, 7 Dec 2005 08:48:36 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4950224B872; Wed, 7 Dec 2005 09:48:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30391-10; Wed, 7 Dec 2005 09:48:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AC4AE24AABD; Wed, 7 Dec 2005 09:48:30 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Dec 2005 09:48:30 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6F72924B1BC for ; Wed, 7 Dec 2005 09:48:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30391-09 for ; Wed, 7 Dec 2005 09:48:30 -0500 (EST) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.200]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2372924C088 for ; Wed, 7 Dec 2005 09:48:30 -0500 (EST) Received: by zproxy.gmail.com with SMTP id k1so370144nzf for ; Wed, 07 Dec 2005 06:48:29 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=M6V5K0FC8CH5Z9nqC/y6pc5iHIdXgGug3+OnWxoytn1kpKi6xSdhooKjnXbvRSIMz5ibcXb29lvfwXC13BgPIzaFrDYHQdvwH75e2YG9HgGkJdTSo83M6Qu9y7Vmezp5PXkMZ3ZcLWBNVjiz6czxsQNE7V44MGUvSojTm+e4nLc= Received: by 10.65.59.4 with SMTP id m4mr1806253qbk; Wed, 07 Dec 2005 06:48:29 -0800 (PST) Received: by 10.65.148.4 with HTTP; Wed, 7 Dec 2005 06:48:29 -0800 (PST) Message-ID: <4b3687720512070648v7a26d43dpde346f253c8479e7@mail.gmail.com> Date: Wed, 7 Dec 2005 09:48:29 -0500 From: Luc Demanche To: Paul Drake Subject: Re: Oracle 9.2 Standard Edition - Standby switchover issues Cc: oracle-l@freelists.org In-Reply-To: <910046b40512070643j382c861dk990807461db35824@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9255_26611993.1133966909657" References: <4b3687720512070623s6a8726a5i2c4652ac5861dac7@mail.gmail.com> <910046b40512070643j382c861dk990807461db35824@mail.gmail.com> X-archive-position: 28978 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lucdemanche@gmail.com Precedence: normal Reply-To: lucdemanche@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org ------=_Part_9255_26611993.1133966909657 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Paul, By doing "alter database activate standby database;", Oracle does a resetlogs. It means that I have to recreate a fresh standby database. There is no Graceful switch ? I found docs for Oracle8.1.7, create new controlfile file, send redo log files, ... My question is : With Oracle 9.2, Standard Edition, we managing the standby database the sam= e way then the standby with Oracle 8.1.7 Thanks Luc On 12/7/05, Paul Drake wrote: > > On 12/7/05, Luc Demanche wrote: > > Hi, > > > > Oracle 9.2.0.6 Standard Edition > > I have issues when I want to switch between my standby and primary > database. > > > > I got this error > > ARCH: Archiving not possible: No standby destinations > > ARCH: Failed to archive log 1 thread 1 sequence 61 > > ORA-16014 signalled during: alter database commit to switchover to > standby > > wi > > > > We are running the Standard Edition so I can't use "log_archive_dest_n > ...." > > > > I copy my archive log file with a script and apply them using "recover > > automatic standby database". > > > > For another system with Enterprise Edition, I'm using these commands > without > > any problems: > > To switch from Primary to Standby > > alter database commit to switchover to physical standby with session > > shutdown; > > shutdown immediate; > > startup nomount; > > alter database mount standby database; > > alter system set log_archive_dest_state_2=3Ddefer scope=3Dboth; > > alter database recover managed standby database disconnect; > > > > To switch from Standby to Primary > > alter database recover managed standby database finish skip standby > logfile; > > alter database commit to switchover to primary; > > shutdown immediate > > startup > > alter system set log_archive_dest_state_2=3Denable scope=3Dboth; > > > > Question: > > What do I need to make it work with the Standard Edition ? > > > > Thanks > > Luc > > -- > > Luc Demanche > > Oracle DBA > > (514) 867-9977 > > Luc, > > > alter database recover managed standby database finish skip standby > logfile; > > alter database commit to switchover to primary; > > Both of these statements are for DataGuard. > > For a user-managed standby database you will want to use the 8.1.7 > behavior, along the lines of: > > SQL> recover standby database; > SQL> alter database activate standby database; > SQL> shutdown immediate > SQL> startup > > ... and you now have a new primary database (back it up :) ) > I don't have my docs on this in front of me at the moment, but I will > in about an hour. > > Paul > -- Luc Demanche Oracle DBA (514) 867-9977 ------=_Part_9255_26611993.1133966909657 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Paul,
 
By doing "alter database activate standby database;", Oracle= does a resetlogs.
It means that I have to recreate a fresh standby database.
 
There is no Graceful switch ?  I found docs for Oracle8.1.7, crea= te new controlfile file, send redo log files, ...
 
My question is : 
With Oracle 9.2, Standard Edition, we managing the standby database&nb= sp;the same way then the standby with Oracle 8.1.7
 
Thanks
Luc

 
On 12/7/05, = Paul Drake <bdbafh@gmail.com= > wrote:
On 12/7/05, Luc Demanche <lucdemanche@gmail.com> wrote:<= br> > Hi,
>
> Oracle 9.2.0.6 Stan= dard Edition
> I have issues when I want to switch between my standby= and primary database.
>
> I got this error
> ARCH: Archi= ving not possible: No standby destinations
> ARCH: Failed to archive log 1 thread 1 sequence 61
> ORA-160= 14 signalled during: alter database commit to switchover to standby
>= wi
>
> We are running the Standard Edition so I can't use &quo= t;log_archive_dest_n ...."
>
> I copy my archive log file with a script and apply them us= ing "recover
> automatic standby database".
>
>= For another system with Enterprise Edition, I'm using these commands witho= ut
> any problems:
> To switch from Primary to Standby
> al= ter database commit to switchover to physical standby with session
> = shutdown;
> shutdown immediate;
> startup nomount;
> alte= r database mount standby database;
> alter system set log_archive_dest_state_2=3Ddefer scope=3Dboth;> alter database recover managed standby database disconnect;
>> To switch from Standby to Primary
> alter database recover man= aged standby database finish skip standby logfile;
> alter database commit to switchover to primary;
> shutdown i= mmediate
> startup
> alter system set log_archive_dest_state_2= =3Denable scope=3Dboth;
>
> Question:
> What do I need to= make it work with the Standard Edition ?
>
> Thanks
> Luc
> --
> Luc Demanche
>= Oracle DBA
> (514) 867-9977

Luc,

> alter database r= ecover managed standby database finish skip standby logfile;
> alter = database commit to switchover to primary;

Both of these statements are for DataGuard.

For a user-manag= ed standby database you will want to use the 8.1.7
behavior, along the l= ines of:

SQL> recover standby database;
SQL> alter database= activate standby database;
SQL> shutdown immediate
SQL> startup

... and you now ha= ve a new primary database (back it up :) )
I don't have my docs on this = in front of me at the moment, but I will
in about an hour.

Paul



--
Luc Demanche
Ora= cle DBA
(514) 867-9977=20 ------=_Part_9255_26611993.1133966909657-- -- http://www.freelists.org/webpage/oracle-l