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

ORA-16432: inconsistent set of logs applied at a standby database
Cause: 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.
Action: 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:43

ORA-16432：在备用数据库上应用的不一致的日志集,
.原因：重新应用已停止，因为它检测到SCN进度中的不一致。如果此数据库是旁注备用数据库，这很可能是由于故障转移操作，其中从旧的和新的主数据库应用不兼容的日志。,
.操作：通过在新主数据库上从V $ DATABASE中选择STANDBY_BECAME_PRIMARY_SCN来确定该值。然后，将目标数据库闪回到此SCN，并使用RMAN删除此SCN或其以外的所有归档日志。最后，从新的主节点获取与故障转移操作相对应的所有终端重做（EOR）日志，并在目标数据库中注册所有这些日志。重新启动重做应用。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题