RE: 9i Physical Standby failover
- From: <Ravi_Kulkarni@xxxxxxxx>
- To: <Roger.Xu@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Oct 2006 15:34:49 -0500
Roger,
Your are trying the graceful (not forced) failover. If the standby is
not in sync, try to recover to the latest log and try your steps.
Thanks,
Ravi.
________________________________
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.
Other related posts:
