Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 16551 invoked from network); 10 Oct 2006 04:11:35 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 10 Oct 2006 04:11:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 94A2B4463C7; Tue, 10 Oct 2006 05:10:58 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20175-05-2; Tue, 10 Oct 2006 05:10:58 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1010E4462A1; Tue, 10 Oct 2006 05:10:58 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 10 Oct 2006 05:10:00 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F0115446190 for ; Tue, 10 Oct 2006 05:09:59 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19840-02 for ; Tue, 10 Oct 2006 05:09:59 -0400 (EDT) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DB9DA446308 for ; Tue, 10 Oct 2006 05:09:58 -0400 (EDT) Received: by nf-out-0910.google.com with SMTP id p77so232858nfc for ; Tue, 10 Oct 2006 02:10:32 -0700 (PDT) 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=kEdHplKBQBsZ6wMC3PvqGl9WFLZJArBfE9SKYNDoFhhcTykyreGkS+N29SON76kePjdkLcRETHbu8fodbmEfUbPbq5PUkLFvLLH7ChX/NfIPJuIrv5E+FQMFzLNL/84eDWkslzjPpAu9Xzn82QCGKiHCbLGIj+jU5++hJ4AoaZg= Received: by 10.49.80.12 with SMTP id h12mr1100536nfl; Tue, 10 Oct 2006 02:10:32 -0700 (PDT) Received: by 10.49.51.1 with HTTP; Tue, 10 Oct 2006 02:10:32 -0700 (PDT) Message-ID: <4415a5ed0610100210u28498e42pb56f0c8cb09aab2c@mail.gmail.com> Date: Tue, 10 Oct 2006 17:10:32 +0800 From: "eagle fan" To: Roger.Xu@dp7upbg.com Subject: Re: 9i Physical Standby failover Cc: "Oracle-L@Freelists. Org (E-mail)" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6309_5727205.1160471432065" References: X-archive-position: 40535 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: eagle.f@gmail.com Precedence: normal Reply-to: eagle.f@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------=_Part_6309_5727205.1160471432065 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline hi: If you active standby database, you need to build a new standby database for the new activated primary database. I think it's not your original purpose. You planned to do swithover but at last you did activate standby. They are different things. On 10/10/06, Roger Xu wrote: > > It's working now - thank you all - Roger > > SQL> *alter database mount standby database;* > > Database altered. > > SQL> *ALTER DATABASE ACTIVATE STANDBY DATABASE;* > > Database altered. > > SQL> select status from v$instance; > > STATUS > ------------ > STARTED > > SQL> *alter database mount;* > > Database altered. > > SQL> *alter database open;* > > Database altered. > > SQL> select status from v$instance; > > STATUS > ------------ > OPEN > > SQL> > > -----Original Message----- > *From:* oracle-l-bounce@freelists.org [mailto: > oracle-l-bounce@freelists.org]*On Behalf Of *Roger Xu > *Sent:* Monday, October 09, 2006 2:54 PM > *To:* Oracle-L@Freelists. Org (E-mail) > *Subject:* 9i Physical Standby failover > > Hi, > > I am testing failover but getting ORA-1666 error. > Am I missing something here? > > Thanks, > > Roger > > > > SQL> *alter database recover managed standby database finish;* > > Database altered. > > SQL> *alter database commit to switchover to primary; > *alter database commit to switchover to primary > * > ERROR at line 1: > ORA-16139: media recovery required > > > SQL> *shutdown immediate; > *ORA-01109: database not open > > > Database dismounted. > ORACLE instance shut down. > SQL> *startup > *ORACLE instance started. > > Total System Global Area 420480856 bytes > Fixed Size 730968 bytes > Variable Size 117440512 bytes > Database Buffers 301989888 bytes > Redo Buffers 319488 bytes > ORA-01666: controlfile is for a standby database > > > SQL> > > > This e-mail is intended solely for the person or entity to which it is > addressed and may contain confidential and/or privileged information. Any > review, dissemination, copying, printing or other use o > ____________________________________________________________________ > This email has been scanned for all viruses by the MessageLabs Email > Security System. > > This e-mail is intended solely for the person or entity to which it is > addressed and may contain confidential and/or privileged information. Any > review, dissemination, copying, printing or other use o > ____________________________________________________________________ > This email has been scanned for all viruses by the MessageLabs Email > Security System. > -- Eagle Fan Oracle DBA ------=_Part_6309_5727205.1160471432065 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline hi:

If you active standby database, you need to build a new standby database for the new activated primary database.

I think it's not your original purpose. You planned to do swithover but at last you did activate standby. They are different things.

On 10/10/06, Roger Xu <Roger.Xu@dp7upbg.com> wrote:
It's working now - thank you all - Roger
 
SQL> alter database mount standby database;
 
Database altered.
 
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
 
Database altered.
 
SQL> select status from v$instance;
 
STATUS
------------
STARTED
 
SQL> alter database mount;
 
Database altered.
 
SQL> alter database open;
 
Database altered.
 
SQL> select status from v$instance;
 
STATUS
------------
OPEN
 
SQL>
-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto: oracle-l-bounce@freelists.org]On Behalf Of Roger Xu
Sent: Monday, October 09, 2006 2:54 PM
To: Oracle-L@Freelists. Org (E-mail)
Subject: 9i Physical Standby failover

Hi,
 
I am testing failover but getting ORA-1666 error.
Am I missing something here?
 
Thanks,
 
Roger
 
 
 
SQL> alter database recover managed standby database finish;
 
Database altered.
 
SQL> alter database commit to switchover to primary;
alter database commit to switchover to primary
*
ERROR at line 1:
ORA-16139: media recovery required
 

SQL> shutdown immediate;
ORA-01109: database not open
 

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
 
Total System Global Area  420480856 bytes
Fixed Size                   730968 bytes
Variable Size             117440512 bytes
Database Buffers          301989888 bytes
Redo Buffers                 319488 bytes
ORA-01666: controlfile is for a standby database
 

SQL>

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security System.

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security System.



--
Eagle Fan

Oracle DBA ------=_Part_6309_5727205.1160471432065-- -- http://www.freelists.org/webpage/oracle-l