达梦数据库主备搭建步骤一般有以下几个步骤,按此步骤搭建主备,在第4步启动守护进程时,有可能遇到主备实例状态不能从mount转变为open,一直处于主/备配置模式
1.主机脱机备份,还原到备机
2.修改主机、备机配置文件参数,mount启动
3.修改主备模式
4.启动守护进程
5.启动监视器
查看守护进程日志有如下报错
2023-11-18 23:59:49.148 [INFO] dmwatcher P0000026530 T0000000000000026546 远程实例的模式、状态或者归档状态发生变化,新状态是:
2023-11-18 23:59:49.148 [INFO] dmwatcher P0000026530 T0000000000000026546 Instance: 守护进程状态(STARTUP) 实例状态(OK) 实例名(G
RP1_RT_02) 模式(STANDBY) 实例状态(MOUNT) 归档状态(UNKNOWN) POCNT(6) FLSN(50133) CLSN(50133) SLSN(50133) SSLSN(50133)
2023-11-18 23:59:49.148 [INFO] dmwatcher P0000026530 T0000000000000026545 Local apply info, p_db_magic:1387459480, n_apply_ep:0, pkg_seq_arr:[6344, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[49770, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2023-11-18 23:59:49.148 [INFO] dmwatcher P0000026530 T0000000000000026545 Remote apply info in ctl, ctl_guid:GRP1_RT_02_6, p_db_magic:58447808, n_apply_ep:1, pkg_seq_arr:[6344, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[49770, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2023-11-18 23:59:49.148 [INFO] dmwatcher P0000026530 T0000000000000026545 Local(GRP1_RT_01) ohis is included in remote(GRP1_RT_02) ohis, but apply info mismatch, l_m_s_i(4), f_m_s_i(8), return act(ACT_KEEP)!
守护进程日志报错but apply info mismatch,经过多重试,按以上步骤搭建时,报错可复现,无法完成主备搭建。通过分析,原因可能出现在备份还原上,经过调整备份顺序,把步骤1放到步骤3后,可避免该问题,原因是主备集群要求数据库数据完全一致,主备数据不匹配导致数据守护进程报错,修改后步骤如下:
1.修改主机配置文件参数,mount启动
2.修改主机模式
3.主机脱机备份,还原到备机
4.修改备机配置文件、模式
5.启动守护进程
6.启动监视器
启动守护进程后看到日志如下,主机已由mount状态变为open状态,日志报错apply info mismatch变为正常apply info matched。
2023-11-19 00:18:48.968 [INFO] dmwatcher P0000027140 T0000000000000027156 远程实例的模式、状态或者归档状态发生变化,原状态是:
2023-11-19 00:18:48.968 [INFO] dmwatcher P0000027140 T0000000000000027156 Instance: 守护进程状态(SWITCHOVER) 实例状态(OK) 实例
名(GRP1_RT_02) 模式(PRIMARY) 实例状态(OPEN) 归档状态(INVALID) POCNT(8) FLSN(50471) CLSN(50471) SLSN(50471) SSLSN(50471)
2023-11-19 00:18:49.021 [INFO] dmwatcher P0000027140 T0000000000000027156 远程实例的模式、状态或者归档状态发生变化,新状态是:
2023-11-19 00:18:49.021 [INFO] dmwatcher P0000027140 T0000000000000027156 Instance: 守护进程状态(OPEN) 实例状态(OK) 实例名(GRP1
_RT_02) 模式(PRIMARY) 实例状态(OPEN) 归档状态(INVALID) POCNT(8) FLSN(50471) CLSN(50471) SLSN(50471) SSLSN(50471)
2023-11-19 00:18:50.109 [INFO] dmwatcher P0000027140 T0000000000000027228 dw2_group_reset_mon_info, in dw2 process mon clear, f
rom mid:642946588, old mid:642946588, new mid:0
2023-11-19 00:18:50.109 [INFO] dmwatcher P0000027140 T0000000000000027228 收到监视器CLEAR命令
2023-11-19 00:18:50.109 [INFO] dmwatcher P0000027140 T0000000000000027228 监视器CLEAR命令执行成功
2023-11-19 00:18:50.161 [INFO] dmwatcher P0000027140 T0000000000000027143 Local apply info, p_db_magic:1387459480, n_apply_ep:1
, pkg_seq_arr:[6471, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[50269, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0]!1-19 00:18:50.161 [INFO] dmwatcher P0000027140 T0000000000000027143 Remote apply info in ctl, ctl_guid:GRP1_RT_02_8, p_db
magic:1387459480, n_apply_ep:1, pkg_seq_arr:[6471, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[50269, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2023-11-19 00:18:50.161 [INFO] dmwatcher P0000027140 T0000000000000027143 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)!
文章
阅读量
获赞