搭建DM8_数据守护--达梦数据库

1 环境准备：

主库 IP：192.168.232.66

备库 IP：192.168.232.88

监视器IP：192.168.232.99

数据库名	实例名	PORT_NUM	MAL_PORT	MAL_HOST	MAL_PORT	MAL_DW_PORT
DAMENG	GRP1_RT_01	5236	45101	10.10.66.174	55101	65101
DAMENG	GRP1_RT_02	5236	45121	10.10.66.175	55121	65121

2 全库备份（主库）

--冷备（脱机备份）
SQL>./dmrman CTLSTMT="BACKUP DATABASE '/opt/dmdba/data/DAMENG/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/opt/dmdba/backup/BACKUP_FILE_01'" 
--热备（联机备份）
SQL>BACKUP DATABASE BACKUP SET '/opt/dmdba/backup/BACKUP_FILE _01
--将主库的备份发送至备库
[root@dm8-master ~]scp -r ../backup/BACKUP_FILE_01/ dmdba@192.168.232.88:/opt/dmdbms/backup/

3 备份还原（备库）

--备库还原
SQL>./dmrman CTLSTMT="RESTORE DATABASE '/opt/dmdba/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdba/backup/BACKUP_FILE_01'" 
SQL>./dmrman CTLSTMT="RECOVER DATABASE '/opt/dmdba/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdba/backup/BACKUP_FILE_01'" 
SQL>./dmrman CTLSTMT="RECOVER DATABASE '/opt/dmdba/data/DAMENG/dm.ini' UPDATE DB_MAGIC"

4 修改主库参数文件：

4.1 需要修改4个文件；

​​​​​​​--primary

dm.ini	数据库配置文件
dmmal.ini	MAL配置文件
dmarch.ini	归档日志配置文件
dmwatcher.ini	守护进程配置文件

4.2 直接通过脚本修改

--可以创建shell脚本后直接执行该脚本

sed -i s/'INSTANCE_NAME                   = DMSERVER'/'INSTANCE_NAME  = GRP1_RT_01'/g     /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'DW_INACTIVE_INTERVAL            = 60'/'DW_INACTIVE_INTERVAL            = 60'/g  /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'ALTER_MODE_STATUS               = 1'/'ALTER_MODE_STATUS               = 0'/g    /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'ENABLE_OFFLINE_TS               = 1'/'ENABLE_OFFLINE_TS               = 2'/g    /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'MAL_INI                         = 0'/'MAL_INI                         = 1'/g    /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'ARCH_INI                        = 0'/'ARCH_INI                        = 1'/g    /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'RLOG_SEND_APPLY_MON             = 64'/'RLOG_SEND_APPLY_MON             = 64'/g  /opt/dmdbms/data/DAMENG/dm.ini
--sed -i s/'PORT_NUM                        = 5236'/'PORT_NUM                        = 5236'/g  /opt/dmdbms/data/DAMENG/dm.ini

cat  >>/opt/dmdbms/data/DAMENG/dmmal.ini<<EOF
MAL_CHECK_INTERVAL = 5 							#MAL 链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 5 						#判定 MAL 链路断开的时间
[MAL_INST1]	
MAL_INST_NAME = GRP1_RT_01 						#实例名，和 dm.ini 中的 INSTANCE_NAME一致
MAL_HOST = 192.168.232.66 						#MAL 系统监听 TCP 连接的 IP 地址
MAL_PORT = 55101 								#MAL 系统监听 TCP 连接的端口
MAL_INST_HOST = 192.168.232.66 					#实例的对外服务 IP 地址
MAL_INST_PORT = 5236 							#实例的对外服务端口，和dm.ini中的PORT_NUM一致
MAL_DW_PORT  = 65101 							#实例本地的守护进程监听 TCP 连接的端口
MAL_INST_DW_PORT = 45101 						#实例监听守护进程 TCP 连接的端口
[MAL_INST2]
MAL_INST_NAME = GRP1_RT_02
MAL_HOST = 192.168.232.88
MAL_PORT = 55121
MAL_INST_HOST = 192.168.232.88
MAL_INST_PORT = 5236
MAL_DW_PORT  = 65121
MAL_INST_DW_PORT = 45121
EOF


cat  >>/opt/dmdbms/data/DAMENG/dmarch.ini<<EOF
[ARCHIVE_REALTIME]
ARCH_TYPE  = REALTIME 							#实时归档类型
ARCH_DEST  = GRP1_RT_02  						#实时归档目标实例名
[ARCHIVE_LOCAL1]
ARCH_TYPE  = LOCAL						 		#本地归档类型
ARCH_DEST  = /opt/dmdbms/arch  					#本地归档文件存放路径
ARCH_FILE_SIZE = 128  							#单位 Mb，本地单个归档文件最大值
ARCH_SPACE_LIMIT  = 10240					 	#单位 Mb，0 表示无限制，范围 1024~4294967294M
EOF


cat  >>/opt/dmdbms/data/DAMENG/dmwatcher.ini<<EOF
[GRP1]
DW_TYPE = GLOBAL 								#全局守护类型
DW_MODE = AUTO 									#自动切换模式
DW_ERROR_TIME = 10  							#远程守护进程故障认定时间
INST_RECOVER_TIME = 60 							#主库守护进程启动恢复的间隔时间
INST_ERROR_TIME = 10  							#本地实例故障认定时间
INST_OGUID = 453331  							#守护系统唯一 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 						#指定备库重演日志的时间阈值，默认关闭
EOF

5 主库启动

[dmdba@dm8-node1 ~]$./dmserver /opt/dmdba/data/DAMENG/dm.ini mount   #将主库启动至mount状态

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;

6 修改备库参数文件

--standby

dm.ini	数据库配置文件
dmmal.ini	MAL配置文件
dmarch.ini	归档日志配置文件
dmwatcher.ini	守护进程配置文件

#-----------1-------------  修改dm.ini中的相关参数
sed -i s/'INSTANCE_NAME                   = DMSERVER01'/'INSTANCE_NAME  = GRP1_RT_02'/g      /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'DW_INACTIVE_INTERVAL            = 60'/'DW_INACTIVE_INTERVAL            = 60'/g  /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'ALTER_MODE_STATUS               = 1'/'ALTER_MODE_STATUS               = 0'/g    /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'ENABLE_OFFLINE_TS               = 1'/'ENABLE_OFFLINE_TS               = 2'/g    /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'MAL_INI                         = 0'/'MAL_INI                         = 1'/g    /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'ARCH_INI                        = 0'/'ARCH_INI                        = 1'/g    /opt/dmdbms/data/DAMENG/dm.ini
sed -i s/'RLOG_SEND_APPLY_MON             = 64'/'RLOG_SEND_APPLY_MON             = 64'/g  /opt/dmdbms/data/DAMENG/dm.ini
--sed -i s/'PORT_NUM                        = 5236'/'PORT_NUM                        = 5236'/g  /opt/dmdbms/data/DAMENG/dm.ini



#-----------2------------- 和主库dmmal.ini相同
cat >>dmmal.ini<<EOF

MAL_CHECK_INTERVAL = 5 
MAL_CONN_FAIL_INTERVAL = 5  
[MAL_INST1] 
MAL_INST_NAME = DMSERVER  
MAL_HOST = 192.168.232.66
MAL_PORT = 55101 
MAL_INST_HOST = 192.168.232.66
MAL_INST_PORT = 5236 
MAL_DW_PORT = 65101  
MAL_INST_DW_PORT = 45101 
[MAL_INST2] 
MAL_INST_NAME = DMSERVER01
MAL_HOST = 192.168.232.88
MAL_PORT = 55121 
MAL_INST_HOST = 192.168.232.88
MAL_INST_PORT = 5236 
MAL_DW_PORT = 65121 
MAL_INST_DW_PORT = 45121
EOF

#-----------3-------------
cat >>dmarch.ini<<EOF

[ARCHIVE_REALTIME] 
ARCH_TYPE = REALTIME 
ARCH_DEST = DMSERVER  
[ARCHIVE_LOCAL1] 
ARCH_TYPE = LOCAL 
ARCH_DEST = /opt/dmdba/arch  
ARCH_FILE_SIZE = 128  
ARCH_SPACE_LIMIT = 0 
EOF

#-----------4-------------和主库dmwatcher.ini相同
cat >>dmwatcher.ini<<EOF

[GRP1] 
DW_TYPE = GLOBAL 
DW_MODE = AUTO 
DW_ERROR_TIME = 10 
INST_RECOVER_TIME = 60 
INST_ERROR_TIME = 10  
INST_OGUID = 453331
INST_INI = /opt/dmdba/data/DAMENG/dm.ini 
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /opt/dmdba/bin/dmserver 
RLOG_APPLY_THRESHOLD = 0
EOF

7 启动备库

$./dmserver /opt/dmdba/data/DAMENG/dm.ini mount 将数据库启动至mount状态
--设置OGUID
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); --允许修改数据库模式
SQL>sp_set_oguid(453331); 		
SQL>alter database standby; 					  --将数据库模式修改为standby，初始时perimary
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

8 监控配置文件

​​​​​​

故障自动切换模式下，必须配置监视器，切监视器唯一；测试环境下监视器可配置主库或备库中；

cat >>dmmonitor.ini<<EOF

MON_DW_CONFIRM = 1           	#确认监视器模式	
MON_LOG_PATH = /opt/dmdba/mon/log    
MON_LOG_INTERVAL = 60 			#每隔 60s 定时记录系统信息到日志文件
MON_LOG_FILE_SIZE = 32 			#每个日志文件最大 32M
MON_LOG_SPACE_LIMIT = 0 		#不限定日志文件总占用空间
[GRP1] 
MON_INST_OGUID = 453331  
MON_DW_IP = 192.168.232.66:65101 	#IP对应dmmal.ini的MAL_HOST,PORT对应dmmal.ini的MAL_DW_PORT
MON_DW_IP = 192.168.232.88:65121	
EOF

9 启动守护进程

​​​​​​​

分别在各主备库上执行：
$./dmwatcher /opt/dmdba/data/DAMENG/dmwatcher.ini

10 启动监护器

$./dmmonitor 	/opt/dmdba/data/dmmonitor .ini

show 		--查看主备状态
switchover  --主备切换

11 注册数据守护服务

​​​​​​​

$/opt/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini $/opt/dmdbms/data/DAMENG/dmwatcher.ini

更多资讯请上达梦技术社区了解：https://eco.dameng.com