1.实验环境

三台VMware搭建的虚拟机，操作系统版本为麒麟v10-x86版本

数据库，实例名等参数要求如下：

2.搭建步骤

2.1 安装DM8数据库

安装前用户准备及其他准备：略。
预防文件打开数过小
vim /etc/security/limits.conf

dmdba soft nofile 102400
dmdba hard nofile 102400
root soft nofile 102400
root hard nofile 102400

预防图形化安装TMP空间不足解决办法

mkdir tmp
chown dmdba:dinstall /opt/tmp
export DM_INSTALL_TMPDIR=/opt/tmp

或使用非图形化方式安装
./DMInstall.bin -i

2.2 创建数据库并注册服务

主节点：
可以使用图像化界面工具或如下命令行创建数据数据库
./dminit path=/dm8/data db_name=DMDW
instance_NAME=GRP1_RT_01 sysdba_pwd=Dameng123 port_num=5246 PAGE_SIZE=16
注册服务
cd $DM_HOME/script/root
./dm_service_installer.sh -t dmserver -p GRP1_RT_01 -dm_ini
/dm8/data/DMDW/dm.ini
备节点：
可以使用图像化界面工具或如下命令行创建数据数据库
./dminit path=/dm8/data db_name=DMDW
instance_NAME=GRP1_RT_03 sysdba_pwd=Dameng123 port_num=5246 PAGE_SIZE=16
注册服务
cd $DM_HOME/script/root
./dm_service_installer.sh -t dmserver -p GRP1_RT_03 -dm_ini
/dm8/data/DMDW/dm.ini

2.3主节点停库全备

主节点：
ll /dm8/backup
mkdir -p /dm8/backup
./dmrman CTLSTMT="BACKUP DATABASE '/dm8/data/DMDW/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/BACKUP_FILE_01'"

2.4将全备文件拷贝至从节点进行恢复

从节点：
passwd dmdba
su - dmdba
ll /dm8/backup
mkdir -p /dm8/backup

主节点：
su - dmdba
scp -r /dm8/backup/* 192.168.205.132:/dm8/backup/

从节点：
./dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/DMDW/dm.ini' FROM BACKUPSET '/dm8/backup/BACKUP_FILE_01'"
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDW/dm.ini' FROM BACKUPSET '/dm8/backup/BACKUP_FILE_01'"
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDW/dm.ini' UPDATE DB_MAGIC"

2.5主节点修改或增加如下参数，并启动

2.5.1修改参数或添加参数

dm.ini

INSTANCE_NAME = GRP1_RT_01 
PORT_NUM = 5246
DW_INACTIVE_INTERVAL = 60 
ALTER_MODE_STATUS = 0 
ENABLE_OFFLINE_TS = 2 
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64

dmmal.ini

MAL_CHECK_INTERVAL = 60
MAL_CONN_FAIL_INTERVAL = 60
[MAL_INST1] 
MAL_INST_NAME = GRP1_RT_01 
MAL_HOST = 192.168.205.131
MAL_PORT = 55101
MAL_INST_HOST = 192.168.205.131
MAL_INST_PORT = 5246
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2] 
MAL_INST_NAME = GRP1_RT_03 
MAL_HOST = 192.168.205.132 
MAL_PORT = 55121 
MAL_INST_HOST = 192.168.205.132
MAL_INST_PORT = 5246 
MAL_DW_PORT = 65121 
MAL_INST_DW_PORT = 45121

dmarch.ini

[ARCHIVE_REALTIME] 
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RT_03
[ARCHIVE_LOCAL1] 
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch 
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

dmwatcher.ini

[GRP1] 
DW_TYPE = GLOBAL
DW_MODE = MANUAL 
DW_ERROR_TIME = 60 
INST_RECOVER_TIME = 60 
INST_ERROR_TIME = 60 
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 

2.5.2以mount方式启动主库

cd /dm8/bin
./dmserver /dm8/data/DMDW/dm.ini mount

2.5.3换窗口

cd /dm8/bin
./disql sysdba/Dameng123@localhost:5246

SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
sp_set_oguid(453331);
alter database primary;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

2.6备节点修改或增加如下参数，并启动

2.6.1修改参数或添加参数

/dm8/data/DMDW/dm.ini

INSTANCE_NAME = GRP1_RT_03 
PORT_NUM = 5246 
DW_INACTIVE_INTERVAL = 60 
ALTER_MODE_STATUS = 0  
ENABLE_OFFLINE_TS = 2 
MAL_INI = 1 
ARCH_INI = 1  
RLOG_SEND_APPLY_MON = 64 

dmmal.ini

MAL_CHECK_INTERVAL = 60 
MAL_CONN_FAIL_INTERVAL = 60  
[MAL_INST1] 
MAL_INST_NAME = GRP1_RT_01  
MAL_HOST = 192.168.205.131 
MAL_PORT = 55101 
MAL_INST_HOST = 192.168.205.131
MAL_INST_PORT = 5246 
MAL_DW_PORT = 65101  
MAL_INST_DW_PORT = 45101 
[MAL_INST2] 
MAL_INST_NAME = GRP1_RT_03
MAL_HOST = 192.168.205.132
MAL_PORT = 55121 
MAL_INST_HOST = 192.168.205.132
MAL_INST_PORT = 5246 
MAL_DW_PORT = 65121 
MAL_INST_DW_PORT = 45121 

dmarch.ini

[ARCHIVE_REALTIME] 
ARCH_TYPE = REALTIME 
ARCH_DEST = GRP1_RT_01  
[ARCHIVE_LOCAL1] 
ARCH_TYPE = LOCAL 
ARCH_DEST = /dm8/arch  
ARCH_FILE_SIZE = 128  
ARCH_SPACE_LIMIT = 0 

dmwatcher.ini

[GRP1] 
DW_TYPE = GLOBAL 
DW_MODE = MANUAL 
DW_ERROR_TIME = 60 
INST_RECOVER_TIME = 60 
INST_ERROR_TIME = 60  
INST_OGUID = 453331
INST_INI = /dm8/data/DMDW/dm.ini 
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver 
RLOG_APPLY_THRESHOLD = 0 

2.6.2以mount方式启动备库

cd /dm8/bin
./dmserver /dm8/data/DMDW/dm.ini mount

2.6.3换窗口

cd /dm8/bin
./disql sysdba/Dameng123@localhost:5246
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL>sp_set_oguid(453331);
SQL>alter database standby;
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

2.7启动守护

主库：
./dmwatcher /dm8/data/DMDW/dmwatcher.ini
备库：
./dmwatcher /dm8/data/DMDW/dmwatcher.ini

2.8验证

主库：
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./disql sysdba/Dameng123@localhost:5246
服务器[localhost:5246]:处于主库打开状态
登录使用时间 : 3.186(ms)
disql V8
SQL>

备库：
[root@localhost ~]# su - dmdba
上一次登录： 二 5月 9 01:37:06 CST 2023 pts/1 上
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./disql sysdba/Dameng123@localhost:5246
服务器[localhost:5246]:处于备库打开状态
登录使用时间 : 3.014(ms)
disql V8
SQL>

2.9配置监控

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
[GRP1]
MON_INST_OGUID = 453331
MON_DW_IP = 192.168.205.131:65101
MON_DW_IP = 192.168.205.132:65121

cd /dm8/bin
./dmmonitor /dm8/dmmonitor.ini

2.10监控常用命令

show
login
switchover
switchover

2.11 守护关停顺序

2.11.1退出并关闭dmmonitor

logout
exit

2.11.2关主机库

exit

2.11.3关备机库

exit

2.11.4关主机dmwatcher

exit

2.11.5关备机dmwatcher

exit