注册
DM8主备集群搭建(详细版)
技术分享/ 文章详情 /

DM8主备集群搭建(详细版)

DM_086385 2024/05/31 1326 0 0

DM8主备集群前期准备:3台服务器(一主一备一监视器)
配置如下:
dwp 192.168.1.10 —主机
dws 192.168.1.11 —备机
dwm 192.168.1.12 —监视器

创建数据库实例:
主库:
/dm8/script/root/dm_service_installer.sh -t dmserver -p GRP1_01 -dm_ini /dm8/data/GRP_01/dm.ini
备库:
/dm8/script/root/dm_service_installer.sh -t dmserver -p GRP1_02 -dm_ini /dm8/data/GRP_02/dm/.ini
PS:也可以进到dm8/tool 目录执行./dbca.sh进入图形化创建

主备两台实例全部关掉:
./DmServiceGRP_01 stop
./DmServiceGRP_02 stop

对主机进行备份(在本机备份):
建立备份文件夹

mkdir -p /dm8/backup
./dmrman 
BACKUP DATABASE '/dm8/data/GRP_01/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/BACKUP_FILE_01'

从主传到备

scp /dm8/backup/BACKUP_FILE_01/*.* 192.168.1.11:/dm8/backup
//在备机上进行恢复
./dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/GRP1_02/dm.ini'  FROM BACKUPSET '/dm8/backup'" 
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/GRP1_02/dm.ini'  FROM BACKUPSET '/dm8/backup'" 
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/GRP1_03/dm.ini'  UPDATE DB_MAGIC"

主机实例配置文件修改

dm.ini
----------
INSTANCE_NAME = GRP1_01 
PORT_NUM = 5246
DW_INACTIVE_INTERVAL = 60 
ALTER_MODE_STATUS = 0 
ENABLE_OFFLINE_TS = 2 是否允许表空间offline,2是不允许备库offline 
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64
---------------

//需要新建
dmmal.ini
------------
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1] 
MAL_INST_NAME = GRP1_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_02
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

------------------
dmarch.ini   (注:arch_dest备机写主机实例,主机写备机实例)
------------
[ARCHIVE_REALTIME] 
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_02
[ARCHIVE_LOCAL1] 
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch 
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

-------------------------
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/GRP1_01/dm.ini  
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver 
RLOG_SEND_THRESHOLD = 0  
RLOG_APPLY_THRESHOLD = 0 

启动主机数据库(挂载模式)

启动主库
cd /dm8/bin
./dmserver    /dm8/data/GRP_01/dm.ini  mount

重新开一个窗口

cd /dm8/bin
./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);

备机需要注意的是dmarch.ini文件需要写主机的实例名,其他配置文件把实例名改为GRP1_02即可,同样需要以mount方式启动并修改参数(参照主机)

监视器配置

dmmonitor.ini
--------------
MON_DW_CONFIRM = 1 
MON_LOG_PATH = /dm8/data/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.10:65101 
MON_DW_IP = 192.168.1.11:65121

启动监视器
./dmmonitor /dm8/dmmonitor.ini
评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服