/dm8/dmdbms/bin/dmmonitor /dmdata/dm8/data/DMDG/dmmonitor_manual.ini
list
#-------------------dmwatcher configuration of instance(DMGRID1)----------------------#
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 20
INST_ERROR_TIME = 20
INST_RECOVER_TIME = 60
INST_INI = /dmdata/dm8/data/DMDG/dm.ini
DCR_INI =
INST_OGUID = 45331
INST_STARTUP_CMD = /dm8/dmdbms/bin/DmServiceDMGRID1 start
INST_AUTO_RESTART = 1
INST_SERVICE_IP_CHECK = 0
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
#-------------------dmwatcher configuration of instance(DMGRID2)----------------------#
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 20
INST_ERROR_TIME = 20
INST_RECOVER_TIME = 60
INST_INI = /dmdata/dm8/data/DMDG/dm.ini
DCR_INI =
INST_OGUID = 45331
INST_STARTUP_CMD = /dm8/dmdbms/bin/DmServiceDMGRID2 start
INST_AUTO_RESTART = 1
INST_SERVICE_IP_CHECK = 0
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
show global info
2025-10-15 13:57:38
#================================================================================#
GROUP OGUID MON_CONFIRM MODE MPP_FLAG
GRP1 45331 FALSE 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 DETACHED
192.168.132.209 5436 2025-10-15 13:57:38 GLOBAL VALID OPEN DMGRID1 OK 1 1 OPEN PRIMARY DSC_OPEN REALTIME VALID FALSE
DW_IP MAL_DW_PORT WTIME WTYPE WCTLSTAT WSTATUS INAME INST_OK N_EP N_OK ISTATUS IMODE DSC_STATUS RTYPE RSTAT DETACHED
192.168.132.211 5436 2025-10-15 13:57:38 GLOBAL VALID OPEN DMGRID2 OK 1 1 OPEN STANDBY DSC_OPEN REALTIME VALID FALSE
#================================================================================#
tip
[monitor] 2025-10-15 13:58:19: [!!! 提示：本监视器不是确认监视器，在故障自动切换模式下如果发生主库故障，本监视器无法执行自动接管 !!!]
[monitor] 2025-10-15 13:58:19: 实例DMGRID1[PRIMARY, OPEN, ISTAT_SAME:TRUE]不可加入其他实例，守护进程状态：OPEN，Open记录状态：VALID
[monitor] 2025-10-15 13:58:19: 实例DMGRID1[PRIMARY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor] 2025-10-15 13:58:19: 实例DMGRID1[PRIMARY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态，守护类型是GLOBAL
[monitor] 2025-10-15 13:58:19: 实例DMGRID2[STANDBY, OPEN, ISTAT_SAME:TRUE]可加入实例DMGRID1[PRIMARY, OPEN, ISTAT_SAME:TRUE]
[monitor] 2025-10-15 13:58:19: 实例DMGRID2[STANDBY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor] 2025-10-15 13:58:19: 实例DMGRID2[STANDBY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态，守护类型是GLOBAL
[monitor] 2025-10-15 13:58:19: 组(GRP1)当前活动实例运行正常
[monitor] 2025-10-15 13:58:19: 所有组中的活动实例运行正常！
login
用户名:sysdba
密码:
[monitor] 2025-10-15 13:59:01: 登录监视器成功!
choose switchover GRP1
Can choose one of the following instances to do switchover:
1: DMGRID2
switchover
此操作需谨慎, 将会导致主库发生切换, 是否继续使用GRP1.DMGRID2执行SWITCHOVER操作(YES/NO/Y/N)?
yes
[monitor] 2025-10-15 14:03:48: 开始切换实例DMGRID2
[monitor] 2025-10-15 14:03:48: 通知守护进程DMGRID1切换SWITCHOVER状态
[monitor] 2025-10-15 14:03:48: 守护进程(DMGRID1)状态切换 [OPEN-->SWITCHOVER]
[monitor] 2025-10-15 14:03:48: 切换守护进程DMGRID1为SWITCHOVER状态成功
[monitor] 2025-10-15 14:03:48: 通知守护进程DMGRID2切换SWITCHOVER状态
[monitor] 2025-10-15 14:03:48: 守护进程(DMGRID2)状态切换 [OPEN-->SWITCHOVER]
[monitor] 2025-10-15 14:03:48: 切换守护进程DMGRID2为SWITCHOVER状态成功
[monitor] 2025-10-15 14:03:48: 实例DMGRID1开始执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句
[monitor] 2025-10-15 14:03:48: 实例DMGRID1执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句成功
[monitor] 2025-10-15 14:03:48: 实例DMGRID2开始执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句
[monitor] 2025-10-15 14:03:48: 实例DMGRID2执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句成功
[monitor] 2025-10-15 14:03:48: 实例DMGRID1开始执行ALTER DATABASE MOUNT语句
[monitor] 2025-10-15 14:03:48: 实例DMGRID1执行ALTER DATABASE MOUNT语句成功
[monitor] 2025-10-15 14:03:48: 实例DMGRID2开始执行SP_APPLY_KEEP_PKG()语句
[monitor] 2025-10-15 14:03:48: 实例DMGRID2执行SP_APPLY_KEEP_PKG()语句成功
[monitor] 2025-10-15 14:03:48: 实例DMGRID2开始执行ALTER DATABASE MOUNT语句
[monitor] 2025-10-15 14:03:48: 实例DMGRID2执行ALTER DATABASE MOUNT语句成功
[monitor] 2025-10-15 14:03:48: 实例DMGRID1开始执行ALTER DATABASE STANDBY语句
[monitor] 2025-10-15 14:03:49: 实例DMGRID1执行ALTER DATABASE STANDBY语句成功
[monitor] 2025-10-15 14:03:49: 实例DMGRID2开始执行ALTER DATABASE PRIMARY语句
[monitor] 2025-10-15 14:03:49: 实例DMGRID2执行ALTER DATABASE PRIMARY语句成功
[monitor] 2025-10-15 14:03:49: 通知实例DMGRID2修改所有归档状态无效
[monitor] 2025-10-15 14:03:49: 修改所有实例归档为无效状态成功
[monitor] 2025-10-15 14:03:49: 实例DMGRID1开始执行ALTER DATABASE OPEN FORCE语句
[monitor] 2025-10-15 14:03:49: 实例DMGRID1执行ALTER DATABASE OPEN FORCE语句成功
[monitor] 2025-10-15 14:03:49: 实例DMGRID2开始执行ALTER DATABASE OPEN FORCE语句
[monitor] 2025-10-15 14:03:49: 实例DMGRID2执行ALTER DATABASE OPEN FORCE语句成功
[monitor] 2025-10-15 14:03:49: 实例DMGRID1开始执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句
[monitor] 2025-10-15 14:03:49: 实例DMGRID1执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句成功
[monitor] 2025-10-15 14:03:49: 实例DMGRID2开始执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句
[monitor] 2025-10-15 14:03:49: 实例DMGRID2执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句成功
[monitor] 2025-10-15 14:03:49: 通知守护进程DMGRID1切换OPEN状态
[monitor] 2025-10-15 14:03:49: 守护进程(DMGRID1)状态切换 [SWITCHOVER-->OPEN]
[monitor] 2025-10-15 14:03:50: 切换守护进程DMGRID1为OPEN状态成功
[monitor] 2025-10-15 14:03:50: 通知守护进程DMGRID2切换OPEN状态
[monitor] 2025-10-15 14:03:50: 守护进程(DMGRID2)状态切换 [SWITCHOVER-->OPEN]
[monitor] 2025-10-15 14:03:50: 切换守护进程DMGRID2为OPEN状态成功
[monitor] 2025-10-15 14:03:50: 通知组(GRP1)的守护进程执行清理操作
[monitor] 2025-10-15 14:03:50: 清理守护进程(DMGRID1)请求成功
2025-10-15 14:03:50
#================================================================================#
GROUP OGUID MON_CONFIRM MODE MPP_FLAG
[monitor] 2025-10-15 14:03:50: 清理守护进程(DMGRID2)请求成功
[monitor] 2025-10-15 14:03:50: 实例DMGRID2切换成功
GRP1 45331 FALSE 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 DETACHED
192.168.132.211 5436 2025-10-15 14:03:50 GLOBAL VALID OPEN DMGRID2 OK 1 1 OPEN PRIMARY DSC_OPEN REALTIME VALID FALSE
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.132.211 5236 OK DMGRID2 OPEN PRIMARY 0 0 REALTIME VALID 3297 46706 3297 46707 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 DETACHED
192.168.132.209 5436 2025-10-15 14:03:50 GLOBAL VALID OPEN DMGRID1 OK 1 1 OPEN STANDBY DSC_OPEN REALTIME INVALID FALSE
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.132.209 5236 OK DMGRID1 OPEN STANDBY 0 0 REALTIME INVALID 3295 46645 3295 46645 NONE
DATABASE(DMGRID1) APPLY INFO FROM (DMGRID2), REDOS_PARALLEL_NUM (1), WAIT_APPLY[FALSE]:
DSC_SEQNO[0], (RSEQ, SSEQ, KSEQ)[3295, 3295, 3295], (RLSN, SLSN, KLSN)[46645, 46645, 46645], N_TSK[0], TSK_MEM_USE[0]
#================================================================================#
[monitor] 2025-10-15 14:03:52: 守护进程(DMGRID2)状态切换 [OPEN-->RECOVERY]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2025-10-15 14:03:53 RECOVERY OK DMGRID2 OPEN PRIMARY VALID 7 46707 46707
[monitor] 2025-10-15 14:03:56: 守护进程(DMGRID2)状态切换 [RECOVERY-->OPEN]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2025-10-15 14:03:56 OPEN OK DMGRID2 OPEN PRIMARY VALID 7 46707 46707
