Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

switchover_status "FAILED DESTINATION" on both primary-standby databases

mkwokOct 10 2011 — edited Oct 11 2011
Hi,

I setup primary-standby databases and try to test the switchover functionality between them using the following commands:

alter database commit to switchover to primary with session shutdown;
alter database commit to switchover to physical standby with session shutdown;

Currently, both DBs are showing

open_mode= READ WRITE for "select open_mode_from v$database;" and
switchover_status = FAILED DESTINATION for "select switchover_status from v$database"

When both databases get into these states, how can I return them back to primary and standby roles? Could you please provide me a sequence of steps that I can execute to return them back to normal primary-standby states?

Thanks in advance for your suggestion.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2011
Added on Oct 10 2011
4 comments
16,796 views