数据卫士DG

实验中的问题解决：（ORACLE11g）

SWITCHOVER主库出现LOG SWITCH GAP和RESOLVABLE GAP解决一例

主备库切换时，

主库：

SQL> select open_mode,database_role,switchover_status from v$database;

OPEN_MODE            DATABASE_ROLE    SWITCHOVER_STATUS

-------------------- ---------------- --------------------

READ WRITE           PRIMARY          TO STANDBY

备库：

SQL> select open_mode,database_role,switchover_status from v$database;

OPEN_MODE            DATABASE_ROLE    SWITCHOVER_STATUS

-------------------- ---------------- --------------------

READ ONLY WITH APPLY PHYSICAL STANDBY NOT ALLOWED

主库直接进行swichover：

SQL> alter database commit to switchover to physical standby;

alter database commit to switchover to physical standby

*

ERROR at line 1:

ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

SQL> select open_mode,database_role,switchover_status from v$database;

OPEN_MODE            DATABASE_ROLE    SWITCHOVER_STATUS

-------------------- ---------------- --------------------

READ WRITE           PRIMARY          LOG SWITCH GAP