DM集群部署过程

1.集群搭建
安装
groupadd dinstall
useradd -g dinstall dmdba
passwd dmdba
/etc/security/目录下的 limits.conf
dmdba soft nofile 65536
dmdba hard nofile 65536
mkdir -p /dm8
chown -R dmdba.dinstall /dm8
cd /stage
mount -o loop dm8_20201107_x86_rh7_64_ent_8.1.1.144.iso /mnt
xhost +
.bash_profile
export DISPLAY=:0.0
sysdba
SYSDBA

创建实例及数据库
dminit path=/dm8/data DB_NAME=DMDW instance_name=GRP1_RT_01 port_num=5246
./dminit PATH=/dm8/data DB_NAME=DMDB INSTANCE_NAME=DBSERVER PORT_NUM=5238 SYSDBA_PWD=Dameng123 EXTENT_SIZE=16 PAGE_SIZE=8 LOG_PATH=/dm8/data/DMDB/DATA01.log LOG_SIZE=300 LOG_PATH=/dm8/data/DMDB/DATA02.log LOG_SIZE=300
LOG_PATH=/dm8/data/DMDB/DATA03.log LOG_SIZE=300

使用root用户创建systemd服务
/dm8/script/root/dm_service_installer.sh -t dmserver -p GRP1_RT_01 -dm_ini /dm8/data/DMDW/dm.ini
systemctl start DmServiceGRP1_RT_01.service

备份及恢复(操作前先关数据库服务)
dmrman CTLSTMT="BACKUP DATABASE '/dm8/data/DMDW/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/'"
dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/DMDW/dm.ini' FROM BACKUPSET '/dm8/backup'"
dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDW/dm.ini' FROM BACKUPSET '/dm8/backup'"
dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDW/dm.ini' UPDATE DB_MAGIC"
dm.ini
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
dmmal.ini
MAL_CHECK_INTERVAL=5
MAL_CONN_FAIL_INTERVAL=5
[MAL_INST1]
MAL_INST_NAME=GRP1_RT_01
MAL_HOST=192.168.230.52
MAL_PORT=55101
MAL_INST_HOST=192.168.230.52
MAL_INST_PORT=5236
MAL_DW_PORT=65101
MAL_INST_DW_PORT=45101
[MAL_INST2]
MAL_INST_NAME=GRP1_RT_02
MAL_HOST=192.168.230.53
MAL_PORT=55101
MAL_INST_HOST=192.168.230.53
MAL_INST_PORT=5236
MAL_DW_PORT=65101
MAL_INST_DW_PORT=45101

dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RT_02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

dmwatcher.ini
[GRP_SVR]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /dm8/data/DMDW/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

./dmserver /dm8/data/DMDW/dm.ini mount
disql sysdba/SYSDBA:5246
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL>sp_set_oguid(453331);
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
SQL>alter database primary/standby;

cd /dm8/script/root
./dm_service_installer.sh -t dmserver -p GRP1_RT_01 -dm_ini /dm8/data/DMDW/dm.ini (DB)
./dm_service_installer.sh -t dmwatcher -p DMWATCHER -watcher_ini /dm8/data/DMDW/dmwatcher.ini -m mount -p GRP1_RT_01

启动守护进程

主库： ./dmwatcher /dm8/data/DMDW/dmwatcher.ini
备库：./dmwatcher /dm8/data/DMDW/dmwatcher.ini
如果在OS中已经注册守护进程，可以通过systemctl启动。
主库：systemctl start DmWatcherServiceGRP1_RT_01
备库：systemctl start DmWatcherServiceGRP1_RT_02

监视器：

监视器可以运行在独立的服务器，也可以在主库或者备库服务器上运行。此测试在备库上启动监视器进程。
/dm8/bin/dmmonitor.ini
MON_DW_CONFIRM = 1
MON_LOG_PATH = /dm8/data/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP_SVR] --此组名称需要跟dmwatcher服务配置文件中的组名称保持一致
MON_INST_OGUID = 453331
MON_DW_IP = 192.168.0.105:65101
MON_DW_IP = 192.168.0.106:65121
启动监视器：
./dmmonitor /dm8/data/DMDW/dmmonitor.ini

此命令窗口为前置，可以在此输入命令如show查看主库状态。 help查看所有帮助

生产库一般需要注册此服务，登录root
cd /dm8/script/root
./dm_service_installer.sh -t dmmonitor -p DMMONITOR -monitor_ini /dm8/data/DMDW/dmmonitor.ini
systemctl start DmMonitorServiceDMMONITOR
测试switchover
a)启动dmmonitor ： dmmonitor /dm8/data/DMDW/dmmonitor.ini
login
username: sysdba
password： dameng123 (不显示) 确认登陆成功
[monitor] 2025-07-06 15:39:40: 登录监视器成功!
choose switchover GRP_SVR
switchover GRP_SVR.GRP1_RT_02

作者