From oracle-l-bounce@freelists.org Mon Sep 5 08:26:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j85DQJu3030969 for ; Mon, 5 Sep 2005 08:26:19 -0500 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 j85DQIIP030959 for ; Mon, 5 Sep 2005 08:26:18 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA48F1E8D10; Mon, 5 Sep 2005 08:26:15 -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 09992-02; Mon, 5 Sep 2005 08:26:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4FFB61E8A71; Mon, 5 Sep 2005 08:26:15 -0500 (EST) Subject: Re: Physical Standby Switchover issue From: Carel-Jan Engel To: dba.orcl@gmail.com Cc: oracle-l In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-F6x1r1jmo2p27PoYx6Aj" Organization: DBA!ert Date: Mon, 05 Sep 2005 15:34:35 +0200 Message-Id: <1125927275.8014.83.camel@dbalert199.dbalert.nl> Mime-Version: 1.0 X-archive-position: 25007 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: cjpengel.dbalert@xs4all.nl 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: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.3 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 --=-F6x1r1jmo2p27PoYx6Aj Content-Type: text/plain Content-Transfer-Encoding: 7bit Sami I guess this is still the RAC HA sandbox system you're using for your POC? Did you shutdown all but one instance at both ends? During switchover only one instance per database is allowed to run. Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === On Sun, 2005-09-04 at 14:47 -0400, Sami Seerangan wrote: > While doing switchover in physical standby database which is operating > in Maximum Availability mode, I got into this error. > I do have standby logfiles. > > SQL> select switchover_status from v$database; > > SWITCHOVER_STATUS > ------------------ > SESSIONS ACTIVE > > > SQL> alter database commit to switchover to primary with session > shutdown; > alter database commit to switchover to primary with session shutdown > * > ERROR at line 1: > ORA-16139: media recovery required > > > SQL> recover standby database; > ORA-00279: change 318016 generated at 09/04/2005 13:57:41 needed for > thread 1 > ORA-00289: suggestion : /u07/oradata/dgtest/0001S0000000056.ARC > ORA-00280: change 318016 for thread 1 is in sequence #56 > > > Specify log: {=suggested | filename | AUTO | CANCEL} > AUTO > ORA-00279: change 318016 generated at 09/03/2005 21:06:49 needed for > thread 2 > ORA-00289: suggestion : /u07/oradata/dgtest/0002S0000000009.ARC > ORA-00280: change 318016 for thread 2 is in sequence #9 > > > ORA-00328: archived log ends at change 317689, need later change > 318016 > ORA-00334: archived log: '/u07/oradata/dgtest/0002S0000000009.ARC' > > Thanks > Sami > --=-F6x1r1jmo2p27PoYx6Aj Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Sami

I guess this is still the RAC HA sandbox system you're using for your POC?

Did you shutdown all but one instance at both ends? During switchover only one instance per database is allowed to run.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===

On Sun, 2005-09-04 at 14:47 -0400, Sami Seerangan wrote:
While doing switchover in physical standby database which is operating in Maximum Availability mode, I got into this error.
I do have standby logfiles.

SQL> select switchover_status from v$database;
 
SWITCHOVER_STATUS
------------------
SESSIONS ACTIVE
 
 
SQL> alter database commit to switchover to primary with session shutdown;
alter database commit to switchover to primary with session shutdown
*
ERROR at line 1:
ORA-16139: media recovery required
 
 
SQL> recover standby database;
ORA-00279: change 318016 generated at 09/04/2005 13:57:41 needed for thread 1
ORA-00289: suggestion : /u07/oradata/dgtest/0001S0000000056.ARC
ORA-00280: change 318016 for thread 1 is in sequence #56
 
 
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00279: change 318016 generated at 09/03/2005 21:06:49 needed for thread 2
ORA-00289: suggestion : /u07/oradata/dgtest/0002S0000000009.ARC
ORA-00280: change 318016 for thread 2 is in sequence #9
 
 
ORA-00328: archived log ends at change 317689, need later change 318016
ORA-00334: archived log: '/u07/oradata/dgtest/0002S0000000009.ARC'

Thanks
Sami
 


--=-F6x1r1jmo2p27PoYx6Aj-- -- http://www.freelists.org/webpage/oracle-l