ORA-16249 主库down ,logical standby 直接变主库

程序员文章站 2022-05-16 23:40:22

...

[日期：2013-12-08] 来源：Linux社区作者：Linux [字体：]

ORA-16249 主库down ,logical standby 直接变主库

SQL> alter database activate logical standby database finish apply;
alter database activate logical standby database finish apply
*
ERROR at line 1:
ORA-16249: Terminal apply failed to complete during failover

SQL> alter database activate logical standby database;

Database altered.

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE

SQL> select database_role from v$database;

DATABASE_ROLE
----------------
PRIMARY

SQL>