How to fix the Oracle error ORA-16661: the standby database needs to be reinstated?

In this post, you’ll learn more about the Oracle ErrorORA-16661: the standby database needs to be reinstated with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16661: the standby database needs to be reinstated

Reason for the Error ORA-16661: the standby database needs to be reinstated

A role change has caused this database to require reinstatement.

How to fix the Error ORA-16661: the standby database needs to be reinstated ?

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

Use the DGMGRL REINSTATE DATABASE command or Enterprise Manager to reinstate the database. Reinstate the database as soon as possible, because the database will have to be re-created if another role change occurs while it is in this state.