How to fix the Oracle error ORA-16432: inconsistent set of logs applied at a standby database?

In this post, you’ll learn more about the Oracle ErrorORA-16432: inconsistent set of logs applied at a standby database with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-16432: inconsistent set of logs applied at a standby database

Reason for the Error ORA-16432: inconsistent set of logs applied at a standby database

Redo apply stopped because it detected an inconsistency in the progression of the SCNs. If this database is a bystander standby database, this is most likely due to a failover operation in which incompatible logs were applied from the old and new primary databases.

How to fix the Error ORA-16432: inconsistent set of logs applied at a standby database ?

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

Determine the STANDBY_BECAME_PRIMARY_SCN by selecting it from V$DATABASE on the new primary database. Then, flashback the target database to this SCN and use RMAN to delete all archive logs at or beyond this SCN. Finally, fetch all terminal end of redo (EOR) logs corresponding to the failover operation from the new primary and register all these logs at the target database. Restart redo apply.