达梦数据库运维新策略：达梦数据库主备集群节点动态增加技巧

1.环境信息

1.1.环境信息概览

1.2.IP规划详情

2.动态增加实时备库

新加节点前提，需部署好一主一备环境，并且数据库状态运行正常。

2.1.备份数据库

1.对主库进行联机备份操作

BACKUP DATABASE BACKUPSET '/dmback/dbfull20251106';

备份完成后信息如下所示：

[dmdba@OADB2 ~]$ disql SYSDBA/Dameng123服务器[LOCALHOST:5236]:处于主库打开状态登录使用时间 : 7.287(ms)disql V8SQL> BACKUP DATABASE BACKUPSET '/dmback/dbfull20251106';操作已执行已用时间: 00:00:05.401. 执行号:801.SQL>

2.初始化备机数据库

cd /home/dmdba/dmdbms/bin/./dminit PATH=/dmdata EXTENT_SIZE=32 PAGE_SIZE=32 LOG_SIZE=2048  DB_NAME=OADB INSTANCE_NAME=OADB SYSDBA_PWD=Dameng123 SYSAUDITOR_PWD=Dameng123

3.还原恢复新增备库

拷贝生成的备份集目录 bakfull_20250318 到 25.173上/dmdata目录

[dmdba@OADB2 dmback]$ scp -r bakfull_20250318 dmdba@192.168.25.173:/dmdataThe authenticity of host '192.168.25.173 (192.168.25.173)' can't be established.ECDSA key fingerprint is SHA256:xiUOmIG0qzMh3CxGli0ZoMpRYKol3LYyQDLrRpGAqEg.Are you sure you want to continue connecting (yes/no/[fingerprint])? yesWarning: Permanently added '192.168.25.173' (ECDSA) to the list of known hosts.Authorized users only. All activities may be monitored and reported.dmdba@192.168.25.173's password: bakfull_20250318.bak                                                                                                  100%   28MB  67.0MB/s   00:00    bakfull_20250318.meta                                                                                                 100%  110KB  61.1MB/s   00:00    [dmdba@OADB2 dmback]$

2.2.使用备份恢复备库

使用 DMRMAN 工具脱机还原

./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/OADB/dm.ini' FROM BACKUPSET '/dmdata/bakfull_20250318'"./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/OADB/dm.ini' FOR STANDBY FROM BACKUPSET '/dmdata/bakfull_20250318'"./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/OADB/dm.ini' UPDATE DB_MAGIC"

执行语句恢复后结果如下：

[dmdba@dmdrs-192-168-25-173 bin]$ ./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/OADB/dm.ini' FROM BACKUPSET '/dmdata/bakfull_20250318'"dmrman V8RESTORE DATABASE '/dmdata/OADB/dm.ini' FROM BACKUPSET '/dmdata/bakfull_20250318'file dm.key not found, use default license![Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]                                 restore successfully.time used: 00:00:02.491[dmdba@dmdrs-192-168-25-173 bin]$ ./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/OADB/dm.ini' FOR STANDBY FROM BACKUPSET '/dmdata/bakfull_20250318'"dmrman V8RECOVER DATABASE '/dmdata/OADB/dm.ini' FOR STANDBY FROM BACKUPSET '/dmdata/bakfull_20250318'file dm.key not found, use default license!==============================Error Stack==============================DM[603]:备份集[/dmdata/bakfull_20250318]备份过程中未产生日志=======================================================================recover successfully!time used: 358.671(ms)[dmdba@dmdrs-192-168-25-173 bin]$ ./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/OADB/dm.ini' UPDATE DB_MAGIC"dmrman V8RECOVER DATABASE '/dmdata/OADB/dm.ini' UPDATE DB_MAGICfile dm.key not found, use default license!recover successfully!time used: 00:00:01.083[dmdba@dmdrs-192-168-25-173 bin]$

2.3.配置新备库

2.3.1.配置 dm.ini

在第三台机器上配置备库的实例名