1.尝试启动多个监控进程
[dmdba@dm3 data]$ /dm/dmdbms/bin/dmmonitor /dm/dmdbms/dm8/data/dmmonitor.ini
Exist multiple CONFIRM dmmonitor, can only startup one!
2.解决方法
必须先关闭后台的守护进程,才能在前台开启。
[dmdba@dm3 data]$ DmMonitorServicesspudb stop
Stopping DmMonitorServicesspudb: [ OK ]
/dm/dmdbms/bin/dmmonitor /dm/dmdbms/dm8/data/dmmonitor.ini
--使用show命令查看状态
show
2024-07-27 15:33:20
#================================================================================#
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.21 25238 2024-07-27 15:33:20 GLOBAL VALID OPEN SSPUDB2 OK 1 1 OPEN PRIMARY DSC_OPEN REALTIME VALID
EP INFO:
INST_IP INST_PORT INST_OK INAME ISTATUS IMODE DSC_SEQNO DSC_CTL_NODE RTYPE RSTAT FSEQ FLSN CSEQ CLSN DW_STAT_FLAG
192.168.1.21 25236 OK SSPUDB2 OPEN PRIMARY 0 0 REALTIME VALID 9579 43373 9579 43373 NONE
<<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 15:33:20 GLOBAL VALID OPEN SSPUDB1 OK 1 1 OPEN STANDBY DSC_OPEN REALTIME VALID
EP INFO:
INST_IP INST_PORT INST_OK INAME ISTATUS IMODE DSC_SEQNO DSC_CTL_NODE RTYPE RSTAT FSEQ FLSN CSEQ CLSN DW_STAT_FLAG
192.168.1.20 15236 OK SSPUDB1 OPEN STANDBY 0 0 REALTIME VALID 8872 43372 8872 43372 NONE
DATABASE(SSPUDB1) APPLY INFO FROM (SSPUDB2), REDOS_PARALLEL_NUM (1):
DSC_SEQNO[0], (RSEQ, SSEQ, KSEQ)[9578, 9578, 9579], (RLSN, SLSN, KLSN)[43372, 43372, 43373], N_TSK[0], TSK_MEM_USE[512]
REDO_LSN_ARR: (43372)
3.手动执行主备切换
choose switchover grp1
Can choose one of the following instances to do switchover:
1: SSPUDB1
switchover grp1.SSPUDB1
[monitor] 2024-07-27 15:36:43: 未登录监视器或服务器公钥发生变化,请重新登录!
login
用户名:sysdba
密码:--这里需要输入密码。
[monitor] 2024-07-27 15:38:14: 登录监视器成功!
--切换主库到SSPUDB1
switchover grp1.SSPUDB1
[monitor] 2024-07-27 15:38:28: 开始切换实例SSPUDB1
[monitor] 2024-07-27 15:38:28: 通知守护进程SSPUDB2切换SWITCHOVER状态
[monitor] 2024-07-27 15:38:28: 守护进程(SSPUDB2)状态切换 [OPEN-->SWITCHOVER]
[monitor] 2024-07-27 15:38:28: 切换守护进程SSPUDB2为SWITCHOVER状态成功
[monitor] 2024-07-27 15:38:28: 通知守护进程SSPUDB1切换SWITCHOVER状态
[monitor] 2024-07-27 15:38:29: 守护进程(SSPUDB1)状态切换 [OPEN-->SWITCHOVER]
[monitor] 2024-07-27 15:38:29: 切换守护进程SSPUDB1为SWITCHOVER状态成功
[monitor] 2024-07-27 15:38:29: 实例SSPUDB2开始执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句
[monitor] 2024-07-27 15:38:29: 实例SSPUDB2执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句成功
[monitor] 2024-07-27 15:38:29: 实例SSPUDB1开始执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句
[monitor] 2024-07-27 15:38:29: 实例SSPUDB1执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句成功
[monitor] 2024-07-27 15:38:29: 实例SSPUDB2开始执行ALTER DATABASE MOUNT语句
[monitor] 2024-07-27 15:38:30: 实例SSPUDB2执行ALTER DATABASE MOUNT语句成功
[monitor] 2024-07-27 15:38:30: 实例SSPUDB1开始执行SP_APPLY_KEEP_PKG()语句
[monitor] 2024-07-27 15:38:30: 实例SSPUDB1执行SP_APPLY_KEEP_PKG()语句成功
[monitor] 2024-07-27 15:38:30: 实例SSPUDB1开始执行ALTER DATABASE MOUNT语句
[monitor] 2024-07-27 15:38:30: 实例SSPUDB1执行ALTER DATABASE MOUNT语句成功
[monitor] 2024-07-27 15:38:30: 实例SSPUDB2开始执行ALTER DATABASE STANDBY语句
[monitor] 2024-07-27 15:38:31: 实例SSPUDB2执行ALTER DATABASE STANDBY语句成功
[monitor] 2024-07-27 15:38:31: 实例SSPUDB1开始执行ALTER DATABASE PRIMARY语句
[monitor] 2024-07-27 15:38:31: 实例SSPUDB1执行ALTER DATABASE PRIMARY语句成功
[monitor] 2024-07-27 15:38:31: 通知实例SSPUDB1修改所有归档状态无效
[monitor] 2024-07-27 15:38:31: 修改所有实例归档为无效状态成功
[monitor] 2024-07-27 15:38:31: 实例SSPUDB2开始执行ALTER DATABASE OPEN FORCE语句
[monitor] 2024-07-27 15:38:31: 实例SSPUDB2执行ALTER DATABASE OPEN FORCE语句成功
[monitor] 2024-07-27 15:38:31: 实例SSPUDB1开始执行ALTER DATABASE OPEN FORCE语句
[monitor] 2024-07-27 15:38:32: 实例SSPUDB1执行ALTER DATABASE OPEN FORCE语句成功
[monitor] 2024-07-27 15:38:32: 实例SSPUDB2开始执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句
[monitor] 2024-07-27 15:38:32: 实例SSPUDB2执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句成功
[monitor] 2024-07-27 15:38:32: 实例SSPUDB1开始执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句
[monitor] 2024-07-27 15:38:32: 实例SSPUDB1执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句成功
[monitor] 2024-07-27 15:38:32: 通知守护进程SSPUDB2切换OPEN状态
[monitor] 2024-07-27 15:38:33: 守护进程(SSPUDB2)状态切换 [SWITCHOVER-->OPEN]
[monitor] 2024-07-27 15:38:33: 切换守护进程SSPUDB2为OPEN状态成功
[monitor] 2024-07-27 15:38:33: 通知守护进程SSPUDB1切换OPEN状态
[monitor] 2024-07-27 15:38:34: 守护进程(SSPUDB1)状态切换 [SWITCHOVER-->OPEN]
[monitor] 2024-07-27 15:38:35: 切换守护进程SSPUDB1为OPEN状态成功
[monitor] 2024-07-27 15:38:35: 通知组(GRP1)的守护进程执行清理操作
[monitor] 2024-07-27 15:38:35: 清理守护进程(SSPUDB1)请求成功
2024-07-27 15:38:35
#================================================================================#
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 15:38:35 GLOBAL VALID OPEN SSPUDB1 OK 1 1 OPEN PRIMARY DSC_OPEN REALTIME VALID
EP INFO:
INST_IP INST_PORT INST_OK INAME ISTATUS IMODE DSC_SEQNO DSC_CTL_NODE RTYPE RSTAT FSEQ FLSN CSEQ CLSN DW_STAT_FLAG
192.168.1.20 15236 OK SSPUDB1 OPEN PRIMARY 0 0 REALTIME VALID 9686 43842 9686 43842 NONE
<<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.21 25238 2024-07-27 15:38:35 GLOBAL VALID OPEN SSPUDB2 OK 1 1 OPEN STANDBY DSC_OPEN REALTIME INVALID
EP INFO:
INST_IP INST_PORT INST_OK INAME ISTATUS IMODE DSC_SEQNO DSC_CTL_NODE RTYPE RSTAT FSEQ FLSN CSEQ CLSN DW_STAT_FLAG
192.168.1.21 25236 OK SSPUDB2 OPEN STANDBY 0 0 REALTIME INVALID 9684 43477 9684 43477 NONE
DATABASE(SSPUDB2) APPLY INFO FROM (SSPUDB1), REDOS_PARALLEL_NUM (1):
DSC_SEQNO[0], (RSEQ, SSEQ, KSEQ)[9684, 9684, 9684], (RLSN, SLSN, KLSN)[43477, 43477, 43477], N_TSK[0], TSK_MEM_USE[0]
REDO_LSN_ARR: (43477)
#================================================================================#
[monitor] 2024-07-27 15:38:35: 清理守护进程(SSPUDB2)请求成功
[monitor] 2024-07-27 15:38:35: 实例SSPUDB1切换成功
[monitor] 2024-07-27 15:38:36: 守护进程(SSPUDB1)状态切换 [OPEN-->RECOVERY]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2024-07-27 15:38:36 RECOVERY OK SSPUDB1 OPEN PRIMARY VALID 7 43842 43843
[monitor] 2024-07-27 15:38:38: 守护进程(SSPUDB1)状态切换 [RECOVERY-->OPEN]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2024-07-27 15:38:38 OPEN OK SSPUDB1 OPEN PRIMARY VALID 7 43843 43844
4.总结
由此可见,已经切换成功。