环境说明
IP 地址 192.168.56.5
端口 5236
安装包目录:
/opt/dmsetup/dm8_20210630_x86_rh6_64_ent_8.1.2.18_pack7.iso
key文件:dm79048287.key
key信息:(安装软件时读取的KEY信息)
请输入Key文件的路径地址 [dm.key]:
部署机账号信息:
IP:9.23.64.79
root:EErrttyy#1010
dmdba:Da0722#Meng
SYSDBA:SYSDBA
检查部署机配置
df -h
free -h
cat /etc/redhat-release
getconf LONG_BIT
lscpu
uname -a
cat /proc/version
gcc --version
ldd --version
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
部署机配置信息:
磁盘:根-46G,/data-500G
内存:物理-32G,SWAP-15G
系统:CentOS Linux release 7.4.1708 (Core)
位数:64
CPU:Intel® Xeon® CPU E7-4820 v4 @ 2.00GHz(16核心)
架构:x86
目录信息
安装包:
/opt/dmsetup
达梦软件:
/opt/dmdbms
数据目录:
/data/dmdata
归档路径:
/data/dmarch
单个文件1024M,上限10G
备份路径:
/data/dmbak
sqllog路径:
/data/dmdata/DAMENG/dmsql_log
单个文件1024M,上限10G
备份配置信息
备份目录:
/data/dmbak
每周日晚2:00全备
每周除周日以外,晚1点执行差异增量备份
每天凌晨3点执行搜集统计信息和删除14天前的增量以及14天前的全量
部署过程
用户:
groupadd dinstall
useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
passwd dmdba
Da0722#Meng
准备安装包:
mkdir /opt/dmsetup
chown dmdba.dinstall /opt/dmsetup
创建目录:(授权时务必检查【-R】参数的使用是否正确!!!)
mkdir -p /opt/dmdbms
chown dmdba.dinstall /opt/dmdbms
chmod 775 /opt/dmdbms
mkdir -p /data/dmdata
chown dmdba.dinstall /data/dmdata
chmod 775 /data/dmdata
mkdir -p /data/dmbak
chown dmdba.dinstall /data/dmbak
chmod 775 /data/dmbak
mkdir -p /data/dmarch
chown dmdba.dinstall /data/dmarch
chmod 775 /data/dmarch
修改系统配置:
关闭防火墙
systemctl stop firewalld.service
systemctl status firewalld.service
内核参数
vi /etc/sysctl.conf
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
vm.overcommit_memory = 1
vm.swappiness = 0
vm.dirty_background_ratio = 3
vm.dirty_ratio = 80
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
生效:
sysctl -p
sysctl -p /etc/sysctl.conf
sysctl -q vm.swappiness
资源限制
ulimit -n 65536
vi /etc/security/limits.conf
-
soft nice 0
-
hard nice 0
-
soft as unlimited
-
hard as unlimited
-
soft fsize unlimited
-
hard fsize unlimited
-
soft nproc 65536
-
hard nproc 65536
-
soft nofile 65536
-
hard nofile 65536
-
soft core unlimited
-
hard core unlimited
-
soft data unlimited
-
hard data unlimited
vi /etc/security/limits.d/20-nproc.conf //实际文件可能会不同
-
soft nproc 65536
vi /etc/profile
ulimit -SHn 65536
调整LOGIN
vi /etc/pam.d/login
session required /lib64/security/pam_limits.so
session required pam_limits.so
关闭SElinux
vi /etc/sysconfig/selinux
SELINUX=disabled
关闭numa和透明大页:
vi /etc/default/grub
在GRUB_CMDLINE_LINUX后添加
numa=off transparent_hugepage=never
重新生成配置文件:
grub2-mkconfig -o /etc/grub2.cfg
重启生效(慎重)–如系统中已有业务正在运行,请申请重启窗口,谨慎操作。
验证:
cat /proc/cmdline
验证transparent_hugepage=never:
cat /sys/kernel/mm/transparent_hugepage/enabled
安装数据库软件:
chown -R dmdba.dinstall /opt/dmsetup/dm8_20210630_x86_rh6_64_ent_8.1.2.18_pack7.iso
chmod -R 775 /opt/dmsetup/dm_soft_8.1.2.18
cd /opt/dmsetup/
mount -o loop dm8_20210630_x86_rh6_64_ent_8.1.2.18_pack7.iso /mnt
su - dmdba
cd /mnt
./DMInstall.bin -i
安装前小结
安装位置: /opt/dmdbms
所需空间: 1178M
可用空间: 37G
版本信息: 企业版
有效日期: 2022-03-25
安装类型: 典型安装
root用户执行:
/opt/dmdbms/script/root/root_installer.sh
初始化实例:
su - dmdba
cd /opt/dmdbms/bin
./dminit PATH=/data/dmdata PAGE_SIZE=32 EXTENT_SIZE=32 LOG_SIZE=2048 CHARSET=1 LENGTH_IN_CHAR=Y
环境变量:
vi ~/.bash_profile
export PATH=/opt/dmdbms/bin:$PATH
source ~/.bash_profile
注册服务:
su - root
cd /opt/dmdbms/script/root/
./dm_service_installer.sh -t dmserver -p DMSERVER -dm_ini /data/dmdata/DAMENG/dm.ini
配置数据库
修改DM.INI参数:
su - dmdba
vi /data/dmdata/DAMENG/dm.ini
COMPATIBLE_MODE=2 --兼容Oracle
SVR_LOG=1 --开启异步SQL日志
ARCH_INI=1 --开启归档
配置归档:
vi /data/dmdata/DAMENG/dm.ini
ARCH_INI=1
vi /data/dmdata/DAMENG/dmarch.ini
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /data/dmarch
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 10240
配置SQL异步日志:
vi /data/dmdata/DAMENG/dm.ini
SVR_LOG=1
vi /data/dmdata/DAMENG/sqllog.ini
BUF_TOTAL_SIZE = 10240 #SQLs Log Buffer Total Size(K)(1024~1024000)
BUF_SIZE = 1024 #SQLs Log Buffer Size(K)(50~409600)
BUF_KEEP_CNT = 6 #SQLs Log buffer keeped count(1~100)
[SLOG_ALL]
FILE_PATH = /data/dmdata/DAMENG/dmsql_log
PART_STOR = 0
SWITCH_MODE =2
SWITCH_LIMIT = 256
ASYNC_FLUSH = 1
FILE_NUM = 8
ITEMS = 0
SQL_TRACE_MASK = 1
MIN_EXEC_TIME = 0
USER_MODE = 0
USERS =
mkdir /data/dmdata/DAMENG/dmsql_log
启动数据库:
/opt/dmdbms/bin/DmServiceDMSERVER start
验证兼容参数,异步日志和归档模式:
select * from v$dm_ini where para_name = ‘COMPATIBLE_MODE’;
select * from v$dm_ini where para_name = ‘SVR_LOG’;
select ARCH_MODE from v$database;
select * from v$dm_ini where para_name = ‘PWD_POLICY’;
修改sysdba密码:
alter user sysdba identified by “SYSDBA”;
备份目录:
/data/dmbak
备份配置:
配置之后需要执行一次全备,用于每日增备的基备份。
backup database full backupset ‘full_20210826’
开启代理环境:
call SP_INIT_JOB_SYS(1);
每日除周日1:00增备:
call SP_CREATE_JOB(‘bakadd’,1,0,’’,0,0,’’,0,‘每周除周日凌晨1点增量备份’);
call SP_JOB_CONFIG_START(‘bakadd’);
call SP_ADD_JOB_STEP(‘bakadd’, ‘bakall_work’, 6, ‘11020000/data/dmbak|/data/dmbak’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘bakadd’, ‘bakadd_time01’, 1, 2, 1, 63, 0, ‘01:00:00’, NULL, ‘2021-08-03 14:31:06’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘bakadd’);
每周日2:00全备:
call SP_CREATE_JOB(‘bakall’,1,0,’’,0,0,’’,0,‘每周的周日凌晨2点全量备份’);
call SP_JOB_CONFIG_START(‘bakall’);
call SP_ADD_JOB_STEP(‘bakall’, ‘bakall_work’, 6, ‘01020000/data/dmbak’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘bakall’, ‘bakall_time01’, 1, 2, 1, 64, 0, ‘02:00:00’, NULL, ‘2019-01-01 01:01:01’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘bakall’);
每天凌晨3点执行删除超过14天的备份
call SP_CREATE_JOB(‘DEL_BAK’,1,0,’’,0,0,’’,0,‘每天凌晨3点删除超过14天的备份。’);
call SP_JOB_CONFIG_START(‘DEL_BAK’);
call SP_JOB_SET_EP_SEQNO(‘DEL_BAK’, 0);
call SP_ADD_JOB_STEP(‘DEL_BAK’, ‘delbak_work’, 0, ‘SF_BAKSET_BACKUP_DIR_ADD(’‘DISK’’,’’/data/dmbak’’);
CALL SP_DB_BAKSET_REMOVE_BATCH(’‘DISK’’,SYSDATE-14);’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘DEL_BAK’, ‘delbak_time01’, 1, 1, 1, 0, 0, ‘03:00:00’, NULL, ‘2021-08-03 14:41:27’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘DEL_BAK’);
配置完作业后手动做一个全库备份##
详细手册可参考达梦官方网站,或登录社区进行交流学习
https://eco.dameng.com