RE: 9i Physical Standby failover

From: <Ravi_Kulkarni_at_Dell.com>
Date: Mon, 9 Oct 2006 15:34:49 -0500
Message-ID: <DB108C8A1E08EC448BB22A51DC9FAB6201D317C5@ausx3mpc111.aus.amer.dell.com>

Roger,  

Your are trying the graceful (not forced) failover. If the standby is not in sync, try to recover to the latest log and try your steps.    

Thanks,
Ravi.    

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu Sent: Monday, October 09, 2006 2:54 PM
To: Oracle-L_at_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.

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

Received on Mon Oct 09 2006 - 15:34:49 CDT