ORA-16456: switchover to standby in progress or completed ORACLE 报错 故障修复 远程处理

文档解释

ORA-16456: switchover to standby in progress or completed

Cause: The requested operation was not allowed because a switchover to standby operation was either in progress or had completed.

Action: Issue the SHUTDOWN ABORT command on the database after switchover operation completes.

ORA-16456是一个可以被忽略的错误，由Oracle数据库引擎发出。它仅用于表示主/备数据库开户切换时的进度。

官方解释

常见案例

一般处理方法及步骤

1.先确认复制情况，并查看相关日志，检查复制是否有问题。

2.如果没有异常，那么可以等待切换操作结束后再查看复制进度，确保数据库切换是正确的。

3.在主/备数据库之间的切换已完成后，我们可以尝试禁用和重新启用MRP，来解决ORA-16456错误。