RE: 9i Physical Standby failover

From: Roger Xu <Roger.Xu_at_dp7upbg.com>
Date: Mon, 9 Oct 2006 15:47:22 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F70C8D4361@irv2kexch01.tx.bg.corp>

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_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.

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:47:22 CDT