在执行logical standby switchover的时候，出现了

ORA-16217: prepare to switchover has not completed错误.

[@more@]

SQL> alter database prepare to switchover to logical standby;

Database altered.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
PREPARING SWITCHOVER

SQL> alter database commit to switchover to logical standby;
alter database commit to switchover to logical standby
*
ERROR at line 1:
ORA-16217: prepare to switchover has not completed
ORA-06512: at line 1

原来是在standby database中没有设置

log_archive_dest_n='service=asm lgwr sync affirm valid_for=(all_logfiles,all_roles) db_unique_name=asm'导致的，

其中log_archive_dest_state_n等参数设置有误，也会导致这个错误的。

在standby database上

SQL> alter system set log_archive_dest_3='service=asm lgwr sync affirm valid_for=(all_logfiles,all_roles) db_unique_name=asm';

System altered.

然后在pirmary database上

SQL> alter database prepare to switchover to logical standby;

Database altered.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
TO LOGICAL STANDBY

ITPub博客

ORA-16217: prepare to switchover has not completed

最新文章