How to fix the Oracle error ORA-16822: new primary database not yet ready for standby database reinstatement?

In this post, you’ll learn more about the Oracle ErrorORA-16822: new primary database not yet ready for standby database reinstatement with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16822: new primary database not yet ready for standby database reinstatement

Reason for the Error ORA-16822: new primary database not yet ready for standby database reinstatement

The new primary database, as a result of a logical standby database failover operation, had not fully completed the failover operation. An attempt to reinstate a disabled standby database could not be completed until failover completed on the new primary database.

How to fix the Error ORA-16822: new primary database not yet ready for standby database reinstatement ?

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

Wait until the failover operation has completed on the new primary database. Then retry the reinstate operation.

Tags :

Leave Your Comment