In this post, you’ll learn more about the Oracle ErrorORA-16217: prepare to switchover has not completed with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-16217: prepare to switchover has not completed
Reason for the Error ORA-16217: prepare to switchover has not completed
An ALTER DATABASE PREPARE TO SWITCHOVER command was issued, but the prepare activity did not complete.
How to fix the Error ORA-16217: prepare to switchover has not completed ?
You can fix this error in Oracle by following the below steps
Verify that the standby was prepared properly. You may cancel the prepare and perform an unprepared switchover which requires a database link to complete. Or reissue the prepare operation on the standby.