主备集群的切换流程探究

使用普通监视器进行主备切换的流程

login
用户名:SYSDBA
密码:
[monitor]         2025-10-11 16:01:59: 登录监视器成功!
switchover GRP1.GRP1_RT_02
此操作需谨慎, 将会导致主库发生切换, 是否继续使用GRP1.GRP1_RT_02执行SWITCHOVER操作(YES/NO/Y/N)?
y
[monitor]         2025-10-11 16:02:32: 开始切换实例GRP1_RT_02
[monitor]         2025-10-11 16:02:32: 通知守护进程GRP1_RT_01切换SWITCHOVER状态
[monitor]         2025-10-11 16:02:32: 守护进程(GRP1_RT_01)状态切换 [OPEN-->SWITCHOVER]
[monitor]         2025-10-11 16:02:32: 切换守护进程GRP1_RT_01为SWITCHOVER状态成功
[monitor]         2025-10-11 16:02:32: 通知守护进程GRP1_RT_02切换SWITCHOVER状态
[monitor]         2025-10-11 16:02:32: 守护进程(GRP1_RT_02)状态切换 [OPEN-->SWITCHOVER]
[monitor]         2025-10-11 16:02:32: 切换守护进程GRP1_RT_02为SWITCHOVER状态成功
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_01开始执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_01执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句成功
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_02开始执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_02执行SP_SET_GLOBAL_DW_STATUS(0, 6)语句成功
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_01开始执行ALTER DATABASE MOUNT语句
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_01执行ALTER DATABASE MOUNT语句成功
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_02开始执行SP_APPLY_KEEP_PKG()语句
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_02执行SP_APPLY_KEEP_PKG()语句成功
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_02开始执行ALTER DATABASE MOUNT语句
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_02执行ALTER DATABASE MOUNT语句成功
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_01开始执行ALTER DATABASE STANDBY语句
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_01执行ALTER DATABASE STANDBY语句成功
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_02开始执行ALTER DATABASE PRIMARY语句
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_02执行ALTER DATABASE PRIMARY语句成功
[monitor]         2025-10-11 16:02:32: 通知实例GRP1_RT_02修改所有归档状态无效
[monitor]         2025-10-11 16:02:32: 修改所有实例归档为无效状态成功
[monitor]         2025-10-11 16:02:32: 实例GRP1_RT_01开始执行ALTER DATABASE OPEN FORCE语句
[monitor]         2025-10-11 16:02:33: 实例GRP1_RT_01执行ALTER DATABASE OPEN FORCE语句成功
[monitor]         2025-10-11 16:02:33: 实例GRP1_RT_02开始执行ALTER DATABASE OPEN FORCE语句
[monitor]         2025-10-11 16:02:33: 实例GRP1_RT_02执行ALTER DATABASE OPEN FORCE语句成功
[monitor]         2025-10-11 16:02:33: 实例GRP1_RT_01开始执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句
[monitor]         2025-10-11 16:02:33: 实例GRP1_RT_01执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句成功
[monitor]         2025-10-11 16:02:33: 实例GRP1_RT_02开始执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句
[monitor]         2025-10-11 16:02:33: 实例GRP1_RT_02执行SP_SET_GLOBAL_DW_STATUS(6, 0)语句成功
[monitor]         2025-10-11 16:02:33: 通知守护进程GRP1_RT_01切换OPEN状态
[monitor]         2025-10-11 16:02:33: 守护进程(GRP1_RT_01)状态切换 [SWITCHOVER-->OPEN]
[monitor]         2025-10-11 16:02:33: 切换守护进程GRP1_RT_01为OPEN状态成功
[monitor]         2025-10-11 16:02:33: 通知守护进程GRP1_RT_02切换OPEN状态
[monitor]         2025-10-11 16:02:33: 守护进程(GRP1_RT_02)状态切换 [SWITCHOVER-->OPEN]
[monitor]         2025-10-11 16:02:34: 切换守护进程GRP1_RT_02为OPEN状态成功
[monitor]         2025-10-11 16:02:34: 通知组(GRP1)的守护进程执行清理操作
[monitor]         2025-10-11 16:02:34: 清理守护进程(GRP1_RT_01)请求成功

2025-10-11 16:02:34
#================================================================================#
GROUP            OGUID       MON_CONFIRM     MODE            MPP_FLAG
GRP1             453331      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.57.103  52142        2025-10-11 16:02:34  GLOBAL    VALID     OPEN           GRP1_RT_02       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.57.103  5236       OK        GRP1_RT_02       OPEN        PRIMARY   0          0            REALTIME  VALID       4988            68955           4988            68955           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.57.102  52141        2025-10-11 16:02:34  GLOBAL    VALID     OPEN           GRP1_RT_01       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.57.102  5236       OK        GRP1_RT_01       OPEN        STANDBY   0          0            REALTIME  INVALID     4986            68864           4986            68864           NONE

DATABASE(GRP1_RT_01) APPLY INFO FROM (GRP1_RT_02), REDOS_PARALLEL_NUM (1), WAIT_APPLY[FALSE]:
DSC_SEQNO[0], (RSEQ, SSEQ, KSEQ)[4986, 4986, 4986], (RLSN, SLSN, KLSN)[68864, 68864, 68864], N_TSK[0], TSK_MEM_USE[0]
REDO_LSN_ARR: (68864)


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

[monitor]         2025-10-11 16:02:34: 清理守护进程(GRP1_RT_02)请求成功
[monitor]         2025-10-11 16:02:34: 实例GRP1_RT_02切换成功

[monitor]         2025-10-11 16:02:36: 守护进程(GRP1_RT_02)状态切换 [OPEN-->RECOVERY]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN
                  2025-10-11 16:02:36  RECOVERY       OK        GRP1_RT_02       OPEN        PRIMARY   VALID    19       68955           68955

[monitor]         2025-10-11 16:02:41: 守护进程(GRP1_RT_02)状态切换 [RECOVERY-->OPEN]
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN
                  2025-10-11 16:02:41  OPEN           OK        GRP1_RT_02       OPEN        PRIMARY   VALID    19       68955           68955

切换过程中，原主库的守护进程输出日志如下：

2025-10-11 16:02:31.013 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info org info, mid:210076262, cmd:0, dseq:0, code:100, status:0, mon_ip:, rarch_status:0, processed:0, sql:
2025-10-11 16:02:31.013 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info new info, mid:210076262, cmd:0, dseq:2357559919, code:0, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:
2025-10-11 16:02:31.013 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_process_set_mid, old mid:210076262, new mid:210076262, dseq:2357559919
2025-10-11 16:02:31.127 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info org info, mid:210076262, cmd:0, dseq:2357559919, code:0, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:
2025-10-11 16:02:31.128 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info new info, mid:210076262, cmd:13, dseq:2357559920, code:100, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:
2025-10-11 16:02:31.128 [INFO] dmwatcher P0000025576 T0000000000000025580  收到监视器LOGIN CHECK命令
2025-10-11 16:02:31.128 [INFO] dmwatcher P0000025576 T0000000000000025580  switch sub_state to pre_set_dw_stat!
2025-10-11 16:02:31.128 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程为LOGIN CHECK(SUB:STARTUP)状态
2025-10-11 16:02:31.189 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_notify_set_dw_stat, dseq = 1760155593, from_dw_stat: NONE, to_dw_stat: MON_LOGIN_CHECK
2025-10-11 16:02:31.189 [INFO] dmwatcher P0000025576 T0000000000000025580  Send tcp msg to local ep GRP1_RT_01, hpc_seqno:0, code:0
2025-10-11 16:02:31.189 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程子状态为WAIT_SET_DW_STAT状态
2025-10-11 16:02:31.191 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=217, dseq=1760155593, code=0
2025-10-11 16:02:31.191 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_clear_ep_cmd_info_low, clear ep(GRP1_RT_01) cmd info, and reset curr_ep to NULL.
2025-10-11 16:02:31.191 [INFO] dmwatcher P0000025576 T0000000000000025580  notify ep(GRP1_RT_01) set dw_stat to MON_LOGIN_CHECK success!
2025-10-11 16:02:31.315 [INFO] dmwatcher P0000025576 T0000000000000025580  Send tcp msg to local ep GRP1_RT_01, hpc_seqno:0, code:0
2025-10-11 16:02:31.316 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_notify_login_check success, dseq (1760155594)
2025-10-11 16:02:31.317 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=13, dseq=1760155594, code=0
2025-10-11 16:02:31.318 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_clear_ep_cmd_info_low, clear ep(GRP1_RT_01) cmd info, and reset curr_ep to NULL.
2025-10-11 16:02:31.318 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_last_code, set last code:0, current dseq:2357559920, code:100, mid:210076262!
2025-10-11 16:02:31.318 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程子状态为SUB_STATE_CLEAR状态
2025-10-11 16:02:32.135 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_notify_set_dw_stat, dseq = 1760155595, from_dw_stat: MON_LOGIN_CHECK, to_dw_stat: NONE
2025-10-11 16:02:32.136 [INFO] dmwatcher P0000025576 T0000000000000025580  Send tcp msg to local ep GRP1_RT_01, hpc_seqno:0, code:0
2025-10-11 16:02:32.136 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程子状态为WAIT_CLEAR状态
2025-10-11 16:02:32.137 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=217, dseq=1760155595, code=0
2025-10-11 16:02:32.137 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_clear_ep_cmd_info_low, clear ep(GRP1_RT_01) cmd info, and reset curr_ep to NULL.
2025-10-11 16:02:32.137 [INFO] dmwatcher P0000025576 T0000000000000025580  notify ep(GRP1_RT_01) set dw_stat to NONE success!
2025-10-11 16:02:32.137 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_clear_ep_cmd_info_low, clear ep(GRP1_RT_01) cmd info.
2025-10-11 16:02:32.137 [INFO] dmwatcher P0000025576 T0000000000000025580  Clear all ep g_dw_status finished, monitor cmd exec finished!
2025-10-11 16:02:32.137 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_code_low, set code:0, current dseq:2357559920, last_code:0, mid:210076262!
2025-10-11 16:02:32.137 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_last_code, set last code:100, current dseq:2357559920, code:0, mid:210076262!
2025-10-11 16:02:32.137 [INFO] dmwatcher P0000025576 T0000000000000025580  switch sub_state to sub_stat_start!
2025-10-11 16:02:32.138 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程为OPEN(SUB:STARTUP)状态
2025-10-11 16:02:32.185 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info org info, mid:210076262, cmd:13, dseq:2357559920, code:0, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:1, sql:
2025-10-11 16:02:32.185 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info new info, mid:210076262, cmd:3, dseq:2357559921, code:100, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:
2025-10-11 16:02:32.185 [INFO] dmwatcher P0000025576 T0000000000000025580  收到监视器修改守护进程为(SWITCHOVER)状态请求,当前守护进程状态(OPEN)
2025-10-11 16:02:32.185 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_process_switchover_msg, set mid, old mid:210076262, from mid:210076262
2025-10-11 16:02:32.185 [INFO] dmwatcher P0000025576 T0000000000000025580  switch sub_state to sub_stat_start!
2025-10-11 16:02:32.185 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程为SWITCHOVER(SUB:STARTUP)状态
2025-10-11 16:02:32.242 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_code_low, set code:0, current dseq:2357559921, last_code:100, mid:210076262!
2025-10-11 16:02:32.251 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，原状态是：
2025-10-11 16:02:32.251 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(OPEN) 实例状态(OK) 实例名(GRP1_RT_02) 模式(STANDBY) 实例状态(OPEN) 归档状态(UNKNOWN) POCNT(18) FLSN(68864) CLSN(68864) SLSN(68864) SSLSN(68864)
2025-10-11 16:02:32.304 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，新状态是：
2025-10-11 16:02:32.366 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(SWITCHOVER) 实例状态(OK) 实例名(GRP1_RT_02) 模式(STANDBY) 实例状态(OPEN) 归档状态(UNKNOWN) POCNT(18) FLSN(68864) CLSN(68864) SLSN(68864) SSLSN(68864)
2025-10-11 16:02:32.368 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info org info, mid:210076262, cmd:3, dseq:2357559921, code:0, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:1, sql:
2025-10-11 16:02:32.368 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info new info, mid:210076262, cmd:1, dseq:2357559923, code:100, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:SP_SET_GLOBAL_DW_STATUS(0, 6)
2025-10-11 16:02:32.368 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_notify_sql_exec, dseq = 1760155596, sql: SP_SET_GLOBAL_DW_STATUS(0, 6)
2025-10-11 16:02:32.368 [INFO] dmwatcher P0000025576 T0000000000000025580  Send tcp msg to local ep GRP1_RT_01, hpc_seqno:0, code:0
2025-10-11 16:02:32.368 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程子状态为WAIT_SQL状态
2025-10-11 16:02:32.368 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=1, dseq=1760155596, code=0
2025-10-11 16:02:32.368 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_clear_ep_cmd_info_low, clear ep(GRP1_RT_01) cmd info, and reset curr_ep to NULL.
2025-10-11 16:02:32.368 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_code_low, set code:0, current dseq:2357559923, last_code:100, mid:210076262!
2025-10-11 16:02:32.491 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info org info, mid:210076262, cmd:1, dseq:2357559923, code:0, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:1, sql:SP_SET_GLOBAL_DW_STATUS(0, 6)
2025-10-11 16:02:32.491 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info new info, mid:210076262, cmd:1, dseq:2357559925, code:100, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:ALTER DATABASE MOUNT
2025-10-11 16:02:32.491 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_notify_sql_exec, dseq = 1760155597, sql: ALTER DATABASE MOUNT
2025-10-11 16:02:32.492 [INFO] dmwatcher P0000025576 T0000000000000025580  Send tcp msg to local ep GRP1_RT_01, hpc_seqno:0, code:0
2025-10-11 16:02:32.492 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程子状态为WAIT_SQL状态
2025-10-11 16:02:32.503 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=1, dseq=1760155597, code=100
2025-10-11 16:02:32.529 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=1, dseq=1760155597, code=0
2025-10-11 16:02:32.529 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_clear_ep_cmd_info_low, clear ep(GRP1_RT_01) cmd info, and reset curr_ep to NULL.
2025-10-11 16:02:32.529 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_code_low, set code:0, current dseq:2357559925, last_code:100, mid:210076262!
2025-10-11 16:02:32.674 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，原状态是：
2025-10-11 16:02:32.674 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(SWITCHOVER) 实例状态(OK) 实例名(GRP1_RT_02) 模式(STANDBY) 实例状态(OPEN) 归档状态(UNKNOWN) POCNT(18) FLSN(68864) CLSN(68864) SLSN(68864) SSLSN(68864)
2025-10-11 16:02:32.724 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info org info, mid:210076262, cmd:1, dseq:2357559925, code:0, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:1, sql:ALTER DATABASE MOUNT
2025-10-11 16:02:32.724 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info new info, mid:210076262, cmd:1, dseq:2357559928, code:100, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:ALTER DATABASE STANDBY
2025-10-11 16:02:32.724 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_notify_sql_exec, dseq = 1760155598, sql: ALTER DATABASE STANDBY
2025-10-11 16:02:32.724 [INFO] dmwatcher P0000025576 T0000000000000025580  Send tcp msg to local ep GRP1_RT_01, hpc_seqno:0, code:0
2025-10-11 16:02:32.724 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程子状态为WAIT_SQL状态
2025-10-11 16:02:32.724 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，新状态是：
2025-10-11 16:02:32.731 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=1, dseq=1760155598, code=100
2025-10-11 16:02:32.778 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(SWITCHOVER) 实例状态(OK) 实例名(GRP1_RT_02) 模式(STANDBY) 实例状态(MOUNT) 归档状态(UNKNOWN) POCNT(18) FLSN(68864) CLSN(68864) SLSN(68864) SSLSN(68864)
2025-10-11 16:02:32.794 [INFO] dmwatcher P0000025576 T0000000000000025591  Local db apply info changed, old info[p_db_magic:431410808, n_apply_ep:0], new info to set[p_db_magic:431410808, n_apply_ep:1]!
2025-10-11 16:02:32.794 [INFO] dmwatcher P0000025576 T0000000000000025591  dw2_process_apply_info, n_rapply changed from 0 to 1, old apply_lsn[], new apply_lsn[68864]
2025-10-11 16:02:32.794 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=1, dseq=1760155598, code=0
2025-10-11 16:02:32.794 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_clear_ep_cmd_info_low, clear ep(GRP1_RT_01) cmd info, and reset curr_ep to NULL.
2025-10-11 16:02:32.794 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_code_low, set code:0, current dseq:2357559928, last_code:100, mid:210076262!
2025-10-11 16:02:32.899 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，原状态是：
2025-10-11 16:02:32.899 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(SWITCHOVER) 实例状态(OK) 实例名(GRP1_RT_02) 模式(STANDBY) 实例状态(MOUNT) 归档状态(UNKNOWN) POCNT(18) FLSN(68864) CLSN(68864) SLSN(68864) SSLSN(68864)
2025-10-11 16:02:32.954 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，新状态是：
2025-10-11 16:02:32.954 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(SWITCHOVER) 实例状态(OK) 实例名(GRP1_RT_02) 模式(PRIMARY) 实例状态(MOUNT) 归档状态(INVALID) POCNT(18) FLSN(68864) CLSN(68864) SLSN(68864) SSLSN(68864)
2025-10-11 16:02:33.006 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info org info, mid:210076262, cmd:1, dseq:2357559928, code:0, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:1, sql:ALTER DATABASE STANDBY
2025-10-11 16:02:33.007 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info new info, mid:210076262, cmd:1, dseq:2357559931, code:100, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:ALTER DATABASE OPEN FORCE
2025-10-11 16:02:33.007 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_notify_sql_exec, dseq = 1760155599, sql: ALTER DATABASE OPEN FORCE
2025-10-11 16:02:33.008 [INFO] dmwatcher P0000025576 T0000000000000025580  Send tcp msg to local ep GRP1_RT_01, hpc_seqno:0, code:0
2025-10-11 16:02:33.008 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程子状态为WAIT_SQL状态
2025-10-11 16:02:33.008 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=1, dseq=1760155599, code=100
2025-10-11 16:02:33.028 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=1, dseq=1760155599, code=0
2025-10-11 16:02:33.028 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_clear_ep_cmd_info_low, clear ep(GRP1_RT_01) cmd info, and reset curr_ep to NULL.
2025-10-11 16:02:33.028 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_code_low, set code:0, current dseq:2357559931, last_code:100, mid:210076262!
2025-10-11 16:02:33.721 [INFO] dmwatcher P0000025576 T0000000000000025747  ohis_inst_info_copy_low, inst(GRP1_RT_02) apply info changed, old info[p_db_magic:431410808, n_apply_ep:1], new info to set[p_db_magic:1810686012, n_apply_ep:0]!
2025-10-11 16:02:33.721 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，原状态是：
2025-10-11 16:02:33.721 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(SWITCHOVER) 实例状态(OK) 实例名(GRP1_RT_02) 模式(PRIMARY) 实例状态(MOUNT) 归档状态(INVALID) POCNT(18) FLSN(68864) CLSN(68864) SLSN(68864) SSLSN(68864)
2025-10-11 16:02:33.749 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info org info, mid:210076262, cmd:1, dseq:2357559931, code:0, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:1, sql:ALTER DATABASE OPEN FORCE
2025-10-11 16:02:33.749 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info new info, mid:210076262, cmd:1, dseq:2357559933, code:100, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:SP_SET_GLOBAL_DW_STATUS(6, 0)
2025-10-11 16:02:33.750 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_notify_sql_exec, dseq = 1760155600, sql: SP_SET_GLOBAL_DW_STATUS(6, 0)
2025-10-11 16:02:33.750 [INFO] dmwatcher P0000025576 T0000000000000025580  Send tcp msg to local ep GRP1_RT_01, hpc_seqno:0, code:0
2025-10-11 16:02:33.750 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程子状态为WAIT_SQL状态
2025-10-11 16:02:33.751 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_group_get_curr_ep_retcode, ep(GRP1_RT_01) cmd_ret:cmd=1, dseq=1760155600, code=0
2025-10-11 16:02:33.751 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_clear_ep_cmd_info_low, clear ep(GRP1_RT_01) cmd info, and reset curr_ep to NULL.
2025-10-11 16:02:33.751 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_code_low, set code:0, current dseq:2357559933, last_code:100, mid:210076262!
2025-10-11 16:02:33.778 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，新状态是：
2025-10-11 16:02:33.840 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(SWITCHOVER) 实例状态(OK) 实例名(GRP1_RT_02) 模式(PRIMARY) 实例状态(OPEN) 归档状态(INVALID) POCNT(19) FLSN(68865) CLSN(68955) SLSN(68955) SSLSN(68955)
2025-10-11 16:02:33.871 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info org info, mid:210076262, cmd:1, dseq:2357559933, code:0, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:1, sql:SP_SET_GLOBAL_DW_STATUS(6, 0)
2025-10-11 16:02:33.871 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_set_mon_info new info, mid:210076262, cmd:6, dseq:2357559935, code:100, status:1, mon_ip:::ffff:192.168.57.103, rarch_status:0, processed:0, sql:
2025-10-11 16:02:33.871 [INFO] dmwatcher P0000025576 T0000000000000025580  收到监视器通知守护进程切换OPEN状态命令
2025-10-11 16:02:33.871 [INFO] dmwatcher P0000025576 T0000000000000025580  switch sub_state to sub_stat_start!
2025-10-11 16:02:33.871 [INFO] dmwatcher P0000025576 T0000000000000025580  设置GRP1守护进程为OPEN(SUB:STARTUP)状态
2025-10-11 16:02:33.931 [INFO] dmwatcher P0000025576 T0000000000000025580  dw2_set_mon_info_code_low, set code:0, current dseq:2357559935, last_code:100, mid:210076262!
2025-10-11 16:02:34.000 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，原状态是：
2025-10-11 16:02:34.000 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(SWITCHOVER) 实例状态(OK) 实例名(GRP1_RT_02) 模式(PRIMARY) 实例状态(OPEN) 归档状态(INVALID) POCNT(19) FLSN(68955) CLSN(68955) SLSN(68955) SSLSN(68955)
2025-10-11 16:02:34.054 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，新状态是：
2025-10-11 16:02:34.057 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_reset_mon_info, in dw2 process mon clear, from mid:210076262, old mid:210076262, new mid:0
2025-10-11 16:02:34.057 [INFO] dmwatcher P0000025576 T0000000000000025615  收到监视器CLEAR命令
2025-10-11 16:02:34.057 [INFO] dmwatcher P0000025576 T0000000000000025615  监视器CLEAR命令执行成功
2025-10-11 16:02:34.116 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:34.116 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:34.116 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:34.118 [INFO] dmwatcher P0000025576 T0000000000000025615  dw2_group_reset_mon_info, in dw2 process mon clear, from mid:210076262, old mid:0, new mid:0
2025-10-11 16:02:34.118 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:34.118 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:34.118 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:34.177 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(OPEN) 实例状态(OK) 实例名(GRP1_RT_02) 模式(PRIMARY) 实例状态(OPEN) 归档状态(INVALID) POCNT(19) FLSN(68955) CLSN(68955) SLSN(68955) SSLSN(68955)
2025-10-11 16:02:34.239 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:34.239 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:34.239 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:34.758 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:34.758 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:34.758 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:35.066 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:35.066 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:35.066 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:35.767 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:35.767 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:35.767 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:36.082 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:36.082 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:36.082 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:36.261 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，原状态是：
2025-10-11 16:02:36.261 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(OPEN) 实例状态(OK) 实例名(GRP1_RT_02) 模式(PRIMARY) 实例状态(OPEN) 归档状态(INVALID) POCNT(19) FLSN(68955) CLSN(68955) SLSN(68955) SSLSN(68955)
2025-10-11 16:02:36.318 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，新状态是：
2025-10-11 16:02:36.380 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(RECOVERY) 实例状态(OK) 实例名(GRP1_RT_02) 模式(PRIMARY) 实例状态(OPEN) 归档状态(INVALID) POCNT(19) FLSN(68955) CLSN(68955) SLSN(68955) SSLSN(68955)
2025-10-11 16:02:36.441 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:36.441 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:36.442 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:36.768 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:36.769 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:36.769 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:37.266 [INFO] dmwatcher P0000025576 T0000000000000025580  Local apply info, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:37.266 [INFO] dmwatcher P0000025576 T0000000000000025580  Remote apply info in ctl, ctl_guid:GRP1_RT_02_19, p_db_magic:431410808, n_apply_ep:1, pkg_seq_arr:[4986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68864, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:37.266 [INFO] dmwatcher P0000025576 T0000000000000025580  Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, and apply info matched, l_m_s_i(6), return act(ACT_KEEP)!
2025-10-11 16:02:39.775 [INFO] dmwatcher P0000025576 T0000000000000025591  Local db apply info changed, old info[p_db_magic:431410808, n_apply_ep:1], new info to set[p_db_magic:1810686012, n_apply_ep:1]!
2025-10-11 16:02:39.775 [INFO] dmwatcher P0000025576 T0000000000000025591  dw2_process_ohis_info, n_ohis changed from 18 to 19, from_ep:GRP1_RT_01, ep_seqno:0, hpc_master:0
2025-10-11 16:02:39.775 [INFO] dmwatcher P0000025576 T0000000000000025591  dw2_process_ohis_info local apply info, p_db_magic:1810686012, n_apply_ep:1, n_fill_ep:1 pkg_seq_arr:[4988, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[68955, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-10-11 16:02:41.095 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，原状态是：
2025-10-11 16:02:41.095 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(RECOVERY) 实例状态(OK) 实例名(GRP1_RT_02) 模式(PRIMARY) 实例状态(OPEN) 归档状态(INVALID) POCNT(19) FLSN(68955) CLSN(68955) SLSN(68955) SSLSN(68955)
2025-10-11 16:02:41.152 [INFO] dmwatcher P0000025576 T0000000000000025747  远程实例的模式、状态或者归档状态发生变化，新状态是：
2025-10-11 16:02:41.215 [INFO] dmwatcher P0000025576 T0000000000000025747  Instance: 守护进程状态(OPEN) 实例状态(OK) 实例名(GRP1_RT_02) 模式(PRIMARY) 实例状态(OPEN) 归档状态(INVALID) POCNT(19) FLSN(68955) CLSN(68955) SLSN(68955) SSLSN(68955)

新主库的守护进程切换日志如下：

主备集群的切换流程探究

作者