Hello,
I have a primary and physical standby setup in 11.2.0.4, with pcvi_1 as primary and pcvi_2 as standby
The status before an attempted switchover (using sql commands) was fine, with logs generated at primary, transported to standby and applied.
I attempted a manual switchover today following the instructions on http://docs.oracle.com/cd/E11882_01/server.112/e41134/role_management.htm#SBYDB00620
All the steps executed without errors , but after that the situation is
On pcvi_1
=======
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PHYSICAL STANDBY
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE
and on pcvi_2
========
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PRIMARY
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
NOT ALLOWED
On dgmgrl, the situation has not changed. pcvi_1 is considered primary and pcvi_2 as standby.
DGMGRL> show configuration
Configuration - pcvi
Protection Mode: MaxPerformance
Databases:
pcvi_1 - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database
pcvi_2 - Physical standby database
Error: ORA-16810: multiple errors or warnings detected for the database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
Can somebody please help me solve this issue ?
Many THanks,