DW集群自动切换

原创已于 2022-06-13 10:13:11 修改 · 421 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dba #数据库 #database

于 2022-05-30 16:05:58 首次发布

达梦数据库专栏收录该内容

20 篇文章

订阅专栏

本文详细介绍了DM集群在主库数据库异常宕机、主库数据库与守护进程同时异常及主机网络异常情况下的自动切换过程，包括配置修改、服务启动和故障模拟。通过监控器日志展示了切换过程中守护进程和实例的状态变化，确保了集群的高可用性。

DM集群系列—DW集群自动切换

文章目录

DM集群系列—DW集群自动切换
二、主备自动切换

请参考上一篇手动切换步骤完成前面配置

二、主备自动切换

2.1、参考1.3配置，主要修改的地方如下

1、修改dmwatcher.ini中的DW_MODE模式
[dmdba@dmp DAMENG]$ vi dmwatcher.ini
 [GDW1]
  DW_TYPE                  = GLOBAL  #全局守护类型
  DW_MODE                  = AUTO  #故障手动切换模式（AUTO自动）
  DW_ERROR_TIME            = 20  #远程守护进程故障认定时间
  INST_ERROR_TIME          = 20  #本地实例故障认定时间
  INST_RECOVER_TIME        = 60  #主库守护进程启动恢复的间隔时间
  INST_OGUID               = 45331  #守护系统唯一OGUID值
  INST_INI                 = /dm8/data/DAMENG/dm.ini  #dm.ini文件路径       
  INST_AUTO_RESTART        = 1  #打开实例的自动启动功能
  INST_STARTUP_CMD         = /dm8/bin/dmserver  #命令行方式启动       
  RLOG_SEND_THRESHOLD      = 0  #指定主库发送日志到备库的时间阈值，默认关闭
  RLOG_APPLY_THRESHOLD     = 0  #指定备库重演日志的时间阈值，默认关闭6

2、创建dmmonitor_auto.ini
[dmdba@~]# vi /dm8/bin/dmmonitor_manual.ini
MON_DW_CONFIRM             = 1  #0为非确认，1为确认
MON_LOG_PATH               = ../log  #监视器日志文件存放路径
MON_LOG_INTERVAL           = 60  #每隔 60s 定时记录系统信息到日志文件
MON_LOG_FILE_SIZE          = 512  #单个日志大小，单位MB
MON_LOG_SPACE_LIMIT        = 2048  #日志上限，单位MB

[GDW1]
  MON_INST_OGUID           = 45331  #组GDW1的唯一OGUID 值
  MON_DW_IP                = 192.168.10.100:5436  #IP对应MAL_HOST，PORT对应MAL_DW_PORT
  MON_DW_IP                = 192.168.10.101:5436

2.2、启动服务

按照5.3.4.3集群的停止和启动顺序进行服务的重启

2.3、模拟故障进行自动切换

2.3.1、主库数据库异常宕机，守护进程正常

--登录数据库进行shutdown abort关库
[dmdba@dmp DAMENG]$ disql SYSDBA/SYSDB
[-2501]:用户名或密码错误.
disql V8
用户名:SYSDBA
密码:

服务器[LOCALHOST:5236]:处于主库打开状态
登录使用时间 : 3.611(ms)
SQL> shutdown abort;
操作已执行
已用时间: 0.569(毫秒). 执行号:0.
SQL> exit

--查看监视器
[monitor]         2022-05-26 14:15:52: 实例DW1_01[PRIMARY, OPEN, ISTAT_SAME:TRUE]故障
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:15:52  STARTUP        ERROR     DW1_01           OPEN        PRIMARY   VALID    7        54012           54013           

[monitor]         2022-05-26 14:15:52: 守护进程(DW1_01)状态切换 [OPEN-->STARTUP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:15:52  STARTUP        ERROR     DW1_01           OPEN        PRIMARY   VALID    7        54012           54013           

[monitor]         2022-05-26 14:15:52: 检测到PRIMARY实例故障，开始对组(GDW1)执行自动接管

[monitor]         2022-05-26 14:15:52: 通知组(GDW1)当前活动的守护进程设置MID
[monitor]         2022-05-26 14:15:52: 通知组(GDW1)当前活动的守护进程设置MID成功
[monitor]         2022-05-26 14:15:52: 开始使用实例DW1_02接管
[monitor]         2022-05-26 14:15:52: 通知守护进程DW1_02切换TAKEOVER状态
[monitor]         2022-05-26 14:15:52: 守护进程(DW1_02)状态切换 [OPEN-->TAKEOVER]
[monitor]         2022-05-26 14:15:53: 切换守护进程DW1_02为TAKEOVER状态成功
[monitor]         2022-05-26 14:15:53: 实例DW1_02开始执行SP_SET_GLOBAL_DW_STATUS(0, 7)语句
[monitor]         2022-05-26 14:15:53: 实例DW1_02执行SP_SET_GLOBAL_DW_STATUS(0, 7)语句成功
[monitor]         2022-05-26 14:15:53: 实例DW1_02开始执行SP_APPLY_KEEP_PKG()语句
[monitor]         2022-05-26 14:15:54: 实例DW1_02执行SP_APPLY_KEEP_PKG()语句成功
[monitor]         2022-05-26 14:15:54: 实例DW1_02开始执行ALTER DATABASE MOUNT语句
[monitor]         2022-05-26 14:15:54: 实例DW1_02执行ALTER DATABASE MOUNT语句成功
[monitor]         2022-05-26 14:15:54: 实例DW1_02开始执行ALTER DATABASE PRIMARY语句
[monitor]         2022-05-26 14:15:54: 实例DW1_02执行ALTER DATABASE PRIMARY语句成功
[monitor]         2022-05-26 14:15:54: 通知实例DW1_02修改所有归档状态无效
[monitor]         2022-05-26 14:15:54: 修改所有实例归档为无效状态成功
[monitor]         2022-05-26 14:15:54: 实例DW1_02开始执行ALTER DATABASE OPEN FORCE语句
[monitor]         2022-05-26 14:15:54: 实例DW1_02执行ALTER DATABASE OPEN FORCE语句成功
[monitor]         2022-05-26 14:15:54: 实例DW1_02开始执行SP_SET_GLOBAL_DW_STATUS(7, 0)语句
[monitor]         2022-05-26 14:15:54: 实例DW1_02执行SP_SET_GLOBAL_DW_STATUS(7, 0)语句成功
[monitor]         2022-05-26 14:15:54: 通知守护进程DW1_02切换OPEN状态
[monitor]         2022-05-26 14:15:54: 守护进程(DW1_02)状态切换 [TAKEOVER-->OPEN]
[monitor]         2022-05-26 14:15:55: 切换守护进程DW1_02为OPEN状态成功
[monitor]         2022-05-26 14:15:55: 通知组(GDW1)的守护进程执行清理操作
[monitor]         2022-05-26 14:15:55: 清理守护进程(DW1_01)请求成功
[monitor]         2022-05-26 14:15:55: 清理守护进程(DW1_02)请求成功
[monitor]         2022-05-26 14:15:55: 使用实例DW1_02接管成功

[monitor]         2022-05-26 14:15:55: 组(GDW1)使用实例DW1_02自动接管成功

show[monitor]         2022-05-26 14:16:13: 实例DW1_01[STANDBY, MOUNT, ISTAT_SAME:TRUE]恢复正常
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:16:13  UNIFY EP       OK        DW1_01           MOUNT       STANDBY   INVALID  7        54012           54012           

[monitor]         2022-05-26 14:16:13: 守护进程(DW1_01)状态切换 [STARTUP-->UNIFY EP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:16:13  UNIFY EP       OK        DW1_01           MOUNT       STANDBY   INVALID  7        54012           54012           

[monitor]         2022-05-26 14:16:13: 守护进程(DW1_01)状态切换 [UNIFY EP-->STARTUP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:16:13  STARTUP        OK        DW1_01           OPEN        STANDBY   INVALID  7        54012           54012           

 p[monitor]         2022-05-26 14:16:13: 守护进程(DW1_01)状态切换 [STARTUP-->OPEN]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:16:13  OPEN           OK        DW1_01           OPEN        STANDBY   INVALID  7        54012           54012           

[monitor]         2022-05-26 14:16:14: 守护进程(DW1_02)状态切换 [OPEN-->RECOVERY]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:16:14  RECOVERY       OK        DW1_02           OPEN        PRIMARY   VALID    8        56464           56464           

[monitor]         2022-05-26 14:16:16: 守护进程(DW1_02)状态切换 [RECOVERY-->OPEN]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:16:16  OPEN           OK        DW1_02           OPEN        PRIMARY   VALID    8        56465           56465           

show global info
2022-05-26 14:17:12 
#================================================================================#
GROUP            OGUID       MON_CONFIRM     MODE            MPP_FLAG  
GDW1             45331       TRUE            AUTO            FALSE     


<<DATABASE GLOBAL INFO:>>
DW_IP               MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.10.101      5436         2022-05-26 14:17:12  GLOBAL    VALID     OPEN           DW1_02           OK        1     1     OPEN        PRIMARY   DSC_OPEN       REALTIME  VALID    

DW_IP               MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.10.100      5436         2022-05-26 14:17:12  GLOBAL    VALID     OPEN           DW1_01           OK        1     1     OPEN        STANDBY   DSC_OPEN       REALTIME  VALID    

#=============================================================================#

2.3.2、主库数据库、守护进程同时异常

--同时停止守护进程和数据库服务进程
[dmdba@dms1 ~]$ DmWatcherServiceWatcher stop && DmServiceDW1_02 stop
Stopping DmWatcherServiceWatcher: [ OK ]
Stopping DmServiceDW1_02: [ OK ]
[dmdba@dms1 ~]$ 

--查看监视器
[monitor]         2022-05-26 14:19:06: 接收守护进程(DW1_02)消息超时
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:18:45  ERROR          OK        DW1_02           OPEN        PRIMARY   VALID    8        56517           56518           

[monitor]         2022-05-26 14:19:06: 检测到PRIMARY实例故障，开始对组(GDW1)执行自动接管

[monitor]         2022-05-26 14:19:06: 通知组(GDW1)当前活动的守护进程设置MID
[monitor]         2022-05-26 14:19:06: 通知组(GDW1)当前活动的守护进程设置MID成功
[monitor]         2022-05-26 14:19:06: 开始使用实例DW1_01接管
[monitor]         2022-05-26 14:19:06: 通知守护进程DW1_01切换TAKEOVER状态
[monitor]         2022-05-26 14:19:06: 守护进程(DW1_01)状态切换 [OPEN-->TAKEOVER]
[monitor]         2022-05-26 14:19:07: 切换守护进程DW1_01为TAKEOVER状态成功
[monitor]         2022-05-26 14:19:07: 实例DW1_01开始执行SP_SET_GLOBAL_DW_STATUS(0, 7)语句
[monitor]         2022-05-26 14:19:07: 实例DW1_01执行SP_SET_GLOBAL_DW_STATUS(0, 7)语句成功
[monitor]         2022-05-26 14:19:07: 实例DW1_01开始执行SP_APPLY_KEEP_PKG()语句
[monitor]         2022-05-26 14:19:07: 实例DW1_01执行SP_APPLY_KEEP_PKG()语句成功
[monitor]         2022-05-26 14:19:07: 实例DW1_01开始执行ALTER DATABASE MOUNT语句
[monitor]         2022-05-26 14:19:07: 实例DW1_01执行ALTER DATABASE MOUNT语句成功
[monitor]         2022-05-26 14:19:07: 实例DW1_01开始执行ALTER DATABASE PRIMARY语句
[monitor]         2022-05-26 14:19:07: 实例DW1_01执行ALTER DATABASE PRIMARY语句成功
[monitor]         2022-05-26 14:19:07: 通知实例DW1_01修改所有归档状态无效
[monitor]         2022-05-26 14:19:07: 修改所有实例归档为无效状态成功
[monitor]         2022-05-26 14:19:07: 实例DW1_01开始执行ALTER DATABASE OPEN FORCE语句
[monitor]         2022-05-26 14:19:07: 实例DW1_01执行ALTER DATABASE OPEN FORCE语句成功
[monitor]         2022-05-26 14:19:07: 实例DW1_01开始执行SP_SET_GLOBAL_DW_STATUS(7, 0)语句
[monitor]         2022-05-26 14:19:08: 实例DW1_01执行SP_SET_GLOBAL_DW_STATUS(7, 0)语句成功
[monitor]         2022-05-26 14:19:08: 通知守护进程DW1_01切换OPEN状态
[monitor]         2022-05-26 14:19:09: 守护进程(DW1_01)状态切换 [TAKEOVER-->OPEN]
[monitor]         2022-05-26 14:19:09: 切换守护进程DW1_01为OPEN状态成功
[monitor]         2022-05-26 14:19:09: 通知组(GDW1)的守护进程执行清理操作
[monitor]         2022-05-26 14:19:09: 清理守护进程(DW1_01)请求成功
[monitor]         2022-05-26 14:19:09: 使用实例DW1_01接管成功

[monitor]         2022-05-26 14:19:09: 组(GDW1)使用实例DW1_01自动接管成功

show global info
2022-05-26 14:19:54 
#================================================================================#
GROUP            OGUID       MON_CONFIRM     MODE            MPP_FLAG  
GDW1             45331       TRUE            AUTO            FALSE     


<<DATABASE GLOBAL INFO:>>
DW_IP               MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.10.100      5436         2022-05-26 14:19:53  GLOBAL    VALID     OPEN           DW1_01           OK        1     1     OPEN        PRIMARY   DSC_OPEN       REALTIME  VALID    


ERROR DATABASE:
DW_IP               MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.10.101      5436         2022-05-26 14:18:45  GLOBAL    VALID     ERROR          DW1_02           OK        1     1     OPEN        PRIMARY   DSC_OPEN       REALTIME  VALID    

--启动守护进程和数据库服务
[dmdba@dms1 ~]$ DmServiceDW1_02 start && DmWatcherServiceWatcher start
Starting DmServiceDW1_02: [ OK ]
Starting DmWatcherServiceWatcher: [ OK ]

#================================================================================#

[monitor]         2022-05-26 14:21:27: 守护进程(DW1_02)状态切换 [NONE-->STARTUP]
[monitor]         2022-05-26 14:21:27: 守护进程(DW1_02)状态切换 [STARTUP-->UNIFY EP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:21:27  UNIFY EP       OK        DW1_02           MOUNT       STANDBY   INVALID  8        56751           56751           

[monitor]         2022-05-26 14:21:28: 守护进程(DW1_02)状态切换 [UNIFY EP-->OPEN]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:21:27  OPEN           OK        DW1_02           OPEN        STANDBY   INVALID  8        56751           56751           

[monitor]         2022-05-26 14:21:28: 守护进程(DW1_01)状态切换 [OPEN-->RECOVERY]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:21:28  RECOVERY       OK        DW1_01           OPEN        PRIMARY   VALID    9        59141           59142           

[monitor]         2022-05-26 14:21:30: 守护进程(DW1_01)状态切换 [RECOVERY-->OPEN]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:21:30  OPEN           OK        DW1_01           OPEN        PRIMARY   VALID    9        59142           59142           

show global info
2022-05-26 14:21:51 
#================================================================================#
GROUP            OGUID       MON_CONFIRM     MODE            MPP_FLAG  
GDW1             45331       TRUE            AUTO            FALSE     


<<DATABASE GLOBAL INFO:>>
DW_IP               MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.10.100      5436         2022-05-26 14:21:51  GLOBAL    VALID     OPEN           DW1_01           OK        1     1     OPEN        PRIMARY   DSC_OPEN       REALTIME  VALID    

DW_IP               MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.10.101      5436         2022-05-26 14:21:51  GLOBAL    VALID     OPEN           DW1_02           OK        1     1     OPEN        STANDBY   DSC_OPEN       REALTIME  VALID

2.3.3、主机网络异常，主备库之间、主库与监视器之间连接异常

--停止虚拟机网卡连接
[root@dmp ~]# service network stop
Stopping network (via systemctl): 【确定】

--查看监视器
[monitor]         2022-05-26 14:24:45: 接收守护进程(DW1_01)消息超时
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:24:24  ERROR          OK        DW1_01           OPEN        PRIMARY   VALID    9        59200           59200           

[monitor]         2022-05-26 14:24:45: 检测到PRIMARY实例故障，开始对组(GDW1)执行自动接管

[monitor]         2022-05-26 14:24:45: 通知组(GDW1)当前活动的守护进程设置MID
[monitor]         2022-05-26 14:24:45: 通知组(GDW1)当前活动的守护进程设置MID成功
[monitor]         2022-05-26 14:24:45: 开始使用实例DW1_02接管
[monitor]         2022-05-26 14:24:45: 通知守护进程DW1_02切换TAKEOVER状态
[monitor]         2022-05-26 14:24:46: 守护进程(DW1_02)状态切换 [OPEN-->TAKEOVER]
[monitor]         2022-05-26 14:24:46: 切换守护进程DW1_02为TAKEOVER状态成功
[monitor]         2022-05-26 14:24:46: 实例DW1_02开始执行SP_SET_GLOBAL_DW_STATUS(0, 7)语句
[monitor]         2022-05-26 14:24:46: 实例DW1_02执行SP_SET_GLOBAL_DW_STATUS(0, 7)语句成功
[monitor]         2022-05-26 14:24:46: 实例DW1_02开始执行SP_APPLY_KEEP_PKG()语句
[monitor]         2022-05-26 14:24:46: 实例DW1_02执行SP_APPLY_KEEP_PKG()语句成功
[monitor]         2022-05-26 14:24:46: 实例DW1_02开始执行ALTER DATABASE MOUNT语句
[monitor]         2022-05-26 14:24:46: 实例DW1_02执行ALTER DATABASE MOUNT语句成功
[monitor]         2022-05-26 14:24:46: 实例DW1_02开始执行ALTER DATABASE PRIMARY语句
[monitor]         2022-05-26 14:24:47: 实例DW1_02执行ALTER DATABASE PRIMARY语句成功
[monitor]         2022-05-26 14:24:47: 通知实例DW1_02修改所有归档状态无效
[monitor]         2022-05-26 14:24:47: 修改所有实例归档为无效状态成功
[monitor]         2022-05-26 14:24:47: 实例DW1_02开始执行ALTER DATABASE OPEN FORCE语句
[monitor]         2022-05-26 14:24:47: 实例DW1_02执行ALTER DATABASE OPEN FORCE语句成功
[monitor]         2022-05-26 14:24:47: 实例DW1_02开始执行SP_SET_GLOBAL_DW_STATUS(7, 0)语句
[monitor]         2022-05-26 14:24:47: 实例DW1_02执行SP_SET_GLOBAL_DW_STATUS(7, 0)语句成功
[monitor]         2022-05-26 14:24:47: 通知守护进程DW1_02切换OPEN状态
[monitor]         2022-05-26 14:24:47: 守护进程(DW1_02)状态切换 [TAKEOVER-->OPEN]
[monitor]         2022-05-26 14:24:48: 切换守护进程DW1_02为OPEN状态成功
[monitor]         2022-05-26 14:24:48: 通知组(GDW1)的守护进程执行清理操作
[monitor]         2022-05-26 14:24:48: 清理守护进程(DW1_02)请求成功
[monitor]         2022-05-26 14:24:48: 使用实例DW1_02接管成功

[monitor]         2022-05-26 14:24:48: 组(GDW1)使用实例DW1_02自动接管成功

--恢复网卡连接
[root@dmp ~]# service network start
Stopping network (via systemctl): 【确定】

--查看监视器
[monitor]         2022-05-26 14:25:09: 守护进程(DW1_01)状态切换 [NONE-->STARTUP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:25:09  STARTUP        OK        DW1_01           SUSPEND     PRIMARY   VALID    9        59200           59206           

[monitor]         2022-05-26 14:25:13: 实例DW1_01[PRIMARY, SUSPEND, ISTAT_SAME:TRUE]故障
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:25:13  STARTUP        ERROR     DW1_01           SUSPEND     PRIMARY   VALID    9        59200           59206           

[monitor]         2022-05-26 14:25:34: 实例DW1_01[STANDBY, MOUNT, ISTAT_SAME:TRUE]恢复正常
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:25:34  STARTUP        OK        DW1_01           MOUNT       STANDBY   INVALID  9        59200           59200           

[monitor]         2022-05-26 14:25:34: 守护进程(DW1_01)状态切换 [STARTUP-->UNIFY EP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:25:34  UNIFY EP       OK        DW1_01           MOUNT       STANDBY   INVALID  9        59200           59200           

[monitor]         2022-05-26 14:25:34: 守护进程(DW1_01)状态切换 [UNIFY EP-->STARTUP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:25:34  STARTUP        OK        DW1_01           OPEN        STANDBY   INVALID  9        59200           59200           

[monitor]         2022-05-26 14:25:34: 守护进程(DW1_01)状态切换 [STARTUP-->OPEN]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:25:34  OPEN           OK        DW1_01           OPEN        STANDBY   INVALID  9        59200           59200           

[monitor]         2022-05-26 14:25:34: 守护进程(DW1_02)状态切换 [OPEN-->RECOVERY]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:25:34  RECOVERY       OK        DW1_02           OPEN        PRIMARY   VALID    10       61661           61662           

[monitor]         2022-05-26 14:25:37: 守护进程(DW1_02)状态切换 [RECOVERY-->OPEN]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2022-05-26 14:25:37  OPEN           OK        DW1_02           OPEN        PRIMARY   VALID    10       61662           61663           


输入命令非法，请输入help命令查看帮助信息！

tip
[monitor]         2022-05-26 14:25:53: 实例DW1_02[PRIMARY, OPEN, ISTAT_SAME:TRUE]不可加入其他实例，守护进程状态：OPEN，Open记录状态：VALID
[monitor]         2022-05-26 14:25:53: 实例DW1_02[PRIMARY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor]         2022-05-26 14:25:53: 实例DW1_02[PRIMARY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态，守护类型是GLOBAL

[monitor]         2022-05-26 14:25:53: 实例DW1_01[STANDBY, OPEN, ISTAT_SAME:TRUE]可加入实例DW1_02[PRIMARY, OPEN, ISTAT_SAME:TRUE]
[monitor]         2022-05-26 14:25:53: 实例DW1_01[STANDBY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor]         2022-05-26 14:25:53: 实例DW1_01[STANDBY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态，守护类型是GLOBAL

[monitor]         2022-05-26 14:25:53: 组(GDW1)当前活动实例运行正常

[monitor]         2022-05-26 14:25:53: 所有组中的活动实例运行正常！


输入命令非法，请输入help命令查看帮助信息！

show global info
2022-05-26 14:26:00 
#================================================================================#
GROUP            OGUID       MON_CONFIRM     MODE            MPP_FLAG  
GDW1             45331       TRUE            AUTO            FALSE     


<<DATABASE GLOBAL INFO:>>
DW_IP               MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.10.101      5436         2022-05-26 14:25:59  GLOBAL    VALID     OPEN           DW1_02           OK        1     1     OPEN        PRIMARY   DSC_OPEN       REALTIME  VALID    

DW_IP               MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.10.100      5436         2022-05-26 14:25:59  GLOBAL    VALID     OPEN           DW1_01           OK        1     1     OPEN        STANDBY   DSC_OPEN       REALTIME  VALID