一、基础环境
1.麒麟V10
2.达梦8
3.两台服务器（主，从，监控（主））
二、安装达梦8
1.创建用户组
groupadd dinstall
2.创建用户
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
3.更改用户 dmdba 的密码
passwd dmdba
4.创建数据库安装目录
mkdir /dm8
5.dmdba用户赋予文件权限
chown dmdba:dinstall /dm8
6.创建镜像文件挂载目录
mkdir /mnt/dm
7.挂载文件
mount /opt/dm8_20210818_x86_rh6_64_ent_8.4.2.18_pack14.iso /mnt/dm
8.配置limits.conf
vi /etc/security/limits.conf
#末尾添加
dmdba soft nofile 65535
dmdba hard nofile 65535
root soft nofile 65535
root hard nofile 65535
#配置生效
ulimit -a
9.切换到dmdba用户
su - dmdba
10.进入挂载目录
cd /mnt/dm
11.执行安装命令
./DMInstall.bin -i
12.安装截图
Snipaste_2024-11-20_20-00-35.png
13.切换到root用户并执行脚本
su root
/dm8/script/root/root_installer.sh
三、创建数据库
1.创建数据库CASE_SENSITIVE=0（不区分大小写）UNICODE_FLAG=1（uft8-1）
cd /dm8/bin
（主库）
./dminit path=/dm8/data db_name=DAMENG instance_name=DMSERVER port_num=5236 sysdba_pwd=mcc5@sv102015 CASE_SENSITIVE=0 PAGE_SIZE=32 EXTENT_SIZE=32 LOG_SIZE=1024 UNICODE_FLAG=1
（从库）
./dminit path=/dm8/data db_name=DAMENG instance_name=DMSERVER1 port_num=5236 sysdba_pwd=mcc5@sv102015 CASE_SENSITIVE=0 PAGE_SIZE=32 EXTENT_SIZE=32 LOG_SIZE=1024 UNICODE_FLAG=1
2.参数含义
./dminit help
四、注册服务
1.注册服务
cd /dm8/script/root
./dm_service_installer.sh -t dmserver -p DMSERVER -dm_ini /dm8/data/DAMENG/dm.ini
2.启动服务
systemctl start DmServiceDMSERVER
五、配置主从
1.启动归档(主从均执行)
ALTER DATABASE MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE ADD ARCHIVELOG 'DEST=/dm8/dmdba/dmarch, TYPE=LOCAL, FILE_SIZE=2048, SPACE_LIMIT=102400';
ALTER DATABASE OPEN;
# 查看是否开启归档
select arch_mode from v$database;
2.停止主库从库，备份主库，从库还原主库
cd /dm8/bin
./dmrman
# 备份主库
backup database '/dm8/data/DAMENG/dm.ini' full to DAMENG_full01 backupset '/dm8/dmback/DAMENG_full01'
# 拷贝到从库
scp -r /dm8/dmback/DAMENG_full01 10.9.102.14:/dm8/dmback/
# 从库还原主库
chown -R dmdba:dinstall /dm8
su - dmdba
restore database '/dm8/data/DAMENG/dm.ini' from backupset '/dm8/dmback/DAMENG_full01'
recover database '/dm8/data/DAMENG/dm.ini' from backupset '/dm8/dmback/DAMENG_full01'
recover database '/dm8/data/DAMENG/dm.ini' update db_magic
3.配置dm.ini (主从一致)
ALTER_MODE_STATUS = 0 #不允许手工方式修改实例模式/状态/OGUID
ENABLE_OFFLINE_TS = 2 #不允许备库 OFFLINE 表空间
MAL_INI = 1 #打开 MAL 系统
ARCH_INI = 1 #打开归档配置
4.配置dmmal.ini（新建）,主从一致
MAL_CHECK_INTERVAL= 5
MAL_CONN_FAIL_INTERVAL= 5
[MAL_INST1]
MAL_INST_NAME= DMSERVER
MAL_HOST= 10.9.102.13
MAL_PORT= 61141
MAL_INST_HOST= 10.9.102.13
MAL_INST_PORT= 5236
MAL_DW_PORT= 52141
MAL_INST_DW_PORT= 33141
[MAL_INST2]
MAL_INST_NAME= DMSERVER1
MAL_HOST= 10.9.102.14
MAL_PORT= 61141
MAL_INST_HOST= 10.9.102.14
MAL_INST_PORT= 5236
MAL_DW_PORT= 52141
MAL_INST_DW_PORT= 33141
5.配置 dmarch.ini
# 主库
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSERVER1
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/dmarch
ARCH_FILE_SIZE = 2048
ARCH_SPACE_LIMIT = 102400
ARCH_FLUSH_BUF_SIZE = 2
ARCH_HANG_FLAG = 1
#从库
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSERVER
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/dmarch
ARCH_FILE_SIZE = 2048
ARCH_SPACE_LIMIT = 102400
ARCH_FLUSH_BUF_SIZE = 2
ARCH_HANG_FLAG = 1
六、配置dmwatcher.ini(新建) 主从一致
[GRP1]
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/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
七、配置dmmonitor.ini（新建），主库配置,监控配置文件
MON_DW_Confirm = 0
MON_LOG_PATH = /dm8/dmdba/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1]
MON_INST_OGUID= 453331
MON_DW_IP = 10.9.102.13:52141
MON_DW_IP = 10.9.102.14:52141
八、以 mount 方式启动主备库
cd /dm8/bin
./dmserver /dm8/data/DAMENG/dm.ini mount
# 主：
./disql SYSDBA/SYSDBA
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);
# 备：
./disql SYSDBA/SYSDBA
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
sp_set_oguid(453331);
alter database standby;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
九、注册守护进程服务(主从服务器)
./dm_service_installer.sh -t dmwatcher -p DMSERVER -watcher_ini /dm8/data/DAMENG/dmwatcher.ini
# 监控注册服务(仅主库)
./dm_service_installer.sh -t dmmonitor -p DAMENG -monitor_ini /dm8/data/DAMENG/dmmonitor.ini
十、启动数据库
主备集群重启有顺序要求：
关闭监视器：systemctl stop DmMonitorServiceDAMENG
关闭主库守护进程：systemctl stop DmWatcherServiceDAMENG
关闭备库守护进程：systemctl stop DmWatcherServiceDAMENG
关闭主库实例：systemctl stop DmServiceDAMENG
关闭备库实例：systemctl stop DmServiceDAMENG
启动主库实例：systemctl start DmServiceDAMENG
启动备库实例：systemctl start DmServiceDAMENG
启动主库守护进程：systemctl start DmWatcherServiceDAMENG
启动备库守护进程：systemctl start DmWatcherServiceDAMENG
启动监视器：systemctl start DmMonitorServiceDAMENG
#查看监视情况（主）
cd /dm8/bin
./dmmonitor /data/dmdbms/data/DAMENG/dmmonitor.ini
show global info
