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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of *Roger Xu
*Sent:* Monday, October 09, 2006 2:54 PM
*To:* Oracle-L@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.
