【达梦】stop/startup group grp1

最新推荐文章于 2024-11-08 23:31:31 发布

戒掉贪嗔痴(薛双奇)

最新推荐文章于 2024-11-08 23:31:31 发布

阅读量137

点赞数 2

分类专栏：国产数据库-达梦Dameng 文章标签： java 前端数据库

本文链接：https://blog.csdn.net/weixin_43346403/article/details/140738971

版权

国产数据库-达梦Dameng 专栏收录该内容

19 篇文章 1 订阅

订阅专栏

1.停止故障组。

stop group GRP1
--如果提示要登录，请输入 login
// 退出监视器
stop group grp1  --直接关闭两台集群
[monitor]         2024-07-27 17:49:44: 未登录监视器或服务器公钥发生变化，请重新登录!

login
用户名:sysdba
密码:
[monitor]         2024-07-27 17:49:58: 登录监视器成功!
stop group grp1
[monitor]         2024-07-27 17:50:11: STOP实例SSPUDB1[PRIMARY, OPEN, ISTAT_SAME:TRUE]的守护进程
[monitor]         2024-07-27 17:50:11: 守护进程(SSPUDB1)状态切换 [OPEN-->SHUTDOWN]
[monitor]         2024-07-27 17:50:12: STOP实例SSPUDB1[PRIMARY, OPEN, ISTAT_SAME:TRUE]的守护进程成功
[monitor]         2024-07-27 17:50:12: STOP实例SSPUDB2[STANDBY, OPEN, ISTAT_SAME:TRUE]的守护进程
[monitor]         2024-07-27 17:50:12: 守护进程(SSPUDB2)状态切换 [OPEN-->SHUTDOWN]
[monitor]         2024-07-27 17:50:13: STOP实例SSPUDB2[STANDBY, OPEN, ISTAT_SAME:TRUE]的守护进程成功
[monitor]         2024-07-27 17:50:13: 通知实例(SSPUDB1)SHUTDOWN
[monitor]         2024-07-27 17:50:23: 通知实例(SSPUDB1)SHUTDOWN成功，请等待实例完全退出
[monitor]         2024-07-27 17:50:23: 通知实例(SSPUDB2)SHUTDOWN

2.启动故障组。


startup group grp1
[monitor]         2024-07-27 17:52:07: 通知启动组(GRP1)中的所有实例
[monitor]         2024-07-27 17:52:07: 通知组(GRP1)当前活动的守护进程设置MID
[monitor]         2024-07-27 17:52:07: 通知组(GRP1)当前活动的守护进程设置MID成功
[monitor]         2024-07-27 17:52:07: STARTUP实例SSPUDB1[PRIMARY, SHUTDOWN, ISTAT_SAME:TRUE]的守护进程
[monitor]         2024-07-27 17:52:07: 守护进程(SSPUDB1)状态切换 [SHUTDOWN-->STARTUP]
[monitor]         2024-07-27 17:52:08: STARTUP实例SSPUDB1[PRIMARY, SHUTDOWN, ISTAT_SAME:TRUE]的守护进程成功

[monitor]         2024-07-27 17:52:08: 实例SSPUDB1的守护进程配置有自动拉起，请等待守护进程将其自动拉起

[monitor]         2024-07-27 17:52:08: STARTUP实例SSPUDB2[STANDBY, SHUTDOWN, ISTAT_SAME:TRUE]的守护进程
[monitor]         2024-07-27 17:52:08: 守护进程(SSPUDB2)状态切换 [SHUTDOWN-->STARTUP]
[monitor]         2024-07-27 17:52:09: STARTUP实例SSPUDB2[STANDBY, SHUTDOWN, ISTAT_SAME:TRUE]的守护进程成功

[monitor]         2024-07-27 17:52:09: 实例SSPUDB2的守护进程配置有自动拉起，请等待守护进程将其自动拉起

[monitor]         2024-07-27 17:52:09: 通知组(GRP1)的守护进程执行清理操作
[monitor]         2024-07-27 17:52:09: 清理守护进程(SSPUDB1)请求成功
[monitor]         2024-07-27 17:52:09: 清理守护进程(SSPUDB2)请求成功
[monitor]         2024-07-27 17:52:09: 启动组(GRP1)中的所有实例成功

[monitor]         2024-07-27 17:52:14: 守护进程(SSPUDB1)状态切换 [STARTUP-->UNIFY EP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2024-07-27 17:52:14  UNIFY EP       OK        SSPUDB1          MOUNT       PRIMARY   VALID    14       49108           49108           

[monitor]         2024-07-27 17:52:15: 守护进程(SSPUDB1)状态切换 [UNIFY EP-->STARTUP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2024-07-27 17:52:15  STARTUP        OK        SSPUDB1          MOUNT       PRIMARY   VALID    14       49108           49108           

[monitor]         2024-07-27 17:52:15: 守护进程(SSPUDB1)状态切换 [STARTUP-->UNIFY EP]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2024-07-27 17:52:15  UNIFY EP       OK        SSPUDB1          AFTER REDO  PRIMARY   VALID    15       49108           49108           

[monitor]         2024-07-27 17:52:16: 守护进程(SSPUDB1)状态切换 [UNIFY EP-->OPEN]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2024-07-27 17:52:16  OPEN           OK        SSPUDB1          OPEN        PRIMARY   VALID    15       49454

3.检查

检查发现只有主库被拉起，从库SSPUDB2依然没有启动。
手动启动：SSPUDB2
[dmdba@dm2 sspudb]$ DmServicesspudb start
Starting DmServicesspudb:                                  [ OK ]

4.查看全局信息。

show global info
2024-07-27 17:57:26 
#================================================================================#
GROUP            OGUID       MON_CONFIRM     MODE            MPP_FLAG  
GRP1             453331      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.1.20        15238        2024-07-27 17:57:25  GLOBAL    VALID     OPEN           SSPUDB1          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.1.21        25238        2024-07-27 17:57:25  GLOBAL    VALID     OPEN           SSPUDB2          OK        1     1     OPEN        STANDBY   DSC_OPEN       REALTIME  VALID