ORA-16649: possible failover to another database prevents this database from being opened

We have a newly upgraded 19c primary database which was in ODG configuration. We didn’t use the ODG rolling upgrade, but just built the new server and restored/recovered database on it. So the standby was still on old 12c database and we were planning to do it in a week.

The application using the database was also upgraded to a newer version. The first week we had a database outage because of some bad queries which casued the database unresponsive. A decision was made to bounce the database to bring the service backp as soon as possible. It could not be shutdown gracefully with “shutdown immediate”, then “shutdown abort” was used.

After that it would not start with the following error:

ORA-16649: possible failover to another database prevents this database from being opened

Somehow the broker was confused and blocking the startup. The solution was just to turn it off.

ALTER SYSTEM SET dg_broker_start=FALSE SCOPE=BOTH;

After that the database started up. Anyway we will need to recreat the broker configuration after the standby is built.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s