Data guard Switchover on 10G

[matthew00]

when I tried to switch over to standby DB by issuing the command:

SQL>alter database commit to switchover to physical standby with session shutdown wait;

I got error:


*
ERROR at line 1:
ORA-16416: Switchover target is not synchronized with the primary



The question is how can I ensure or check to be sure both standby and primary are in sync the switch over? If it's not in sync, is there a command for me to run to sync up the two?

Thanks,

[vnktummala]

you can check the switchover status from v$database view.

select switchover_status from v$database will tell you whether switchover is allowed or not.

Thanks,

[matthew00]

I already did, and both of the database (primary/stand by) are both active which I don't understand.

thanks

[vnktummala]

can you post the output of

select switchover_status from v$database from the DB which you are trying to switch over?

Thanks,