| Switchover_status is not allowed in standby [message #624320] |
Sun, 21 September 2014 11:03  |
oradba123
Messages: 86
Registered: June 2009
Location: india
|
Member |
|
|
Hi folks,
i have configured standby database for oracle 11g (11.2.0.1.0) on AIX 6.1 .i have not check the switch over or failover , as the primary database is Production
but when i checked
@Primary side:
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
TO STANDBY
SQL> select max(sequence#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
2563
@Standby Side
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
NOT ALLOWED
SQL> select max(sequence#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
2563
but i google about SWITCHOVER_STATUS is NOT ALLOWED but it says
NOT ALLOWED - Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.
i have checked the DR syn is fine ,RFS is working fine , archive are being applied on DR
so please let me know in future if business permits can i switch over and do the testing and switch back to primary with the same setting.
appreciate your prompt response .
Regards.
|
|
|
|
|
|
| Re: Switchover_status is not allowed in standby [message #624336 is a reply to message #624320] |
Mon, 22 September 2014 02:18  |
John Watson
Messages: 8928
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
The current release has the command SWITCHOVER .... VERIFY designed for exactly this situation: to test, safely, whether a switchover would succeed. Perhaps you can use this to motivate the upgrade.
I do not understand why so many sites refuse to upgrade when 12.x has been GA for so long already.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Switchover_status is not allowed in standby [message #624373 is a reply to message #624367] |
Mon, 22 September 2014 06:37 |
 |
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Quote:what about this
urrently, as you are unskilled on the matter, it is just like you have no standby
This just means if you have a tool and don't know how to use it, it is like you have not it. It just means this and nothing more.
And "Haven't you some test databases to exercise yourself on the subject." means improve your skills making your own tests and try different scenario. It is the only way to master the subject.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
