文档解释
ORA-16257: Switchover initiated stop apply successfully completed
Cause: SQL Apply was stopped because of a switchover.
Action: No action necessary, this informational statement is provided to record the event for diagnostic purposes.
。
ORA-16257 是一个成功完成的消息,它指的是在数据库环境中完成了切换(switchover)操作,并且stop apply步骤也已经完成。
一般处理方法及步骤
一般情况下,在执行switchover时,通常需要执行的步骤为:
(1)通过ALTER SYSTEM SWITCHOVER TO PRIMARY 命令将目标库变为主库;
(2)执行ALTER SYSTEM SWITCHOVER TO PAYMENT_ LIFE_CYCLE 命令,使目标库从主库切换为从库;
(3)执行ALTER SYSTEM SWITCHOVER TO STOP APPLY 命令,停止apply进程;
(4)在必要的情况下,执行ALTER SYSTEM DISCONNECT SESSION 命令,断开进程及其相关连接;
(5)执行ALTER SYSTEM SWITCHOVER TO START APPLY 命令,重新启动apply进程。
如果执行这些步骤后,发现数据库没有报错,并且弹出ORA-16257:Switchover initiated stop apply successfully completed 的消息,则表明switchover操作已经成功完成,apply进程也已经被成功关闭,条件就符合你需求的情况了。