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