dbdao吧 关注:1,183贴子:4,074
  • 4回复贴,共1

DG切换保护模式的疑问

只看楼主收藏回复

我用sql切换dg保护模式,主备查询保护模式都没问题:
SQL> alter database set standby database to maximize availability;
Database altered.
SQL> select name,open_mode,protection_mode from v$database;
NAME OPEN_MODE PROTECTION_MODE
--------- -------------------- --------------------
WYZC READ WRITE MAXIMUM AVAILABILITY
但用dgbroker查缺有这样的错误:
DGMGRL> show configuration;
Configuration - dgwyzc
Protection Mode: MaxPerformance
Databases:
wyzc - Primary database
Error: ORA-16628: broker protection mode inconsistent with the database setting
swyzc - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
这是什么原因呢?


1楼2015-10-09 14:59回复
    然后,我再切回最大性能模式
    SQL> alter database set standby database to maximize performance;
    Database altered.
    再次用dgmgrl查看就又恢复正常了,为什么我用sql语句更改保护模式,在dgmgrl中查询会报上面的错误,而我用dgmgrl更改一切都正常?
    DGMGRL> show configuration;
    Configuration - dgwyzc
    Protection Mode: MaxPerformance
    Databases:
    wyzc - Primary database
    swyzc - Physical standby database
    Fast-Start Failover: DISABLED
    Configuration Status:
    SUCCESS


    2楼2015-10-09 15:32
    回复
      2026-01-08 03:59:23
      广告
      不感兴趣
      开通SVIP免广告
      Versions 9.2
      Error: ORA-16628 The Broker protection mode is inconsistent with the database setting
      ---------------------------------------------------------------------------
      Cause: The Data Guard Broker protection mode saved in metadata is
      inconsistent with the actual database setting.
      Action: Reset the protection mode through the Data Guard Broker.
      若你已经使用broker ,那么需要在dgmgrl中设置保护模式,例如
      DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
      Succeeded.


      3楼2015-10-09 20:27
      收起回复