欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

DM8 DSC共享集群主备搭建部署

程序员文章站 2022-06-02 22:03:08
...

本篇为DMDSC集群主备搭建部署文档。主库为DMDSC集群,备库为单节点实例。

一、环境规划

主机规划:

IP Addr 数据库实例 数据库版本 OS
Primary Node1 192.168.15.40(外部)
192.168.25.40(内部)
RAC0 达梦8 Centos 7.8
Primary Node2 192.168.15.41(外部)
192.168.25.41(内部)
RAC1 达梦8 Centos 7.8
Standby 192.168.15.33(外部)
192.168.25.33(内部)
RAC_STB 达梦8 Centos 7.8
监视器 192.168.15.10
192.168.25.10
- 达梦8 中标麒麟6

端口规划:

实例名 PORT_NUM MAL_INST_DW_PORT MAL_HOST MAL_PORT MAL_DW_PORT
RAC0 5236 4567 192.168.25.40 9340 3567
RAC1 5236 4568 192.168.25.41 9341 3568
RAC_STB 5236 4569 192.168.25.33 8340 5538

二、配置DMDSC主库环境

2.1 搭建DMDSC主库

参考 DM8 DSC共享集群搭建部署

注意 :
   dmcss 对 dmserver 的自动拉起功能先不要打开,避免影响到配置过程。
   搭建完成后,正常关闭 DMDSC 集群的两个 dmserver 节点实例,不需要退出 dmcss和 dmasmsvr。

2.2 配置dm.ini(所有节点)

配置主库所有节点和单节点dm.ini文件,修改数据守护相关词参数。

除了数据库实例名和实例监听端口可以根据实际情况决定是否更改外,其他参数需要检查并修改。

节点1:

INSTANCE_NAME = RAC0   #数据库实例名
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次的日志发送信息

节点2:

INSTANCE_NAME = RAC1   #数据库实例名
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次的日志发送信息

2.3 配置dmarch.ini

配置本地归档、远程归档、实时归档。

节点1 dmarch.ini:

[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm/data/dmarch/rac0_arch
ARCH_FILE_SIZE = 64
ARCH_SPACE_LIMIT = 10240

[ARCHIVE_REMOTE]
ARCH_TYPE = REMOTE
ARCH_DEST = RAC1
ARCH_FILE_SIZE = 64
ARCH_SPACE_LIMIT = 10240
ARCH_INCOMING_PATH = /dm/data/dmarch/arch_remote

[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = RAC_STB

节点2 dmarch.ini:

[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm/data/dmarch/rac1_arch
ARCH_FILE_SIZE = 64
ARCH_SPACE_LIMIT = 10240

[ARCHIVE_REMOTE]
ARCH_TYPE = REMOTE
ARCH_DEST = RAC0
ARCH_FILE_SIZE = 64
ARCH_SPACE_LIMIT = 10240
ARCH_INCOMING_PATH = /dm/data/dmarch/arch_remote

[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = RAC_STB

2.4 备份DMDSC主库

./dmrman use_ap=2 dcr_ini=/dm/data/dmdsc/dmdcr.ini

backup database ‘/dm/data/dsc0_config/dm.ini’ full backupset ‘/dm/dmbak/db_full_dsc’;

[[email protected] bin]$ ./dmrman use_ap=2 dcr_ini=/dm/data/dmdsc/dmdcr.ini 
dmrman V8

RMAN>
RMAN> backup database '/dm/data/dsc0_config/dm.ini' full backupset '/dm/dmbak/db_full_dsc';
backup database '/dm/data/dsc0_config/dm.ini' full backupset '/dm/dmbak/db_full_dsc';
file dm.key not found, use default license!
checking if the DSC database under system path [+DMDATA/data/dsc] is running with vote disk....
EP [0] is checking....
EP [1] is checking....
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[51046]
EP[1]'s cur_lsn[51046]
EP[0] adjust cur_lsn from [51046] to [51046]
BACKUP DATABASE [dsc],execute......
CMD CHECK LSN......
BACKUP DATABASE [dsc],collect dbf......
CMD CHECK ......
DBF BACKUP SUBS......
total 1 packages processed...
total 2 packages processed...
total 3 packages processed...
DBF BACKUP MAIN......
BACKUPSET [/dm/dmbak/db_full_dsc] END, CODE [0]......
EP(0) slot ctl page(1, 0, 16) trxid[3008], pseg_state[0]
META GENERATING......
file [db_full_dsc.bak] finished, name:[db_full_dsc.bak],created time:[2020-06-13 21:30:26],expire time:[2105-12-31 23:59:59],label:[],comment:[]

file [db_full_dsc.meta] finished, name:[db_full_dsc.meta],created time:[2020-06-13 21:30:26],expire time:[2105-12-31 23:59:59],label:[],comment:[]

total 5 packages processed...
total 5 packages processed...
total 5 packages processed!
CMD END.CODE:[0]
backup successfully!
time used: 00:00:36.313
RMAN> 

2.5 配置dmmal.ini

在DMDSC集群的dmmal.ini文件基础上,增加备库RAC_STB的配置项。

所有节点实例的dmmal.ini文件内容是一致的,配置完成后,拷贝到每个节点实例dm.ini 中指定的 CONFIG_PATH 目录下。

所有主备库节点dmmal.ini:

MAL_CHECK_INTERVAL = 30 #MAL链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 10 #判定MAL链路断开的时间
[MAL_INST0]
MAL_INST_NAME = RAC0 #实例名,和dm.ini中的INSTANCE_NAME一致
MAL_HOST = 192.168.25.11 #MAL系统监听TCP连接的IP地址
MAL_PORT = 9340 #MAL系统监听TCP连接的端口
MAL_INST_HOST = 192.168.15.11 #实例的对外服务IP地址
MAL_INST_PORT = 5236 #实例的对外服务端口,和dm.ini中的PORT_NUM一致
MAL_DW_PORT = 3567 #实例本地的守护进程监听TCP连接的端口
MAL_INST_DW_PORT = 4567 #实例监听守护进程TCP连接的端口

[MAL_INST1]
MAL_INST_NAME = RAC1
MAL_HOST = 192.168.25.12
MAL_PORT = 9341
MAL_INST_HOST = 192.168.15.12
MAL_INST_PORT = 5236
MAL_DW_PORT = 3568
MAL_INST_DW_PORT = 4568

[MAL_INST2]
MAL_INST_NAME = RAC_STB
MAL_HOST = 192.168.25.33
MAL_PORT = 8340
MAL_INST_HOST = 192.168.15.33
MAL_INST_PORT = 5236
MAL_DW_PORT = 3569
MAL_INST_DW_PORT = 4569

2.6 配置dmwatcher.ini

依次配置每个节点实例 dmwatcher.ini文件,放到各自dm.ini中指定的CONFIG_PATH目录下。

需要注意:
   DMDSC集群各节点实例的自动拉起是由各自本地的dmcss执行的,不是由守护进程执行。

节点1 dmwatcher.ini:

[GRP1]
DW_TYPE = GLOBAL #全局守护类型
DW_MODE = MANUAL #手动切换模式
DW_ERROR_TIME = 60 #远程守护进程故障认定时间
INST_RECOVER_TIME = 60 #主库守护进程启动恢复的间隔时间
INST_ERROR_TIME = 35 #本地实例故障认定时间
INST_INI = /dm/data/dsc0_config/dm.ini #dm.ini 配置文件路径
DCR_INI = /dm/data/dmdsc/dmdcr.ini #dmdcr.ini 配置文件路径
INST_OGUID = 43333 #守护系统唯一OGUID值
INST_STARTUP_CMD = /dm/dmdbms/bin/dmserver #命令行方式启动
INST_AUTO_RESTART = 0 #关闭实例的自动启动功能
RLOG_SEND_THRESHOLD = 0 #指定主库发送日志到备库的时间阀值,默认关闭
RLOG_APPLY_THRESHOLD = 0 #指定备库重演日志的时间阀值,默认关闭

节点2 dmwatcher.ini:

[GRP1]
DW_TYPE = GLOBAL #全局守护类型
DW_MODE = MANUAL #手动切换模式
DW_ERROR_TIME = 60 #远程守护进程故障认定时间
INST_RECOVER_TIME = 60 #主库守护进程启动恢复的间隔时间
INST_ERROR_TIME = 30 #本地实例故障认定时间
INST_INI = /dm/data/dsc1_config/dm.ini #dm.ini 配置文件路径
DCR_INI = /dm/data/dmdsc/dmdcr.ini #dmdcr.ini 配置文件路径
INST_OGUID = 43333 #守护系统唯一OGUID值
INST_STARTUP_CMD = /dm/bin/dmserver #命令行方式启动
INST_AUTO_RESTART = 0 #关闭实例的自动启动功能
RLOG_SEND_THRESHOLD = 0 #指定主库发送日志到备库的时间阀值,默认关闭
RLOG_APPLY_THRESHOLD = 0 #指定备库重演日志的时间阀值,默认关闭

2.7 修改dmdcr.ini

​ DMDSC集群中dmserver的自动拉起是由dmcss执行的,需要修改dmdcr.ini中的自动拉起配置参数DMDCR_DB_RESTART_INTERVAL,此参数修改完成后,需要重启dmcss才可以生效。如果不需要打开dmcss的自动拉起功能,则可以不配置。
​ 另外,如果是用服务方式启动,服务脚本中也一定要指定以Mount方式拉起dmserver。

DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/dm/data/dmdsc/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 60
DMDCR_ASM_STARTUP_CMD = /dm/dmdbms/bin/dmasmsvr dcr_ini=/dm/data/dmdsc/dmdcr.ini
#DB 重启参数,命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 60
DMDCR_DB_STARTUP_CMD = /dm/dmdbms/bin/dmserver path=/dm/data/dsc0_config/dm.ini dcr_ini=/dm/data/dmdsc/dmdcr.ini mount

三、配置单节点备库

3.1 初始化备库实例

软件安装,参考之前文章。

初始化实例:

[[email protected] bin]$ ./dminit path=/dm/data/RAC_STB
initdb V8
db version: 0x7000a
file dm.key not found, use default license!
License will expire on 2021-06-01

 log file path: /dm/data/RAC_STB/DAMENG/DAMENG01.log


 log file path: /dm/data/RAC_STB/DAMENG/DAMENG02.log

write to dir [/dm/data/RAC_STB/DAMENG].
create dm database success. 2020-06-13 22:15:05
[[email protected] bin]$ 

3.2 还原数据

从主库拷贝备份集文件到备库。
DMRMAN还原:
./dmrman use_ap=2
restore database ‘/dm/data/RAC_STB/DAMENG/dm.ini’ from backupset ‘/dm/dmbak/db_full_dsc’;
recover database ‘/dm/data/RAC_STB/DAMENG/dm.ini’ from backupset ‘/dm/dmbak/db_full_dsc’;
recover database ‘/dm/data/RAC_STB/DAMENG/dm.ini’ update db_magic;

[[email protected] bin]$ ./dmrman use_ap=2
dmrman V8
----------------------------------------
RMAN> restore database '/dm/data/RAC_STB/DAMENG/dm.ini' from backupset '/dm/dmbak/db_full_dsc';
restore database '/dm/data/RAC_STB/DAMENG/dm.ini' from backupset '/dm/dmbak/db_full_dsc';
file dm.key not found, use default license!
RESTORE DATABASE CHECK......
RESTORE DATABASE,data collect......
RESTORE DATABASE,database refresh ......
RESTORE BACKUPSET [/dm/dmbak/db_full_dsc] START......
total 0 packages processed...
RESTORE DATABASE,UPDATE ctl file......
RESTORE DATABASE,REBUILD key file......
RESTORE DATABASE,CHECK db info......
RESTORE DATABASE,UPDATE db info......
total 5 packages processed!
CMD END.CODE:[0]
restore successfully.
time used: 00:00:01.190
----------------------------------------
RMAN> recover database '/dm/data/RAC_STB/DAMENG/dm.ini' from backupset '/dm/dmbak/db_full_dsc';
recover database '/dm/data/RAC_STB/DAMENG/dm.ini' from backupset '/dm/dmbak/db_full_dsc';
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[51046]
RESTORE RLOG CHECK......
CMD END.CODE:[603],DESC:[备份集[/dm/dmbak/db_full_dsc]备份过程中未产生日志]
备份集[/dm/dmbak/db_full_dsc]备份过程中未产生日志
EP(0) slot ctl page(1, 0, 16) trxid[3008], pseg_state[0]
recover successfully!
time used: 267.733(ms)
----------------------------------------
RMAN> recover database '/dm/data/RAC_STB/DAMENG/dm.ini' update db_magic;
recover database '/dm/data/RAC_STB/DAMENG/dm.ini' update db_magic;
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[51046]
EP[0]'s apply_lsn[51046] >= end_lsn[51046]
EP[1]'s apply_lsn[51046] >= end_lsn[51046]
EP(0) slot ctl page(1, 0, 16) trxid[3008], pseg_state[0]
recover successfully!
time used: 981.599(ms)
----------------------------------------

3.3 配置dm.ini

修改相关参数。

INSTANCE_NAME = RAC_STB
PORT_NUM = 5236
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64

3.4 配置dmarch.ini

​ DMDSC 集群可以作为主库,也可以作为实时备库、即时备库或者异步备库,当DMDSC集群作为备库配置在数据守护系统中时,要将DMDSC集群作为一个整体配置在源库的dmarch.ini 中,也就是 DMDSC 集群所有节点要配置在同一个归档配置项中,每个节点实例名以“/”分隔开来。
单节点备库dmarch.ini:

[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm/data/RAC_STB/DAMENG/arch
ARCH_FILE_SIZE = 64
ARCH_SPACE_LIMIT = 10240
[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME
ARCH_DEST = RAC0/RAC1

3.5 配置dmmal.ini

从主库拷贝dmmal.ini文件到备库。
dmmal.ini :

MAL_CHECK_INTERVAL = 30 #MAL链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 10 #判定MAL链路断开的时间
[MAL_INST0]
MAL_INST_NAME = RAC0 #实例名,和dm.ini中的INSTANCE_NAME一致
MAL_HOST = 192.168.25.11 #MAL系统监听TCP连接的IP地址
MAL_PORT = 9340 #MAL系统监听TCP连接的端口
MAL_INST_HOST = 192.168.15.11 #实例的对外服务IP地址
MAL_INST_PORT = 5236 #实例的对外服务端口,和dm.ini中的PORT_NUM一致
MAL_DW_PORT = 3567 #实例本地的守护进程监听TCP连接的端口
MAL_INST_DW_PORT = 4567 #实例监听守护进程TCP连接的端口

[MAL_INST1]
MAL_INST_NAME = RAC1
MAL_HOST = 192.168.25.12
MAL_PORT = 9341
MAL_INST_HOST = 192.168.15.12
MAL_INST_PORT = 5236
MAL_DW_PORT = 3568
MAL_INST_DW_PORT = 4568

[MAL_INST2]
MAL_INST_NAME = RAC_STB
MAL_HOST = 192.168.25.33
MAL_PORT = 8340
MAL_INST_HOST = 192.168.15.33
MAL_INST_PORT = 5236
MAL_DW_PORT = 3569
MAL_INST_DW_PORT = 4569

3.6 配置dmwatcher.ini

OGUID要与主库一致。

[GRP1]
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 60
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 35
INST_INI = /dm/data/RAC_STB/DAMENG/dm.ini
INST_OGUID = 43333
INST_STARTUP_CMD = /dm/dmdbms/bin/dmserver
INST_AUTO_RESTART = 1   #对单节点,如果需要打开自动拉起功能,将此配置修改为1即可
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

四、启动主备库及相关进程

4.1 启动主库到mount状态

dmcss、dmasm已启动,这里可以先同时手动命令行启动主库两节点dmserver:

[[email protected] bin]$ ./dmserver /dm/data/dsc0_config/dm.ini dcr_ini=/dm/data/dmdsc/dmdcr.ini mount

[[email protected] bin]$ ./dmserver /dm/data/dsc1_config/dm.ini dcr_ini=/dm/data/dmdsc/dmdcr.ini mount

---查看lsn
[[email protected] bin]$ ./disql
disql V8
用户名:
密码:

服务器[LOCALHOST:5236]:处于普通配置状态
登录使用时间: 8.784(毫秒)
SQL> select file_lsn,cur_lsn from v$rlog;

行号     FILE_LSN             CUR_LSN             
---------- -------------------- --------------------
1          51046                51046

4.2 启动备库到mount状态

[[email protected] bin]$ ./dmserver /dm/data/RAC_STB/DAMENG/dm.ini mount

---查看lsn
[[email protected] bin]$ ./disql
disql V8
用户名:
密码:

服务器[LOCALHOST:5236]:处于普通配置状态
登录使用时间: 4.723(毫秒)
SQL> select file_lsn,cur_lsn from v$rlog;

行号     FILE_LSN             CUR_LSN             
---------- -------------------- --------------------
1          51046                51046

已用时间: 13.319(毫秒). 执行号:1.

4.3 配置OGUID并修改主库模式

连接DMDSC集群中的任意一个节点,设置DMDSC主库的OGUID 值.

SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
sp_set_oguid(43333);
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
alter database primary;

4.4 配置OGUID并修改备库模式

SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
sp_set_oguid(43333);
alter database standby;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

4.5 启动主备库守护进程

主库:

节点1:
[[email protected] bin]$ ./dmwatcher /dm/data/dsc0_config/dmwatcher.ini
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY
[!!! Local dmwatcher's INST_ERROR_TIME(30) configured in dmwatcher.ini is smaller than (MIN(DCR_GRP_DSKCHK_CNT, MAL_CHECK_INTERVAL) + 5), adjust it to 35 in memory !!!]

节点2:
[[email protected] bin]$ ./dmwatcher /dm/data/dsc1_config/dmwatcher.ini
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY
[!!! Local dmwatcher's INST_ERROR_TIME(30) configured in dmwatcher.ini is smaller than (MIN(DCR_GRP_DSKCHK_CNT, MAL_CHECK_INTERVAL) + 5), adjust it to 35 in memory !!!]

##警告可以先忽略,稍候将dmwatcher.ini中的INST_ERROR_TIME设置为至少35后重启dmwatcher即可。
##在DMDSC集群中,dmwatcher.ini配置项INST_ERROR_TIME的值,应设置为DCR_GRP_DSKCHK_CNT与MAL_CHECK_INTERVAL中最小值+5

备库:

[[email protected] bin]$ ./dmwatcher /dm/data/RAC_STB/DAMENG/dmwatcher.ini
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY

4.6 配置DMCSSM监视器并启动

在监视器服务器上配置dmcssm.ini文件:

CSSM_OGUID = 63635
#配置所有 CSS 的连接信息,
#和 dmdcr_cfg.ini 中 CSS 配置项的 DCR_EP_HOST 和 DCR_EP_PORT 保持一致
CSSM_CSS_IP = 192.168.25.40:9341
CSSM_CSS_IP = 192.168.25.41:9343
CSSM_LOG_PATH =/dm8/monitor/log #监视器日志文件存放路径
CSSM_LOG_FILE_SIZE = 32 #每个日志文件最大 32M
CSSM_LOG_SPACE_LIMIT = 0 #不限定日志文件总占用空间

启动dmcssm监视器:

[[email protected] bin]$ ./dmcssm ini_path=/dm8/monitor/dmcssm.ini
[monitor]         2020-06-14 11:56:21: CSS MONITOR V8
[monitor]         2020-06-14 11:56:21: CSS MONITOR SYSTEM IS READY.

[monitor]         2020-06-14 11:56:21: Wait CSS Control Node choosed...
[monitor]         2020-06-14 11:56:22: Wait CSS Control Node choosed succeed.

show

monitor current time:2020-06-14 11:58:06, n_group:3
=================== group[name = GRP_CSS, seq = 0, type = CSS, Control Node = 0] ========================================

[CSS0] global info:
[ASM0] auto restart = TRUE
[RAC0] auto restart = FALSE

[CSS1] global info:
[ASM1] auto restart = TRUE
[RAC1] auto restart = FALSE


ep:	css_time               inst_name     seqno     port    mode         inst_status        vtd_status   is_ok        active       guid              ts              
	2020-06-14 11:58:06    CSS0          0         9341    Control Node OPEN               WORKING      OK           TRUE         666876534         666878081       
	2020-06-14 11:58:06    CSS1          1         9343    Normal Node  OPEN               WORKING      OK           TRUE         666877858         666879398       

=================== group[name = GRP_ASM, seq = 1, type = ASM, Control Node = 0] ========================================

n_ok_ep = 2
ok_ep_arr(index, seqno):
(0, 0)
(1, 1)

sta = OPEN, sub_sta = STARTUP
break ep = NULL
recover ep = NULL

crash process over flag is TRUE
ep:	css_time               inst_name     seqno     port    mode         inst_status        vtd_status   is_ok        active       guid              ts              
	2020-06-14 11:58:06    ASM0          0         9349    Control Node OPEN               WORKING      OK           TRUE         666893121         666894598       
	2020-06-14 11:58:06    ASM1          1         9351    Normal Node  OPEN               WORKING      OK           TRUE         666900164         666901634       

=================== group[name = GRP_DSC, seq = 2, type = DB, Control Node = 0] ========================================

n_ok_ep = 2
ok_ep_arr(index, seqno):
(0, 0)
(1, 1)

sta = OPEN, sub_sta = STARTUP
break ep = NULL
recover ep = NULL

crash process over flag is TRUE
ep:	css_time               inst_name     seqno     port    mode         inst_status        vtd_status   is_ok        active       guid              ts              
	2020-06-14 11:58:06    RAC0          0         5236    Control Node OPEN               WORKING      OK           TRUE         2443402795        2443403575      
	2020-06-14 11:58:06    RAC1          1         5236    Normal Node  OPEN               WORKING      OK           TRUE         2443414073        2443414837      

==================================================================================================================

4.7 配置数据守护监视器并启动

在监视器服务器上配置dmmonitor.ini

MON_LOG_PATH = /dm/data/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 64
MON_LOG_SPACE_LIMIT = 0
MON_DW_CONFIRM = 0
[GRP1]
MON_INST_OGUID = 43333
MON_DW_IP = 192.168.25.40:3567/192.168.25.41:3568
MON_DW_IP = 192.168.25.33:3569

启动监视器:

[[email protected] bin]$ ./dmmonitor /dm/monitor/dmmonitor.ini
[monitor]         2020-06-14 11:51:07: DMMONITOR[4.0] V8
[monitor]         2020-06-14 11:51:07: DMMONITOR[4.0] IS READY.

[monitor]         2020-06-14 11:51:07: 收到守护进程(RAC1)消息
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2020-06-14 11:51:08  STARTUP        OK        RAC0             OPEN        PRIMARY   VALID    2        37415           38574           

[monitor]         2020-06-14 11:51:07: 收到守护进程(RAC_STB)消息
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2020-06-14 11:51:06  OPEN           OK        RAC_STB          OPEN        STANDBY   VALID    2        38574           38574           

[monitor]         2020-06-14 11:51:07: 收到守护进程(RAC0)消息
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2020-06-14 11:51:08  OPEN           OK        RAC0             OPEN        PRIMARY   VALID    2        37415           38574     

show
2020-06-14 11:52:39 
#================================================================================#
GROUP            OGUID       MON_CONFIRM     MODE            MPP_FLAG  
GRP1             43333       FALSE           MANUAL          FALSE     


<<DATABASE GLOBAL INFO:>>
IP              MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.25.40   3567         2020-06-14 11:52:39  GLOBAL    VALID     OPEN           RAC0             OK        2     2     OPEN        PRIMARY   DSC_OPEN       REALTIME  VALID    

EP INFO:
INST_PORT  INST_OK   INAME            ISTATUS     IMODE     DSC_SEQNO  DSC_CTL_NODE RTYPE     RSTAT    FSEQ            FLSN            CSEQ            CLSN            DW_STAT_FLAG          
5236       OK        RAC0             OPEN        PRIMARY   0          0            REALTIME  VALID    3943            37415           3943            38574           NONE                  
5236       OK        RAC1             OPEN        PRIMARY   1          0            REALTIME  VALID    2465            38574           2465            38574           NONE                  

<<DATABASE GLOBAL INFO:>>
IP              MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.25.33   3569         2020-06-14 11:52:37  GLOBAL    VALID     OPEN           RAC_STB          OK        1     1     OPEN        STANDBY   DSC_OPEN       REALTIME  VALID    

EP INFO:
INST_PORT  INST_OK   INAME            ISTATUS     IMODE     DSC_SEQNO  DSC_CTL_NODE RTYPE     RSTAT    FSEQ            FLSN            CSEQ            CLSN            DW_STAT_FLAG          
5236       OK        RAC_STB          OPEN        STANDBY   0          0            REALTIME  VALID    3939            38574           3939            38574           NONE                  

DATABASE(RAC_STB) APPLY INFO FROM (RAC0):
DSC_SEQNO[0], (ASEQ, SSEQ, KSEQ)[3943, 3943, 3943], (ALSN, SLSN, KLSN)[37415, 37415, 37415], N_TSK[0], TSK_MEM_USE[0]
DSC_SEQNO[1], (ASEQ, SSEQ, KSEQ)[2465, 2465, 2465], (ALSN, SLSN, KLSN)[38574, 38574, 38574], N_TSK[0], TSK_MEM_USE[0]


#================================================================================#

4.8 注册相关系统服务

主库两节点注册dmcss服务:

1、修改dmdcr.ini配置文件,内容如下:

DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/dm/data/dmdsc/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 60
DMDCR_ASM_STARTUP_CMD = /dm/dmdbms/bin/dmasmsvr dcr_ini=/dm/data/dmdsc/dmdcr.ini
#DB 重启参数,命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 60
DMDCR_DB_STARTUP_CMD = /dm/dmdbms/bin/dmserver path=/dm/data/dsc0_config/dm.ini dcr_ini=/dm/data/dmdsc/dmdcr.ini mount

2、使用dm_service_installer.sh 脚本注册DMCSS系统服务(root用户)

节点1:
[[email protected] ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmcss -dcr_ini /dm/data/dmdsc/dmdcr.ini -p RAC0
Created symlink from /etc/systemd/system/multi-user.target.wants/DmCSSServiceRAC0.service to /usr/lib/systemd/system/DmCSSServiceRAC0.service.
创建服务(DmCSSServiceRAC0)完成

节点2:
[[email protected] ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmcss -dcr_ini /dm/data/dmdsc/dmdcr.ini -p RAC1
Created symlink from /etc/systemd/system/multi-user.target.wants/DmCSSServiceRAC1.service to /usr/lib/systemd/system/DmCSSServiceRAC1.service.
创建服务(DmCSSServiceRAC1)完成

3、注册dmwatcher服务

主库节点1:
[[email protected] ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -watcher_ini /dm/data/dsc0_config/dmwatcher.ini -p RAC0
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceRAC0.service to /usr/lib/systemd/system/DmWatcherServiceRAC0.service.
创建服务(DmWatcherServiceRAC0)完成

主库节点2:
[[email protected] ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -watcher_ini /dm/data/dsc1_config/dmwatcher.ini -p RAC1
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceRAC1.service to /usr/lib/systemd/system/DmWatcherServiceRAC1.service.
创建服务(DmWatcherServiceRAC1)完成

备库:
[[email protected] ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -watcher_ini /dm/data/RAC_STB/DAMENG/dmwatcher.ini -p RAC_STB
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceRAC_STB.service to /usr/lib/systemd/system/DmWatcherServiceRAC_STB.service.
创建服务(DmWatcherServiceRAC_STB)完成

4.9 测试

主库创建测试表:

[[email protected] bin]$ ./disql sysdba/[email protected]

服务器[192.168.15.40:5236]:处于主库打开状态
登录使用时间: 7.319(毫秒)
disql V8
SQL> create table test as select 11;
操作已执行
已用时间: 167.394(毫秒). 执行号:5.
SQL> select * from test;

行号     11         
---------- -----------
1          11

已用时间: 5.323(毫秒). 执行号:6.

备库查询:

[[email protected] bin]$ ./disql
disql V8
用户名:
密码:

服务器[LOCALHOST:5236]:处于备库打开状态
登录使用时间: 4.727(毫秒)
SQL> 
SQL> select * from test;

行号     11         
---------- -----------
1          11

已用时间: 6.014(毫秒). 执行号:5.

至此,主备搭建完成。

相关标签: 达梦