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.