How to fix the Oracle error ORA-16816: incorrect database role?

In this post, you’ll learn more about the Oracle ErrorORA-16816: incorrect database role with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16816: incorrect database role

Reason for the Error ORA-16816: incorrect database role

The Data Guard broker detected that the specified database had a different database role than that recorded in the Data Guard broker configuration. This could be the result of a failed switchover or failover operation, or a switchover or failover operation performed with SQL*Plus.

How to fix the Error ORA-16816: incorrect database role ?

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

Check the Data Guard broker documentation to see how to recover from failed role change operations, or from role changes that were performed using SQL*Plus for databases managed by Data Guard broker.