post switch over in oracle dataguard 11g
11567Nov 29 2011 — edited Nov 30 2011Dear Guru,
Switch over has been completed successfully from primary database to standby database.
new primaray database is open and accessible but its showing his satus in v$database as below.
database_role = primary
switchover_status = not allowed
db_unique_name = dg1_stdby
old primaray database which is now standby showing his satus in v$database as below.
database_role = physical standby
switchover_status = session active
db_unique_name = dg1_primy
when check status in data guard broker its
for both the databases - dg1_primy and dg1_stdby its showing error ORA-16810: multiple errors or warnings detected for the database.
when checked dataguard log file on new primary server its showing
ORA-16816: incorrect database role
ORA-16700: the standby database has diverged from the primary database
Please guide me how to resolved issue.
Thanks & Regards,
Nikunj Thaker