9i Physical Standby failover

From: Roger Xu <Roger.Xu_at_dp7upbg.com>
Date: Mon, 9 Oct 2006 14:54:04 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F70AAF283F@irv2kexch01.tx.bg.corp>

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 - 14:54:04 CDT