9i Physical Standby failover
- From: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>
- To: "Oracle-L@Freelists. Org \(E-mail\)" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Oct 2006 14:54:04 -0500
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.