Skip to Content
Former Member
Nov 29, 2011 at 11:42 AM

post switch over in oracle dataguard 11g


Dear 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