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.
Other related posts:
