How to fix the Oracle error ORA-16218: This database is already preparing to switch over.?

In this post, you’ll learn more about the Oracle ErrorORA-16218: This database is already preparing to switch over. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16218: This database is already preparing to switch over.

Reason for the Error ORA-16218: This database is already preparing to switch over.

The database was already preparing to switch over and was not able to accomodate another prepare attempt.

How to fix the Error ORA-16218: This database is already preparing to switch over. ?

You can fix this error in Oracle by following the below steps

Cancel the current prepare attempt with the ALTER DATABASE PREPARE TO SWITCHOVER CANCEL command, then reissue the prepare request.