注册
达梦数据守护集群搭建实操--附考试心得
培训园地/ 文章详情 /

达梦数据守护集群搭建实操--附考试心得

褚润林 2023/05/19 926 0 0
1.检查并关闭虚拟机防火墙,否则会影响守护程序拉起数据库
2.需要准备三台虚拟机(主机、备机、监视器)
3.主机和备机安好达梦db并创建数据库实例(使用不同的实例名),监视器有达梦db即可

4.  主机IP          192.168.1.30   
    备机IP          192.168.1.20    
    监视器IP        192.168.1.18 

数据库名	   实例名	           PORT_NUM	     MAL_INST_DW_PORT	MAL_HOST	MAL_PORT	MAL_DW_PORT
DMDW    GRP1_RT_01	5246	45101	192.168.1.30	55101	65101
DMDW    GRP1_RT_03	5246	45121	192.168.1.20	55121	65121

下面开始正式搭建集群

1.停主备库
[root@dm1] systemctl ./DmServiceGRP1_RT_01 stop
[root@dm2] systemctl ./DmServiceGRP1_RT_02 stop
2.备机商创建备份目录
然后dmdba用户新建一个备份目录,备份到这里
[dmdba@dm2]mkdir /dm8/backup
3.使用dmrman备份
RMAN>BACKUP DATABASE '/dm8/data/DMDW/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/BACKUP_FILE_01'

4.将主机备份传到备机
[dmdba@dm2]cd /dm8/backup/BACKUP_FILE_01
[dmdba@dm2]scp -r *.* 192.168.30.129:/dm8/backup
5.切到备机,进行dmrman还原(新完DBMAGIC后,原有的备份全部失效,需要立刻做一次全备份)
RMAN>RESTORE DATABASE '/dm8/data/DMDW/dm.ini' FROM BACKUPSET '/dm8/backup'
RMAN>RECOVER DATABASE '/dm8/data/DMDW/dm.ini' UPDATE DB_MAGIC
6.配置主库
(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 

(2)配置dmmal.ini文件(原来没有,需要新建,注意修改ip和端口号)
MAL_CHECK_INTERVAL = 60
MAL_CONN_FAIL_INTERVAL = 60
[MAL_INST1] 
MAL_INST_NAME = GRP1_RT_01 
MAL_HOST = 192.168.1.30
MAL_PORT = 55101
MAL_INST_HOST = 192.168.1.30
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.1.20 
MAL_PORT = 55121 
MAL_INST_HOST = 192.168.1.20
MAL_INST_PORT = 5246 
MAL_DW_PORT = 65121 
MAL_INST_DW_PORT = 45121

(3)配置归档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

(4)配置守护进程dmwatcher.ini
[GRP1] 
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 10 
INST_RECOVER_TIME = 60 
INST_ERROR_TIME = 10 
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 

(5)将主库设为mount模式,进行配置
[dmdba@dm1]cd /dm8/bin
[dmdba@dm1]./dmserver /dm8/data/DMDW/dm.ini  mount
[dmdba@dm1]./disql sysdba/dameng123@localhost:5246
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); 
SQL>sp_set_oguid(453331); 
SQL>alter database primary;
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
7.配置备库
(1)配置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 

(2)配置dmmal.ini文件(原来没有,需要新建,注意修改ip和端口号)
MAL_CHECK_INTERVAL = 60
MAL_CONN_FAIL_INTERVAL = 60
[MAL_INST1] 
MAL_INST_NAME = GRP1_RT_01 
MAL_HOST = 192.168.1.30
MAL_PORT = 55101
MAL_INST_HOST = 192.168.1.30
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.1.20 
MAL_PORT = 55121 
MAL_INST_HOST = 192.168.1.20
MAL_INST_PORT = 5246 
MAL_DW_PORT = 65121 
MAL_INST_DW_PORT = 45121

(3)配置归档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

(4)配置守护进程dmwatcher.ini
[GRP1] 
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 10 
INST_RECOVER_TIME = 60 
INST_ERROR_TIME = 10 
INST_OGUID = 453331 
INST_INI = /dm8/data/DMDW/dm.ini  
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver 
RLOG_APPLY_THRESHOLD = 0 

(5)将db设为mount模式,进行配置
[dmdba@dm1]cd /dm8/bin
[dmdba@dm1]./dmserver /dm8/data/DMDW/dm.ini  mount
[dmdba@dm1]./disql sysdba/dameng123@localhost:5246
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); 
SQL>sp_set_oguid(453331); 
SQL>alter database primary;
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

8.从mount状态切换到open状态,需要在主备库分别启动守护进程

先回到主机bin目录下,启动
./dmwatcher /dm8/data/DMDW/dmwatcher.ini
再回到备机bin目录下,启动
./dmwatcher /dm8/data/DMDW/dmwatcher.ini

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.1.30:65101
MON_DW_IP = 192.168.1.20:65121

10。启动集群
[dmdba@dm3]cd /dm8/bin
[dmdba@dm3]./dmmonitor /dm8/dmmonitor.ini

11.用root用户将守护注册进程到系统中:
[dmdba@dm1]cd /dm8/script/root/dm_service_installer.sh
[dmdba@dm1]./dm_service_installer.sh -t dmserver -p DMSERVER -m mount -dm_ini /dm8/data/DAMENG/dm.ini
[dmdba@dm1]./dm_service_installer.sh -t dmwatcher -p DMWATCHER -watcher_ini /dm8/data/DAMENG/dmwatcher.ini


至此,集群搭建完成。
现总结一下学习达梦以来遇到过的问题于解决方法:
```1./tmp文件夹空间调整
root用户
vim /etc/fstab
输入
tmpfs /tmp tmpfs nodev,nosuid,size=4G 0 0
保存
mount /tmp
df -h
可以看到变成4G

2.图形化界面无法打开
DISPLAY没有设置正确、报错权限不足(原因:使用root打开过图形化工具)
核心已转储,检查DISPLAY,检查虚拟机本机是否xhost+
检查$DM_HOME,是否为/dm8,如果不是退出dmdba用户会话至root会话,再进入一遍,记得再次设置DISPLAY
————————————————

最后,祝大家学习,考试,工作顺利~~~~



评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服