post switch over in oracle dataguard 11g

[Former Member]

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

[Former Member]

Hi Nikunj,

You can find the scenario, in the "Problem : Data Guard Broker Switchover fails With ORA-16665 using Active Data Guard", on metalink.oracle.com

First of all manually complete the Switchover, ie. restart the Databases in its new Role. Note that the final Role Change has not been recognized by the Broker, so you have to rebuild the Data Guard Broker Configuration when the Databases have been restarted: 

DGMGRL> remove configuration;
DGMGRL> create configuration ...
DGMGRL> add database ...
DGMGRL> enable configuration;

Best regards,

Orkun Gedik

[stefan_koehler]

Hello Nikunj,

well at first please tell us the exactly steps (commands) that you have performed? Are you sure that you have performed a "Switch-Over" and not a "Fail-Over"?

I know these cases in some flashback scenarios.

Regards

Stefan