达梦数据库-Linux DM主备集群动态增加节点-记录总结

​​​1达梦数据库-Linux DM主备集群动态增加节点-记录总结1.1需求说明原主备集群上新增1个节点配置为高性能同步模式不参与故障自动切换。dmarch.ini中重点参数WAIT_APPLY 0ARCH_FAILOVER 11.2规划说明1.3搭建原主备集群1.3.1搭建略1.3.2结果查询1.4原主备集群登录主库查询路径相关--是否开启空间数据应用SELECT SF_CHECK_GEO2_SYS;--数据库表空间目录SELECT TS.NAME, DF.PATH FROM V$TABLESPACE AS TS, V$DATAFILE AS DF WHERE TS.ID DF.GROUP_ID;--归档情况select ARCH_TYPE,ARCH_DEST,ARCH_FILE_SIZE,ARCH_SPACE_LIMIT from v$dm_arch_ini;--日志跟踪开启情况SELECT PARA_NAME,PARA_VALUE FROM V$DM_INI WHERE PARA_NAME IN(PORT_NUM,SVR_LOG,ARCH_INI);cat /data/dmdata/DAMENG/sqllog.ini--是否开启审计审计目录位置SELECT PARA_NAME,PARA_VALUE FROM V$DM_INI WHERE PARA_NAME in(ENABLE_AUDIT,SYSTEM_PATH);select * from V$AUDIT_SPACE;--备份路径相关select * from SYSJOB.SYSJOBS;select * from SYSJOB.SYSJOBSTEPS;select * from SYSJOB.SYSJOBSCHEDULES;1.5新机器C环境准备1.5.1安装和原集群相同数据库软件版本初始化实例启动完全后关闭数据库[root]# su - dmdba[dmdba]$cd /data/dmdbms/bin[dmdba]$./dminit path/data/dmdata page_size32 extent_size32 port_num5237 log_size2048 CASE_SENSITIVE1 charset1 DB_NAMEDAMENG SYSDBA_PWDTEST_qweasd9999 SYSAUDITOR_PWDTEST_qweasd99991.5.2目录提前创建准备mkdir /testtpsmkdir /data/dmdata/DAMENG/auditlogchown -R dmdba:dinstall /testtps /data/dmdata/DAMENG/auditlog1.6原主备集群进行数据库物理全备份SP_DBMS_JOB_RUN (1781162519);scp -r /data/dmbak/DAMENG/bak/DB_DAMENG_FULL_2026_06_13_14_11_12 dmdba192.168.118.239:/data/dmbak/DAMENG/bak/​​​​​​​1.7新机器C进行数据库还原恢复su - dmdball /data/dmdata/DAMENG/bak/cd /data/dmdbms/bin./dmrmanRMAN RESTORE DATABASE /data/dmdata/DAMENG/dm.iniREUSE DMINIFROM BACKUPSET /data/dmbak/DAMENG/bak/DB_DAMENG_FULL_2026_06_13_14_11_12;RMAN RECOVER DATABASE /data/dmdata/DAMENG/dm.iniFOR STANDBYFROM BACKUPSET /data/dmbak/DAMENG/bak/DB_DAMENG_FULL_2026_06_13_14_11_12;RMAN RECOVER DATABASE /data/dmdata/DAMENG/dm.ini UPDATE DB_MAGIC ;​​​​​​​1.8新机器C修改配置dm.ini这里只需要修改新机器C的数据库参数配置文件dm.ini##实例名建议使用“组名_守护环境_序号”的命名方式总长度不能超过16INSTANCE_NAME GRP1_DW_03PORT_NUM 5237 ##数据库实例监听端口DW_INACTIVE_INTERVAL 60 ##接收守护进程消息超时时间ALTER_MODE_STATUS 0 ##不允许手工方式修改实例模式/状态/OGUIDENABLE_OFFLINE_TS 2 ##不允许备库OFFLINE表空间MAL_INI 1 ##打开MAL系统ARCH_INI 1 ##打开归档配置RLOG_SEND_APPLY_MON 64 ##统计最近64次的日志发送信息设置完成后查询检查cat /data/dmdata/DAMENG/dm.ini |grep INSTANCE_NAMEcat /data/dmdata/DAMENG/dm.ini |grep INSTANCE_NAMEcat /data/dmdata/DAMENG/dm.ini |grep PORT_NUMcat /data/dmdata/DAMENG/dm.ini |grep DW_INACTIVE_INTERVALcat /data/dmdata/DAMENG/dm.ini |grep ALTER_MODE_STATUScat /data/dmdata/DAMENG/dm.ini |grep ENABLE_OFFLINE_TScat /data/dmdata/DAMENG/dm.ini |grep MAL_INIcat /data/dmdata/DAMENG/dm.ini |grep RLOG_SEND_APPLY_MONcat /data/dmdata/DAMENG/dm.ini |grep AUD_PATH​​​​​​​1.9新机器C新增配置dmarch.iniARCH_WAIT_APPLY 1[ARCHIVE_LOCAL1]ARCH_TYPE LOCALARCH_DEST /data/dmarch/DAMENGARCH_FILE_SIZE 1024ARCH_SPACE_LIMIT 20480[ARCHIVE_REALTIME1]ARCH_TYPE REALTIMEARCH_DEST GRP1_DW_01[ARCHIVE_REALTIME2]ARCH_TYPE REALTIMEARCH_DEST GRP1_DW_02​​​​​​​1.10新机器C新增配置dmwatcher.ini所有机器都保持一致。[GRP1]DW_TYPE GLOBALDW_MODE AUTODW_ERROR_TIME 30INST_ERROR_TIME 20INST_RECOVER_TIME 60INST_OGUID 532318INST_INI /data/dmdata/DAMENG/dm.iniINST_AUTO_RESTART 1INST_STARTUP_CMD /data/dmdbms/bin/DmServiceDAMENG startRLOG_SEND_THRESHOLD 0RLOG_APPLY_THRESHOLD 0​​​​​​​1.11新机器C新增配置dmmal.ini所有机器都保持一致。MAL_CHECK_INTERVAL 5MAL_CONN_FAIL_INTERVAL 15MAL_TEMP_PATH /data/dmdata/DAMENGMAL_BUF_SIZE 512MAL_SYS_BUF_SIZE 2048MAL_COMPRESS_LEVEL 0MAL_VPOOL_SIZE 128[MAL_INST1]MAL_INST_NAME GRP1_DW_01MAL_HOST 192.168.118.236MAL_PORT 65237MAL_INST_HOST 192.168.118.236MAL_INST_PORT 5237MAL_DW_PORT 55237MAL_INST_DW_PORT 35237MAL_LINK_MAGIC 1[MAL_INST2]MAL_INST_NAME GRP1_DW_02MAL_HOST 192.168.118.237MAL_PORT 65237MAL_INST_HOST 192.168.118.237MAL_INST_PORT 5237MAL_DW_PORT 55237MAL_INST_DW_PORT 35237MAL_LINK_MAGIC 1[MAL_INST3]MAL_INST_NAME GRP1_DW_03MAL_HOST 192.168.118.239MAL_PORT 65237MAL_INST_HOST 192.168.118.239MAL_INST_PORT 5237MAL_DW_PORT 55237MAL_INST_DW_PORT 35237MAL_LINK_MAGIC 1​​​​​​​1.12新机器C配置数据库模式和oguid--以mount方式启动数据库dmserver /data/dmdata/DAMENG/dm.ini mount--设置OGUID和数据库模式SP_SET_PARA_VALUE(1,ALTER_MODE_STATUS,1);SP_SET_OGUID(532318);ALTER DATABASE STANDBY;SP_SET_PARA_VALUE(1,ALTER_MODE_STATUS,0);​​​​​​​1.13修改配置原数据库主备集群机dmarch.ini和dmmal.ini​​​​​​​1.13.1静态配置-配置完成后重启数据库​​​​​​​1.13.1.1A机器dmarch.iniARCH_WAIT_APPLY 1[ARCHIVE_LOCAL1]ARCH_TYPE LOCALARCH_DEST /data/dmarch/DAMENGARCH_FILE_SIZE 1024ARCH_SPACE_LIMIT 20480[ARCHIVE_REALTIME1]ARCH_TYPE REALTIMEARCH_DEST GRP1_DW_02[ARCHIVE_REALTIME2]ARCH_TYPE REALTIMEARCH_DEST GRP1_DW_03WAIT_APPLY 0ARCH_FAILOVER 1​​​​​​​1.13.1.2B机器dmarch.iniARCH_WAIT_APPLY 1[ARCHIVE_LOCAL1]ARCH_TYPE LOCALARCH_DEST /data/dmarch/DAMENGARCH_FILE_SIZE 1024ARCH_SPACE_LIMIT 20480[ARCHIVE_REALTIME1]ARCH_TYPE REALTIMEARCH_DEST GRP1_DW_01[ARCHIVE_REALTIME2]ARCH_TYPE REALTIMEARCH_DEST GRP1_DW_03WAIT_APPLY 0ARCH_FAILOVER 1​​​​​​​1.13.1.3A机器和B机器dmmal.ini所有机器都保持一致。MAL_CHECK_INTERVAL 5MAL_CONN_FAIL_INTERVAL 15MAL_TEMP_PATH /data/dmdata/DAMENGMAL_BUF_SIZE 512MAL_SYS_BUF_SIZE 2048MAL_COMPRESS_LEVEL 0MAL_VPOOL_SIZE 128[MAL_INST1]MAL_INST_NAME GRP1_DW_01MAL_HOST 192.168.118.236MAL_PORT 65237MAL_INST_HOST 192.168.118.236MAL_INST_PORT 5237MAL_DW_PORT 55237MAL_INST_DW_PORT 35237MAL_LINK_MAGIC 1[MAL_INST2]MAL_INST_NAME GRP1_DW_02MAL_HOST 192.168.118.237MAL_PORT 65237MAL_INST_HOST 192.168.118.237MAL_INST_PORT 5237MAL_DW_PORT 55237MAL_INST_DW_PORT 35237MAL_LINK_MAGIC 1[MAL_INST3]MAL_INST_NAME GRP1_DW_03MAL_HOST 192.168.118.239MAL_PORT 65237MAL_INST_HOST 192.168.118.239MAL_INST_PORT 5237MAL_DW_PORT 55237MAL_INST_DW_PORT 35237MAL_LINK_MAGIC 1​​​​​​​1.13.1.4重启集群原主备数据库服务和守护服务​​​​​​​1.13.2动态配置-配置完成后不需要重启数据库服务动态配置dmmal.ini和dmarch.ini 文件。​​​​​​​1.13.2.1DISQL登录原主备库改dmmal.iniSF_MAL_CONFIG(1,0); SF_MAL_INST_ADD(MAL_INST3,GRP1_DW_03,192.168.118.239,65237,192.168.118.239,5237,55237,1,35237);SF_MAL_CONFIG_APPLY();SF_MAL_CONFIG(0,0);查询确认​​​​​​​1.13.2.2DISQL登录原主备库动态添加归档配置(1)关闭原主备集群中所有实例的守护进程和监视器关闭顺序为关闭监视器--关闭备库守护进程--关闭主库守护进程DmMonitorServiceGRP1 stopDmWatcherServiceGRP1 stop(2)配置归档--临时修改ALTER_MODE_STATUS允许用户手动修改模式状态--临时关闭守护进程活动状态检测允许用户手动修改模式状态SP_SET_PARA_VALUE(1, ALTER_MODE_STATUS, 1);SP_SET_PARA_VALUE(1, DW_INACTIVE_INTERVAL, 0);ALTER DATABASE MOUNT;--分别连接原主备所有实例动态添加dmarch.ini 中归档节点。--SQLALTER DATABASE ADD ARCHIVELOG DEST GRP1_DW_03,TYPE REALTIME;--SQLALTER DATABASE modify ARCHIVELOG DEST GRP1_DW_03,TYPE REALTIME,WAIT_APPLY0,ARCH_FAILOVER1;SQLALTER DATABASE ADD ARCHIVELOG DEST GRP1_DW_03,TYPE REALTIME,WAIT_APPLY0,ARCH_FAILOVER1;--手动修改原主备所有实例为OPEN状态必须先修改备库再修改主库否则可能会引发主备数据同步失败导致主库挂起。ALTER DATABASE OPEN FORCE;SP_SET_PARA_VALUE(1, ALTER_MODE_STATUS, 0);SP_SET_PARA_VALUE(1, DW_INACTIVE_INTERVAL, 60);--查询确认(3)启动原主备所有实例的守护进程DmWatcherServiceGRP1 start​​​​​​​1.14新机器C注册数据库服务和守护服务--注册数据库服务bash /data/dmdbms/script/root/dm_service_installer.sh -t dmserver -dm_ini /data/dmdata/DAMENG/dm.ini -p DAMENG-m mountsystemctl enable DmServiceDAMENG.service--注册守护进程服务并启动bash /data/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -watcher_ini /data/dmdata/DAMENG/dmwatcher.ini -p GRP1systemctl enable DmWatcherServiceGRP1systemctl start DmWatcherServiceGRP1​​​​​​​1.15监视器机器启动非确认监视服务和确认监视服务​​​​​​​1.15.1非确认监视器配置文件调整并启动检查​​​​​​​vi /data/dmdbms/data/DAMENG/dmmonitor_GRP1s.iniMON_DW_CONFIRM 0MON_LOG_PATH /data/dmdbms/logsMON_LOG_INTERVAL 60MON_LOG_FILE_SIZE 32MON_LOG_SPACE_LIMIT 2048[GRP1]MON_INST_OGUID 532318MON_DW_IP 192.168.118.236:55237MON_DW_IP 192.168.118.237:55237MON_DW_IP 192.168.118.239:55237​​​​​​​1.15.2确认监视器配置文件新增配置并启动服务vi /data/dmdbms/data/DAMENG/dmmonitor_GRP1.iniMON_DW_CONFIRM 1MON_LOG_PATH /data/dmdbms/logsMON_LOG_INTERVAL 60MON_LOG_FILE_SIZE 32MON_LOG_SPACE_LIMIT 2048[GRP1]MON_INST_OGUID 532318MON_DW_IP 192.168.118.236:55237MON_DW_IP 192.168.118.237:55237MON_DW_IP 192.168.118.239:55237启动确认监视器DmMonitorServiceGRP1 start