ORA-16249主库down,logicalstandby直接变主库-mysql教程

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

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

[日期：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>

相关阅读：

ORA-01172、ORA-01151错误处理

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏，，或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法

ORA-17047问题解决

ORA-01403: no data found ，Standby无法apply