文档解释
ORA-16217: prepare to switchover has not completed
Cause: An ALTER DATABASE PREPARE TO SWITCHOVER command was issued, but the prepare activity did not complete.
Action: Verify that the standby was prepared properly. You may cancel the prepare and perform an unprepared switchover which requires a database link to complete. Or reissue the prepare operation on the standby.
。
这是一个 Oracle 数据库的一个常见错误码。
官方解释
常见案例
一般处理方法及步骤
步骤如下:
1)检查是否有 Standby 数据库可用,以便在下一步中将其配置为 Primary;
2)连接到数据库,使用下面的语句切换到连接模式:
alter database commit to switchover to primary;
3)如果 Switchover 成功,重新配置 Data Guard 管理体系结构,并将 Standby 数据库配置为 Primary,否则执行下一步操作;
4)使用下面的语句将数据库强制切换到连接模式(建议仅在 数据库可操作性高优先级 时使用):
alter database commit to switchover to primary with session shutdown;
5)重新启动数据库,再次尝试 switchover。