轻松搭建DM8数据守护集群

准备好三台服务器，保证网络相通，均关闭防火墙，例如：

主机：192.168.10.5
备机：192.168.10.6
监视器：192.168.10.7

关闭主机数据库服务

/dm8/bin/DmServiceDMSERVER stop

备份主库

/dm8/bin/dmrman CTLSTMT="backup database '/dm8/data/DAMENG/dm.ini' full to fb20250923 backupset '/dm8/Backup/fb20250923'"

将备份集拷贝到备机

scp -r /dm8/Backup/fb20250923 dmdba@192.168.10.6:/dm8/Backup/

从/dm8/samples/ini_script/UTF-8/拷贝dmmal.ini和dmwatcher.ini到/dm8/data/DAMENG/目录下，并作修改

dm.ini

ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1

dmmal.ini:

MAL_CHECK_INTERVAL = 10
MAL_CONN_FAIL_INTERVAL = 10  

[MAL_INST1]
MAL_INST_NAME = DMSERVER
MAL_HOST = 192.168.10.5
MAL_PORT = 45236           
MAL_INST_HOST = 192.168.10.5 
MAL_INST_PORT = 5236                    
MAL_DW_PORT = 45237                   
MAL_INST_DW_PORT = 45238

[MAL_INST2]
MAL_INST_NAME = DMSERVER2
MAL_HOST = 192.168.10.6
MAL_PORT = 45236           
MAL_INST_HOST = 192.168.10.6 
MAL_INST_PORT = 5236                    
MAL_DW_PORT = 45237                   
MAL_INST_DW_PORT = 45238

dmwatcher.ini

[GROUP_A]   
DW_TYPE = GLOBAL                 
DW_MODE = AUTO
DW_ERROR_TIME = 15
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 15
INST_OGUID = 123456789
INST_INI = /dm8/data/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver 
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

dmarch.ini 增加如下内容：

[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSERVER2

将主机启动到mount状态

/dm8/bin/dmserver /dm8/data/DAMENG/dm.ini mount

在备机上使用命令创建一个数据库DMSERVER2

/dm8/bin/dminit PATH=/dm8/data DB_NAME=DAMENG INSTANCE_NAME=DMSERVER2 PORT_NUM=5236 CHARSET=1 SYSDBA_PWD=Dameng123 SYSAUDITOR_PWD=Dameng123

在备机上使用备份集还原恢复数据库并更新DB_MAGIC，可使用console来完成

/dm8/bin/dmrman CTLSTMT="restore database '/dm8/data/DAMENG/dm.ini' from backupset '/dm8/Backup/fb20250923'"
/dm8/bin/dmrman CTLSTMT="recover database '/dm8/data/DAMENG/dm.ini' from backupset '/dm8/Backup/fb20250923'"
/dm8/bin/dmrman CTLSTMT="recover database '/dm8/data/DAMENG/dm.ini' update db_magic"

拷贝主机的dmmal.ini、dmwatcher.ini和dmarch.ini到备机/dm8/data/DAMENG/目录下

scp dmmal.ini dmwatcher.ini dmarch.ini dmdba@192.168.10.6:/dm8/data/DAMENG

修改备机上的dm.ini、dmarch.ini文件

dm.ini 修改以下参数：

ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1

dmarch.ini 修改为如下内容：

[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSERVER

将备机启动到mount状态

/dm8/bin/dmserver /dm8/data/DAMENG/dm.ini mount

分别设置主、备机的OGUID为相同数字，然后设置主机为primary，备机为standby

/dm8/bin/disql sysdba/Dameng123
sp_set_oguid(123456789);
主机：
alter database primary;
备机：
alter database standby;

分别启动主、备机的dmwatcher服务

./dmwatcher /dm8/data/DAMENG/dmwatcher.ini

创建监视器配置文件

mv /dm8/samples/ini_script/UTF-8/dmmonitor_example.ini /dm8/data/dmmonitor.ini

vim /dm8/data/DAMENG/dmmonitor.ini

MON_DW_CONFIRM = 0
MON_LOG_PATH = /dm8/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GROUP_A]
MON_INST_OGUID = 123456789                      
MON_DW_IP = 192.168.10.5:45237
MON_DW_IP = 192.168.10.6:45237

启动监视器

/dm8/bin/dmmonitor /dm8/data/dmmonitor.ini

注册备机数据库服务

备机：
/dm8/script/root/dm_service_installer.sh -t dmserver -p DMSERVER2 -dm_ini /dm8/data/DAMENG/dm.ini

16、注册主、备机的数据守护服务，root账户下执行:

主机：
/dm8/script/root/dm_service_installer.sh -t dmwatcher -p DMSERVER -watcher_ini /dm8/data/DAMENG/dmwatcher.ini
备机：
/dm8/script/root/dm_service_installer.sh -t dmwatcher -p DMSERVER2 -watcher_ini /dm8/data/DAMENG/dmwatcher.ini

注册监视器服务

监视器：
/dm8/script/root/dm_service_installer.sh -t dmmonitor -p MONITOR -monitor_ini /dm8/data/dmmonitor.ini

轻松搭建DM8数据守护集群

作者