Oracle11g dataguard 主库SWITCHOVER_STATUS显示RESOLVABLE GAP
主库在执行alter database commit to switchover to physical standby切换时hang住,后台提示等待备库同步,但是在切换之前测试过归档是可以同步并应用的
SQL> select open_mode,database_role,switchover_status from v$database;
OPEN_MODE            DATABASE_ROLE    SWITCHOVER_STATUS
——————– —————- ——————–
READ WRITE           PRIMARY          RESOLVABLE GAP
正常应该是to standby 或者session active 而这里显示RESOLVABLE GAP,从字面理解是主备库之间存在GAP:
oracle关于它解释是
RESOLVABLE GAP – On a primary database, this status indicates that one or more standby databases have a redo gap that can be automatically resolved by fetching the missing redo from the primary database or from another standby database.
根据提示找到这条命令
SQL> ALTER SYSTEM FLUSH REDO TO ora11g;
这里ora11g是备库的db_unique_name,我这里是orcl此命令需要在mount状态执行 alter system flush redo to ‘orcl_std’;注意还有单引号,这里还有一个问题,主备库的db_unique_name必须不同,否则这里还会抱错.解决这个之后主备顺利切换

 

共有 0 条评论

Top