-
Switchover_status is not allowed in standby
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|