How to fix the Oracle error ORA-16669: instance cannot be opened because the Active Data Guard option is disabled?

In this post, you’ll learn more about the Oracle ErrorORA-16669: instance cannot be opened because the Active Data Guard option is disabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16669: instance cannot be opened because the Active Data Guard option is disabled

Reason for the Error ORA-16669: instance cannot be opened because the Active Data Guard option is disabled

The attempt to open the instance failed because the Active Data Guard option was not enabled and Redo Apply was either running or was about to be started by the Data Guard broker.

How to fix the Error ORA-16669: instance cannot be opened because the Active Data Guard option is disabled ?

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

Stop Redo Apply or set the database state to APPLY-OFF and then open the database.