1、关闭防火墙
[root@localhost ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
重启永久生效
[root@localhost ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: man:firewalld(1)
2、创建相关用户组和用户
[root@localhost ~]# groupadd -g 5000 dinstall
[root@localhost ~]# useradd -g dinstall -m dmdba
3、修改配置
[root@localhost ~]# ulimit -n 65536
[root@localhost ~]# vi /etc/security/limits.conf
dmdba hard nofile 65536
dmdba soft nofile 65536
dmdba hard stack 32768
dmdba soft stack 16384
4、通过本地上传安装包至opt目录
[root@localhost security]# cd /opt
[root@localhost opt]#
[root@localhost opt]# ls
dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso dm8_20220720_x86_rh7_64_ent.zip
dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso_SHA256.txt rh
[root@localhost opt]# ll
total 1857020
-rw-r--r--. 1 root root 957816832 Aug 19 2022 dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso
-rw-r--r--. 1 root root 168 Aug 19 2022 dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso_SHA256.txt
-rw-r--r--. 1 root root 943764329 Jun 14 02:49 dm8_20220720_x86_rh7_64_ent.zip
drwxr-xr-x. 2 root root 6 Jun 18 2018 rh
5、挂载镜像
[root@localhost opt]# mount -o loop /opt/dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso /mnt
mount: /dev/loop0 is write-protected, mounting read-only
6、创建目录
[root@localhost /]# mkdir /dm8
[root@localhost /]# ll
total 22
lrwxrwxrwx. 1 root root 7 Jun 14 02:08 bin -> usr/bin
dr-xr-xr-x. 4 root root 4096 Jun 14 02:17 boot
drwxr-xr-x. 19 root root 3300 Jun 14 02:51 dev
drwxr-xr-x. 2 root root 6 Jun 14 02:51 dm8
drwxr-xr-x. 144 root root 8192 Jun 14 02:46 etc
drwxr-xr-x. 4 root root 30 Jun 14 02:45 home
lrwxrwxrwx. 1 root root 7 Jun 14 02:08 lib -> usr/lib
lrwxrwxrwx. 1 root root 9 Jun 14 02:08 lib64 -> usr/lib64
drwxr-xr-x. 2 root root 6 Dec 15 2017 media
dr-xr-xr-x. 1 root root 2048 Jul 20 2022 mnt
drwxr-xr-x. 3 root root 178 Jun 14 02:49 opt
dr-xr-xr-x. 288 root root 0 Jun 14 02:16 proc
dr-xr-x---. 4 root root 225 Jun 14 02:39 root
drwxr-xr-x. 43 root root 1320 Jun 14 02:38 run
lrwxrwxrwx. 1 root root 8 Jun 14 02:08 sbin -> usr/sbin
drwxr-xr-x. 2 root root 6 Dec 15 2017 srv
dr-xr-xr-x. 13 root root 0 Jun 14 02:17 sys
drwxrwxrwt. 18 root root 4096 Jun 14 02:51 tmp
drwxr-xr-x. 13 root root 155 Jun 14 02:08 usr
drwxr-xr-x. 20 root root 282 Jun 14 02:17 var
授予目录正确的权限
[root@localhost /]# chown dmdba:dinstall -R /dm8/
[root@localhost /]# ll
total 22
lrwxrwxrwx. 1 root root 7 Jun 14 02:08 bin -> usr/bin
dr-xr-xr-x. 4 root root 4096 Jun 14 02:17 boot
drwxr-xr-x. 19 root root 3300 Jun 14 02:51 dev
drwxr-xr-x. 2 dmdba dinstall 6 Jun 14 02:51 dm8
drwxr-xr-x. 144 root root 8192 Jun 14 02:46 etc
drwxr-xr-x. 4 root root 30 Jun 14 02:45 home
lrwxrwxrwx. 1 root root 7 Jun 14 02:08 lib -> usr/lib
lrwxrwxrwx. 1 root root 9 Jun 14 02:08 lib64 -> usr/lib64
drwxr-xr-x. 2 root root 6 Dec 15 2017 media
dr-xr-xr-x. 1 root root 2048 Jul 20 2022 mnt
drwxr-xr-x. 3 root root 178 Jun 14 02:49 opt
dr-xr-xr-x. 288 root root 0 Jun 14 02:16 proc
dr-xr-x---. 4 root root 225 Jun 14 02:39 root
drwxr-xr-x. 43 root root 1320 Jun 14 02:38 run
lrwxrwxrwx. 1 root root 8 Jun 14 02:08 sbin -> usr/sbin
drwxr-xr-x. 2 root root 6 Dec 15 2017 srv
dr-xr-xr-x. 13 root root 0 Jun 14 02:17 sys
drwxrwxrwt. 18 root root 4096 Jun 14 02:51 tmp
drwxr-xr-x. 13 root root 155 Jun 14 02:08 usr
drwxr-xr-x. 20 root root 282 Jun 14 02:17 var
[root@localhost /]# chmod -R 775 /dm8
[root@localhost /]# ll
total 22
lrwxrwxrwx. 1 root root 7 Jun 14 02:08 bin -> usr/bin
dr-xr-xr-x. 4 root root 4096 Jun 14 02:17 boot
drwxr-xr-x. 19 root root 3300 Jun 14 02:51 dev
drwxrwxr-x. 2 dmdba dinstall 6 Jun 14 02:51 dm8
drwxr-xr-x. 144 root root 8192 Jun 14 02:46 etc
drwxr-xr-x. 4 root root 30 Jun 14 02:45 home
lrwxrwxrwx. 1 root root 7 Jun 14 02:08 lib -> usr/lib
lrwxrwxrwx. 1 root root 9 Jun 14 02:08 lib64 -> usr/lib64
drwxr-xr-x. 2 root root 6 Dec 15 2017 media
dr-xr-xr-x. 1 root root 2048 Jul 20 2022 mnt
drwxr-xr-x. 3 root root 178 Jun 14 02:49 opt
dr-xr-xr-x. 288 root root 0 Jun 14 02:16 proc
dr-xr-x---. 4 root root 225 Jun 14 02:39 root
drwxr-xr-x. 43 root root 1320 Jun 14 02:38 run
lrwxrwxrwx. 1 root root 8 Jun 14 02:08 sbin -> usr/sbin
drwxr-xr-x. 2 root root 6 Dec 15 2017 srv
dr-xr-xr-x. 13 root root 0 Jun 14 02:17 sys
drwxrwxrwt. 18 root root 4096 Jun 14 02:51 tmp
drwxr-xr-x. 13 root root 155 Jun 14 02:08 usr
drwxr-xr-x. 20 root root 282 Jun 14 02:17 var
7、安装数据库
[dmdba@localhost mnt]$ ./DMInstall.bin -i
Please select the installer language (E/e:English C/c:Chinese) [E/e]:c
解压安装程序.........
欢迎使用达梦数据库安装程序
是否输入Key文件路径? (Y/y:是 N/n:否) [Y/y]:n
是否设置时区? (Y/y:是 N/n:否) [Y/y]:y
设置时区:
[ 1]: GTM-12=日界线西
[ 2]: GTM-11=萨摩亚群岛
[ 3]: GTM-10=夏威夷
[ 4]: GTM-09=阿拉斯加
[ 5]: GTM-08=太平洋时间(美国和加拿大)
[ 6]: GTM-07=亚利桑那
[ 7]: GTM-06=中部时间(美国和加拿大)
[ 8]: GTM-05=东部部时间(美国和加拿大)
[ 9]: GTM-04=大西洋时间(美国和加拿大)
[10]: GTM-03=巴西利亚
[11]: GTM-02=中大西洋
[12]: GTM-01=亚速尔群岛
[13]: GTM=格林威治标准时间
[14]: GTM+01=萨拉热窝
[15]: GTM+02=开罗
[16]: GTM+03=莫斯科
[17]: GTM+04=阿布扎比
[18]: GTM+05=伊斯兰堡
[19]: GTM+06=达卡
[20]: GTM+07=曼谷,河内
[21]: GTM+08=中国标准时间
[22]: GTM+09=汉城
[23]: GTM+10=关岛
[24]: GTM+11=所罗门群岛
[25]: GTM+12=斐济
[26]: GTM+13=努库阿勒法
[27]: GTM+14=基里巴斯
请选择设置时区 [21]:21
安装类型:
1 典型安装
2 服务器
3 客户端
4 自定义
请选择安装类型的数字序号 [1 典型安装]:
所需空间: 1611M
请选择安装目录 [/home/dmdba/dmdbms]:/dm8
可用空间: 10G
是否确认安装路径(/dm8)? (Y/y:是 N/n:否) [Y/y]:y
安装前小结
安装位置: /dm8
所需空间: 1611M
可用空间: 10G
版本信息:
有效日期:
安装类型: 典型安装
是否确认安装? (Y/y:是 N/n:否):y
2023-06-20 20:48:51
[INFO] 安装达梦数据库...
2023-06-20 20:48:51
[INFO] 安装 基础 模块...
2023-06-20 20:48:55
[INFO] 安装 服务器 模块...
2023-06-20 20:48:56
[INFO] 安装 客户端 模块...
2023-06-20 20:48:59
[INFO] 安装 驱动 模块...
2023-06-20 20:48:59
[INFO] 安装 手册 模块...
2023-06-20 20:49:00
[INFO] 安装 服务 模块...
2023-06-20 20:49:01
[INFO] 移动日志文件。
2023-06-20 20:49:01
[INFO] 安装达梦数据库完成。
请以root系统用户执行命令:
/dm8/script/root/root_installer.sh
安装结束
8、检查服务状态
[root@localhost bin]# ./DmAPService status
DmAPService (pid 24812) is running.
9、初始化实例
[dmdba@localhost bin]$ ./dminit PATH=/dm8/data/ INSTANCE_NAME=GRP1_RT_01 PAGE_SIZE=32 EXTENT_SIZE=32 LOG_SIZE=2048
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2023-07-20
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
log file path: /dm8/data/DAMENG/DAMENG01.log
log file path: /dm8/data/DAMENG/DAMENG02.log
write to dir [/dm8/data/DAMENG].
create dm database success. 2023-06-20 21:12:06
[dmdba@localhost bin]$ ./dminit PATH=/dm8/data/ INSTANCE_NAME=GRP1_RT_02 PAGE_SIZE=32 EXTENT_SIZE=32 LOG_SIZE=2048
----13、使用命令行注册服务注册服务
启动服务
[dmdba@localhost bin]$ ./dmserver /dm8/data/DAMENG/dm.ini
[root@localhost root]# ./dm_service_installer.sh -t dmserver -dm_ini /dm8/data/DAMENG/dm.ini -p DMSERVER
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceDMSERVER.service to /usr/lib/systemd/system/DmServiceDMSERVER.service.
创建服务(DmServiceDMSERVER)完成
./DmServiceDMSERVER status
14、开归档
[dmdba@localhost bin]$ ./disql SYSDBA/SYSDBA@192.168.176.2:5236
服务器[192.168.176.2:5236]:处于普通打开状态
登录使用时间 : 3.760(ms)
disql V8
SQL> ALTER DATABASE MOUNT;
操作已执行
已用时间: 4.458(毫秒). 执行号:0.
SQL> ALTER DATABASE ARCHIVELOG;
操作已执行
已用时间: 3.881(毫秒). 执行号:0.
SQL> ALTER DATABASE ADD ARCHIVELOG 'DEST=/dm8/data/DAMENG/arch, TYPE=LOCAL, FILE_SIZE=1024, SPACE_LIMIT=51200';
操作已执行
已用时间: 11.445(毫秒). 执行号:0.
SQL> ALTER DATABASE OPEN;
操作已执行
已用时间: 18.459(毫秒). 执行号:0.
15、备份数据
SQL> BACKUP DATABASE BACKUPSET '/dm8/data/DAMENG/bak/BACKUP_FILE';
操作已执行
已用时间: 00:00:03.330. 执行号:503.
16、
SQL> SP_SET_PARA_VALUE (2,'PORT_NUM',5236);
DMSQL 过程已成功完成
已用时间: 3.148(毫秒). 执行号:504.
SQL> SP_SET_PARA_VALUE (2,'DW_INACTIVE_INTERVAL',60);
DMSQL 过程已成功完成
已用时间: 3.181(毫秒). 执行号:505.
SQL> SP_SET_PARA_VALUE (2,'ALTER_MODE_STATUS',0);
DMSQL 过程已成功完成
已用时间: 3.313(毫秒). 执行号:506.
SQL> SP_SET_PARA_VALUE (2,'ENABLE_OFFLINE_TS',2);
DMSQL 过程已成功完成
已用时间: 3.058(毫秒). 执行号:507.
SQL> SP_SET_PARA_VALUE (2,'MAL_INI',1);
DMSQL 过程已成功完成
已用时间: 3.066(毫秒). 执行号:508.
SQL> SP_SET_PARA_VALUE (2,'RLOG_SEND_APPLY_MON',64);
DMSQL 过程已成功完成
已用时间: 3.235(毫秒). 执行号:509.
17、关闭实例的服务
[dmdba@localhost bin]$ systemctl stop DmServiceDMSERVER.service
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to manage system services or units.
Authenticating as: root
Password:
==== AUTHENTICATION COMPLETE ===
18、配置
vi /dm8/data/DAMENG/dmarch.ini
ARCH_WAIT_APPLY = 0 #0:高性能 1:事务一致
[ARCHIVE_LOCAL]
ARCH_TYPE = LOCAL #本地归档类型
ARCH_DEST = /dm8/data/DAMENG/arch/ #本地归档存放路径
ARCH_FILE_SIZE = 1024 #单个归档大小,单位 MB
ARCH_SPACE_LIMIT = 51200 #归档上限,单位 MB
[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME #实时归档类型
ARCH_DEST = GRP1_RT_02 #实时归档目标实例名
[dmdba@~]$ vi /dm8/data/DAMENG/dmmal.ini
MAL_CHECK_INTERVAL = 10 #MAL 链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 10 #判定 MAL 链路断开的时间
MAL_TEMP_PATH = /dm8/data/malpath/ #临时文件目录
MAL_BUF_SIZE = 512 #单个 MAL 缓存大小,单位 MB
MAL_SYS_BUF_SIZE = 2048 #MAL 总大小限制,单位 MB
MAL_COMPRESS_LEVEL = 0 #MAL 消息压缩等级,0 表示不压缩
[MAL_INST1]
MAL_INST_NAME = GRP1_RT_01 #实例名,和 dm.ini 的 INSTANCE_NAME 一致
MAL_HOST = 192.168.176.2 #MAL 系统监听 TCP 连接的 IP 地址
MAL_PORT = 5336 #MAL 系统监听 TCP 连接的端口
MAL_INST_HOST = 192.168.176.2 #实例的对外服务 IP 地址
MAL_INST_PORT = 5236 #实例对外服务端口,和 dm.ini 的 PORT_NUM 一致
MAL_DW_PORT = 5436 #实例对应的守护进程监听 TCP 连接的端口
MAL_INST_DW_PORT = 5536 #实例监听守护进程 TCP 连接的端口
[MAL_INST2]
MAL_INST_NAME = GRP1_RT_02
MAL_HOST = 192.168.1.2
MAL_PORT = 5336
MAL_INST_HOST = 192.168.176.3
MAL_INST_PORT = 5236
MAL_DW_PORT = 5436
MAL_INST_DW_PORT = 5536
[dmdba@~]$ vi /dm8/data/DAMENG/dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL #全局守护类型
DW_MODE = MANUAL #MANUAL:故障手切 AUTO:故障自切
DW_ERROR_TIME = 20 #远程守护进程故障认定时间
INST_ERROR_TIME = 20 #本地实例故障认定时间
INST_RECOVER_TIME = 60 #主库守护进程启动恢复的间隔时间
INST_OGUID = 45331 #守护系统唯一 OGUID 值
INST_INI = /dm8/data/DAMENG/dm.ini #dm.ini 文件路径
INST_AUTO_RESTART = 1 #打开实例的自动启动功能
INST_STARTUP_CMD = /dm8/bin/dmserver #命令行方式启动
RLOG_SEND_THRESHOLD = 0 #指定主库发送日志到备库的时间阈值,默认关闭
RLOG_APPLY_THRESHOLD = 0 #指定备库重演日志的时间阈值,默认关闭
19、拷贝备份文件
[dmdba@localhost bin]$ scp -r /dm8/data/DAMENG/bak/BACKUP_FILE dmdba@192.168.176.3:/dm8/data/DAMENG/bak
The authenticity of host '192.168.176.3 (192.168.176.3)' can't be established.
ECDSA key fingerprint is SHA256:tyliVyGdXqLiKL9S99Kd2HePFPAKqrU9GZ7pSzoOb/8.
ECDSA key fingerprint is MD5:bf:23:bf:62:d3:7a:18:5c:5a:38:f1:6f:0d:d5:69:fe.
Are you sure you want to continue connecting (yes/no)? yyes
Please type 'yes' or 'no': yes
Warning: Permanently added '192.168.176.3' (ECDSA) to the list of known hosts.
dmdba@192.168.176.3's password:
BACKUP_FILE.bak 100% 89MB 112.0MB/s 00:00
BACKUP_FILE_1.bak 100% 354KB 66.3MB/s 00:00
BACKUP_FILE.meta 100% 89KB 41.0MB/s 00:00
[dmdba@localhost bin]$
20、注册服务
[root@~]# /dm8/script/root/dm_service_installer.sh -t dmserver -p GRP1_RT_01 -dm_ini /dm8/data/DAMENG/dm.ini -m mount
[root@localhost root]# /dm8/script/root/dm_service_installer.sh -t dmserver -p GRP1_RT_01 -dm_ini /dm8/data/DAMENG/dm.ini -m mount
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceGRP1_RT_01.service to /usr/lib/systemd/system/DmServiceGRP1_RT_01.service.
创建服务(DmServiceGRP1_RT_01)完成
[root@~]# /dm8/script/root/dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini /dm8/data/DAMENG/dmwatcher.ini
[root@localhost root]# /dm8/script/root/dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini /dm8/data/DAMENG/dmwatcher.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceWatcher.service to /usr/lib/systemd/system/DmWatcherServiceWatcher.service.
创建服务(DmWatcherServiceWatcher)完成
21、另一台服务器恢复数据
[dmdba@localhost data]$ /dm8/bin/dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/DAMENG/dm.ini' FROM BACKUPSET '/dm8/data/DAMENG/bak/BACKUP_FILE'"
dmrman V8
RESTORE DATABASE '/dm8/data/DAMENG/dm.ini' FROM BACKUPSET '/dm8/data/DAMENG/bak/BACKUP_FILE'
file dm.key not found, use default license!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]
restore successfully.
time used: 00:00:02.771
[dmdba@localhost data]$ /dm8/bin/dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DAMENG/dm.ini' FROM BACKUPSET '/dm8/data/DAMENG/bak/BACKUP_FILE'"
dmrman V8
RECOVER DATABASE '/dm8/data/DAMENG/dm.ini' FROM BACKUPSET '/dm8/data/DAMENG/bak/BACKUP_FILE'
file dm.key not found, use default license!
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]s cur_lsn[53863], file_lsn[53863]
[Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00]
recover successfully!
time used: 00:00:02.464
[dmdba@localhost data]$ /dm8/bin/dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DAMENG/dm.ini' UPDATE DB_MAGIC"
dmrman V8
RECOVER DATABASE '/dm8/data/DAMENG/dm.ini' UPDATE DB_MAGIC
file dm.key not found, use default license!
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]s cur_lsn[53946], file_lsn[53946]
recover successfully!
time used: 00:00:01.034
22、修改配置
[dmdba@~]$ vi /dm8/data/DAMENG/dmarch.ini
ARCH_WAIT_APPLY = 0 #0:高性能 1:事务一致
[ARCHIVE_LOCAL]
ARCH_TYPE = LOCAL #本地归档类型
ARCH_DEST = /dm8/data/DAMENG/arch/ #本地归档存放路径
ARCH_FILE_SIZE = 1024 #单个归档大小,单位 MB
ARCH_SPACE_LIMIT = 51200 #归档上限,单位 MB
[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME #实时归档类型
ARCH_DEST = GRP1_RT_01 #实时归档目标实例名
修改dm.ini
INSTANCE_NAME = GRP1_RT_02
PORT_NUM = 5236 #数据库实例监听端口
DW_INACTIVE_INTERVAL = 60 #接收守护进程消息超时时间
ALTER_MODE_STATUS = 0 #不允许手工方式修改实例模式/状态/OGUID
ENABLE_OFFLINE_TS = 2 #不允许备库 OFFLINE 表空间
MAL_INI = 1 #打开 MAL 系统
ARCH_INI = 1 #打开归档配置
RLOG_SEND_APPLY_MON = 64 #统计最近 64 次的日志重演信息
vi /dm8/data/DAMENG/dmarch.ini
ARCH_WAIT_APPLY = 0 #0:高性能 1:事务一致
[ARCHIVE_LOCAL]
ARCH_TYPE = LOCAL #本地归档类型
ARCH_DEST = /dm8/data/DAMENG/arch/ #本地归档存放路径
ARCH_FILE_SIZE = 1024 #单个归档大小,单位 MB
ARCH_SPACE_LIMIT = 51200 #归档上限,单位 MB
[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME #实时归档类型
ARCH_DEST = GRP1_RT_02 #实时归档目标实例名
[dmdba@~]$ vi /dm8/data/DAMENG/dmmal.ini
MAL_CHECK_INTERVAL = 10 #MAL 链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 10 #判定 MAL 链路断开的时间
MAL_TEMP_PATH = /dm8/dmdbms/data/malpath/ #临时文件目录
MAL_BUF_SIZE = 512 #单个 MAL 缓存大小,单位 MB
MAL_SYS_BUF_SIZE = 2048 #MAL 总大小限制,单位 MB
MAL_COMPRESS_LEVEL = 0 #MAL 消息压缩等级,0 表示不压缩
[MAL_INST1]
MAL_INST_NAME = GRP1_RT_01 #实例名,和 dm.ini 的 INSTANCE_NAME 一致
MAL_HOST = 192.168.176.2 #MAL 系统监听 TCP 连接的 IP 地址
MAL_PORT = 5336 #MAL 系统监听 TCP 连接的端口
MAL_INST_HOST = 192.168.176.2 #实例的对外服务 IP 地址
MAL_INST_PORT = 5236 #实例对外服务端口,和 dm.ini 的 PORT_NUM 一致
MAL_DW_PORT = 5436 #实例对应的守护进程监听 TCP 连接的端口
MAL_INST_DW_PORT = 5536 #实例监听守护进程 TCP 连接的端口
[MAL_INST2]
MAL_INST_NAME = GRP1_RT_02
MAL_HOST = 192.168.176.3
MAL_PORT = 5336
MAL_INST_HOST = 192.168.176.3
MAL_INST_PORT = 5236
MAL_DW_PORT = 5436
MAL_INST_DW_PORT = 5536
[dmdba@~]$ vi /dm8/data/DAMENG/dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL #全局守护类型
DW_MODE = MANUAL #MANUAL:故障手切 AUTO:故障自切
DW_ERROR_TIME = 20 #远程守护进程故障认定时间
INST_ERROR_TIME = 20 #本地实例故障认定时间
INST_RECOVER_TIME = 60 #主库守护进程启动恢复的间隔时间
INST_OGUID = 45331 #守护系统唯一 OGUID 值
INST_INI = /opt/dmdbms/data/DAMENG/dm.ini #dm.ini 文件路径
INST_AUTO_RESTART = 1 #打开实例的自动启动功能
INST_STARTUP_CMD = /opt/dmdbms/bin/dmserver #命令行方式启动
RLOG_SEND_THRESHOLD = 0 #指定主库发送日志到备库的时间阈值,默认关闭
RLOG_APPLY_THRESHOLD = 0 #指定备库重演日志的时间阈值,默认关闭
23、注册服务
[root@localhost bin]# /dm8/script/root/dm_service_installer.sh -t dmserver -p GRP1_RT_02 -dm_ini /dm8/data/DAMENG/dm.ini -m mount
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceGRP1_RT_02.service to /usr/lib/systemd/system/DmServiceGRP1_RT_02.service.
创建服务(DmServiceGRP1_RT_02)完成
[root@localhost bin]# /dm8/script/root/dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini /dm8/data/DAMENG/dmwatcher.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceWatcher.service to /usr/lib/systemd/system/DmWatcherServiceWatcher.service.
创建服务(DmWatcherServiceWatcher)完成
24、创建 dmmonitor.ini
[dmdba@~]$ vi /dm8/bin/dmmonitor.ini
MON_DW_CONFIRM = 0 #0:非确认(故障手切) 1:确认(故障自切)
MON_LOG_PATH = /dm8/log #监视器日志文件存放路径
MON_LOG_INTERVAL = 60 #每隔 60s 定时记录系统信息到日志文件
MON_LOG_FILE_SIZE = 512 #单个日志大小,单位 MB
MON_LOG_SPACE_LIMIT = 2048 #日志上限,单位 MB
[GRP1]
MON_INST_OGUID = 45331 #组 GRP1 的唯一 OGUID 值
MON_DW_IP = 192.168.176.2:5436 #IP 对应 MAL_HOST,PORT 对应 MAL_DW_PORT
MON_DW_IP = 192.168.176.3:5436
创建服务
[root@~]# /dm8/script/root/dm_service_installer.sh -t dmmonitor -p Monitor -monitor_ini /dm8/bin/dmmonitor.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmMonitorServiceMonitor.service to /usr/lib/systemd/system/DmMonitorServiceMonitor.service.
创建服务(DmMonitorServiceMonitor)完成
25、启动服务
主
[dmdba@localhost ~]$ /dm8/bin/DmServiceGRP1_RT_01 start
Starting DmServiceGRP1_RT_01:
[ OK ]
[dmdba@localhost ~]$ /dm8/bin/disql SYSDBA/SYSDBA@192.168.176.2:5236
服务器[192.168.176.2:5236]:处于普通配置状态
登录使用时间 : 3.370(ms)
disql V8
SQL> SP_SET_OGUID(45331);
DMSQL 过程已成功完成
已用时间: 10.569(毫秒). 执行号:0.
SQL> ALTER DATABASE PRIMARY;
操作已执行
已用时间: 3.490(毫秒). 执行号:0.
备
[dmdba@localhost ~]$ /dm8/bin/DmServiceGRP1_RT_02 start
Starting DmServiceGRP1_RT_02: [ OK ]
[dmdba@localhost ~]$ /dm8/bin/disql SYSDBA/SYSDBA@192.168.176.3:5236
服务器[192.168.176.3:5236]:处于普通配置状态
登录使用时间 : 4.841(ms)
disql V8
SQL> SP_SET_OGUID(45331);
DMSQL 过程已成功完成
已用时间: 13.799(毫秒). 执行号:0.
SQL> ALTER DATABASE STANDBY;
操作已执行
已用时间: 4.856(毫秒). 执行号:0.
26、启动守护进程
主备
[dmdba@~]$ /dm8/bin/DmWatcherServiceWatcher start
[dmdba@localhost DAMENG]$ /dm8/bin/DmWatcherServiceWatcher start
Starting DmWatcherServiceWatcher: [ OK ]
27、启动监视器
##后台启动
[dmdba@~]$ /dm8/bin/DmMonitorServiceMonitor start
[root@localhost ~]# /dm8/bin/DmMonitorServiceMonitor start
Starting DmMonitorServiceMonitor: Last login: Sun Jun 25 23:25:18 CST 2023 on pts/2
[ OK ]
##前台启动
[root@localhost ~]# /dm8/bin/dmmonitor /dm8/bin/dmmonitor.ini
[monitor] 2023-06-20 23:48:20: DMMONITOR[4.0] V8
[monitor] 2023-06-20 23:48:20: DMMONITOR[4.0] IS READY.
[monitor] 2023-06-20 23:48:20: 收到守护进程(GRP1_RT_02)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2023-06-20 23:48:20 OPEN OK GRP1_RT_02 OPEN STANDBY NULL 8 53946 53946
[monitor] 2023-06-20 23:48:20: 收到守护进程(GRP1_RT_01)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2023-06-20 23:48:20 OPEN OK GRP1_RT_01 OPEN PRIMARY VALID 9 56842 56843