1、准备共享磁盘sdb。
[root@server01 ~]# fdisk -l
Disk /dev/sdb: 21.5 GB, 21474836480 bytes, 41943040 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
2、对sdb进行分区。
[root@server01 ~]# fdisk /dev/sdb
依次输入 n-->p-->1 回车 +1G 回车，完成第一块磁盘划分
依次输入 n-->p-->2 回车 +1G 回车，完成第二块磁盘划分
依次输入 n-->p-->3 回车 +8G 回车，完成第三块磁盘划分
依次输入 n-->p--> 回车 回车 回车，完成第四块磁盘划分
最后输入 w 保存分区设置
登录另外两台服务器查看分区情况
有sdb1-sdb4就正常
[root@server01 ~]# fdisk -l
Disk /dev/sdb: 21.5 GB, 21474836480 bytes, 41943040 sectors
Device Boot Start End Blocks Id System
/dev/sdb1 2048 206847 102400 83 Linux
/dev/sdb2 206848 411647 102400 83 Linux
/dev/sdb3 411648 21383167 10485760 83 Linux
/dev/sdb4 21383168 41943039 10279936 83 Linux
3、udev 方式绑定裸设备。
两台服务器都新建如下规则
[root@server01 ~]# vim /etc/udev/rules.d/70-persistent-ipoib.rules
ACTION=="add",KERNEL=="sdb1",RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add",KERNEL=="sdb2",RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add",KERNEL=="sdb3",RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add",KERNEL=="sdb4",RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add",KERNEL=="raw[1-4]", OWNER="dmdba", GROUP="dinstall", MODE="660"
[root@server01 ~]# scp /etc/udev/rules.d/70-persistent-ipoib.rules 192.168.118.102:/etc/udev/rules.d/70-persistent-ipoib.rules
[root@server01 ~]# partprobe /dev/sdb
[root@server01 ~]# udevadm control --reload-rules
[root@server01 ~]# udevadm trigger --type=devices --action=change
[root@server01 ~]# ll /dev/raw/
total 0
crw-rw----. 1 dmdba dinstall 162, 1 May 6 21:43 raw1
crw-rw----. 1 dmdba dinstall 162, 2 May 6 21:43 raw2
crw-rw----. 1 dmdba dinstall 162, 3 May 6 21:43 raw3
crw-rw----. 1 dmdba dinstall 162, 4 May 6 21:43 raw4
crw-rw----. 1 root disk 162, 0 May 6 21:43 rawctl
4、配置 DCR 初始化配置文件。
依次登录两台服务器，切换至dmdba用户下，在数据库安装目录下新建一个config目录
[root@server01 ~]# su - dmdba
[dmdba@server01 opt]$ cd /opt/dmdbms/
[dmdba@server01 dmdbms]$ mkdir config
[dmdba@server01 dmdbms]$ vim /opt/dmdbms/config/dmdcr_cfg.ini
[dmdba@server01 dmdbms]$ cat /opt/dmdbms/config/dmdcr_cfg.ini
DCR_N_GRP = 3
DCR_VTD_PATH = /dev/raw/raw2
DCR_OGUID = 63635
[GRP]
DCR_GRP_TYPE = CSS
DCR_GRP_NAME = CSS
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 192.168.118.101
DCR_EP_PORT = 9341
[CSS]
DCR_EP_NAME = CSS2
DCR_EP_HOST = 192.168.118.102
DCR_EP_PORT = 9343
[GRP]
DCR_GRP_TYPE = ASM
DCR_GRP_NAME = ASM
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 93360
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.118.101
DCR_EP_PORT = 9349
DCR_EP_ASM_LOAD_PATH = /dev/raw
[ASM]
DCR_EP_NAME = ASM2
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.118.102
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP]
DCR_GRP_TYPE = DB
DCR_GRP_NAME = DSC
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[DSC]
DCR_EP_NAME = DSC1
DCR_EP_SEQNO = 0
DCR_EP_PORT = 5700
DCR_CHECK_PORT = 9741
[DSC]
DCR_EP_NAME = DSC2
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5700
DCR_CHECK_PORT = 9742
[dmdba@server01 config]$ scp /opt/dmdbms/config/dmdcr_cfg.ini 192.168.118.102:/opt/dmdbms/config/dmdcr_cfg.ini
5、创建 ASM 磁盘。
使用 dmdba 用户，到 DM 数据库软件安装目录的 bin 目录执行以下命令（只需在一个节点执行）。
[dmdba@server01 config]$ cd /opt/dmdbms/bin/
[dmdba@server01 bin]$ dmasmcmd
DMASMCMD V8
ASM>create dcrdisk '/dev/raw/raw1' 'DCR'
ASM>create votedisk '/dev/raw/raw2' 'VOTE'
ASM>create asmdisk '/dev/raw/raw3' 'LOG'
ASM>create asmdisk '/dev/raw/raw4' 'DATA'
ASM>init dcrdisk '/dev/raw/raw1' from '/opt/dmdbms/config/dmdcr_cfg.ini' identified by '123456'
ASM>init votedisk '/dev/raw/raw2' from '/opt/dmdbms/config/dmdcr_cfg.ini'
ASM>exit
6、配置ASM的MAL系统配置文件。
2个节点都需要配置
节点1 dmasvrmal.ini:
[dmdba@server01 config]$ vim /opt/dmdbms/config/dmasvrmal.ini
[dmdba@server01 config]$ cat /opt/dmdbms/config/dmasvrmal.ini
[MAL_INST1]
MAL_INST_NAME = ASM1
MAL_HOST = 192.168.118.101
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM2
MAL_HOST = 192.168.118.102
MAL_PORT = 7237
节点2 dmasvrmal.ini:：
[dmdba@server02 ~]$ vim /opt/dmdbms/config/dmasvrmal.ini
[dmdba@server02 ~]$ cat /opt/dmdbms/config/dmasvrmal.ini
[MAL_INST1]
MAL_INST_NAME = ASM1
MAL_HOST = 192.168.118.101
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM2
MAL_HOST = 192.168.118.102
MAL_PORT = 7237
节点1 dmdcr.ini：
[dmdba@server01 ~]$ vim /opt/dmdbms/config/dmdcr.ini
[dmdba@server01 ~]$ cat /opt/dmdbms/config/dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH = /opt/dmdbms/config/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置件路径
DMDCR_SEQNO = 0 #ASM 重启参数，命令行方式启动
DMDCR_ASM_RESTART_INTERVAL =0 #为0，不自动拉起dmasm
DMDCR_ASM_STARTUP_CMD = /opt/dmdbms/bin/dmasmsvr dcr_ini=/opt/dmdbms/config/dmdcr.ini #DB 重启参数，命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 0 #为0，不自动拉起dmserver
DMDCR_DB_STARTUP_CMD = /opt/dmdbms/bin/dmserver path=/opt/dmdbms/config/dsc1/dm.ini dcr_ini=/opt/dmdbms/config/dmdcr.ini
节点2 dmdcr.ini：
[dmdba@server02 ~]$ vim /opt/dmdbms/config/dmdcr.ini
[dmdba@server02 ~]$ cat /opt/dmdbms/config/dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/opt/dmdbms/config/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 1 #ASM 重启参数，命令行方式启动
DMDCR_ASM_RESTART_INTERVAL =0
DMDCR_ASM_STARTUP_CMD = /opt/dmdbms/bin/dmasmsvr dcr_ini=/opt/dmdbms/config/dmdcr.ini #DB 重启参数，命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /opt/dmdbms/bin/dmserver path=/opt/dmdbms/config/dsc2/dm.ini dcr_ini=/opt/dmdbms/config/dmdcr.ini
7、启动DMCSS服务。
[dmdba@server01 ~]$ cd /opt/dmdbms/bin
[dmdba@server01 bin]$ dmcss DCR_INI=/opt/dmdbms/config/dmdcr.ini
DMCSS V8
DMCSS IS READY
[2022-05-07 15:32:39:494] [CSS]: 设置EP CSS1[0]为控制节点
[2022-05-07 15:33:43:415] [ASM]: 设置EP ASM1[0]为控制节点
[dmdba@server02 ~]$ cd /opt/dmdbms/bin
[dmdba@server02 bin]$ dmcss DCR_INI=/opt/dmdbms/config/dmdcr.ini
DMCSS V8
DMCSS IS READY
[2022-05-07 15:32:45:278] [CSS]: 设置EP CSS1[0]为控制节点
8、启动ASM服务。
[dmdba@server01 ~]$ cd /opt/dmdbms/bin
[dmdba@server01 bin]$ dmasmsvr DCR_INI=/opt/dmdbms/config/dmdcr.ini
ASM SELF EPNO:0
DMASMSVR V8
dmasmsvr task worker thread startup
the ASM server is Ready.
check css cmd: START NOTIFY, cmd_seq: 2
check css cmd: EP START, cmd_seq: 3
[dmdba@server02 ~]$ cd /opt/dmdbms/bin
[dmdba@server02 bin]$ dmasmsvr DCR_INI=/opt/dmdbms/config/dmdcr.ini
ASM SELF EPNO:1
DMASMSVR V8
dmasmsvr task worker thread startup
the ASM server is Ready.
check css cmd: EP START, cmd_seq: 5
9、创建ASM磁盘组。
[dmdba@server01 ~]$ dmasmtool dcr_ini=/opt/dmdbms/config/dmdcr.ini
ASM>create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
ASM>create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'
ASM>exit
~
10、配置集群数据库dminit控制文件。
[dmdba@server01 ~]$ vim /opt/dmdbms/config/dminit.ini
[dmdba@server01 ~]$ cat /opt/dmdbms/config/dminit.ini
db_name = DSC
system_path = +DMDATA/data
system = +DMDATA/data/dsc/system.dbf
system_size = 128
roll = +DMDATA/data/dsc/roll.dbf
roll_size = 128
main = +DMDATA/data/dsc/main.dbf
main_size = 128
ctl_path = +DMDATA/data/dsc/dm.ctl
ctl_size = 8
PAGE_SIZE = 32
log_size = 1024
dcr_path = /dev/raw/raw1 #dcr 磁盘路径，目前不支持 asm，只能是裸设备
dcr_seqno = 0
auto_overwrite= 1
[DSC1] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应
config_path = /opt/dmdbms/config/dsc1
port_num = 5700
mal_host = 192.168.118.101
mal_port = 9255
log_path = +DMLOG/log/DSC1_log01.log
log_path = +DMLOG/log/DSC1_log02.log
[DSC2] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应
config_path = /opt/dmdbms/config/dsc2
port_num = 5700
mal_host = 192.168.118.102
mal_port = 9266
log_path = +DMLOG/log/DSC2_log01.log
log_path = +DMLOG/log/DSC2_log02.log
复制dminit控制文件到节点2上
[dmdba@server01 ~]$ scp /opt/dmdbms/config/dminit.ini 192.168.118.102:/opt/dmdbms/config/dminit.ini
11、节点1上初始化实例。
[dmdba@server01 ~]$ cd /opt/dmdbms/bin
[dmdba@server01 ~]$ dminit control=/opt/dmdbms/config/dminit.ini
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2022-09-24
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
log file path: +DMLOG/log/DSC1_log01.log
log file path: +DMLOG/log/DSC1_log02.log
log file path: +DMLOG/log/DSC2_log01.log
log file path: +DMLOG/log/DSC2_log02.log
write to dir [+DMDATA/data/DSC].
create dm database success. 2022-05-07 15:39:19
初始化完成后会在 init 控制文件配置的目录下生成 2 个实例的配置文件：
[dmdba@server01 config]$ pwd
/opt/dmdbms/config
[dmdba@server01 config]$ ls
dmasvrmal.ini dmdcr_cfg.ini dmdcr.ini dminit.ini DSC dsc1 dsc2
将 dsc2 目录复制到节点 2 上对应的目录下
[dmdba@server01 config]$ scp -r /opt/dmdbms/config/dsc2 192.168.118.102:/opt/dmdbms/config/dsc2
[dmdba@server02 ~]$ cd /opt/dmdbms/config
[dmdba@server02 config]$ ls
dmasvrmal.ini dmdcr_cfg.ini dmdcr.ini dminit.ini dsc2
12、启动dmserver。
两个节点都进入数据库安装目录bin下，使用 dmdba 用户执行以下命令，日志有SYSTEM IS READY就启动成功。
节点1
[dmdba@server01 bin]$ dmserver /opt/dmdbms/config/dsc1/dm.ini dcr_ini=/opt/dmdbms/config/dmdcr.ini
file dm.key not found, use default license!
version info: develop
DM Database Server x64 V8 1-2-70-21.09.24-147898-10028-ENT startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire on 2022-09-24
……
pseg recv finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
节点2
[dmdba@server02 config]$ dmserver /opt/dmdbms/config/dsc2/dm.ini dcr_ini=/opt/dmdbms/config/dmdcr.ini
file dm.key not found, use default license!
version info: develop
DM Database Server x64 V8 1-2-70-21.09.24-147898-10028-ENT startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire on 2022-09-24
13、配置监视器查看集群情况。
任选一个节点配置(也可两个节点都配置，查看状态时任意一台启动监视器即可)
[dmdba@server01 config]$ vim /opt/dmdbms/config/dmcssm.ini
#和 dmdcr_cfg.ini 中的 DCR_OGUID 保持一致
CSSM_OGUID = 63635
#配置所有 CSS 的连接信息，
#和 dmdcr_cfg.ini 中 CSS 配置项的 DCR_EP_HOST 和 DCR_EP_PORT 保持一致
CSSM_CSS_IP = 192.168.118.101:9341
CSSM_CSS_IP = 192.168.118.102:9343
CSSM_LOG_PATH =/opt/dmdbms/log #监视器日志文件存放路径
CSSM_LOG_FILE_SIZE = 256 #每个日志文件最大 1024 MB
CSSM_LOG_SPACE_LIMIT = 2048 #限定日志文件总占用空间
启动监视器，dmdba 用户执行，到数据库软件安装目录 bin 下执行以下命令：
[dmdba@server01 config]$ dmcssm ini_path=/opt/dmdbms/config/dmcssm.ini
[monitor] 2022-05-07 16:44:33: CSS MONITOR V8
[monitor] 2022-05-07 16:44:33: CSS MONITOR SYSTEM IS READY.
[monitor] 2022-05-07 16:44:33: Wait CSS Control Node choosed...
[monitor] 2022-05-07 16:44:34: Wait CSS Control Node choosed succeed.
help
DMCSSM使用说明:
SHOW命令中可以通过指定group_name获取指定组的信息，如果没有指定，则显示所有组的信息
---------------------------------------------------------------------------------------------
1.help --显示帮助
2.show [group_name] --显示指定的组信息
3.show config --显示配置文件信息
4.show monitor --显示当前连接的监视器信息
5.set group_name auto restart on --打开指定组的自动拉起功能(只修改dmcss内存值)
6.set group_name auto restart off --关闭指定组的自动拉起功能(只修改dmcss内存值)
7.open force group_name --强制OPEN指定的ASM或DB组
8.ep startup group_name --启动指定的ASM或DB组
9.ep stop group_name --停止指定的ASM或DB组
10.ep halt group_name.ep_name --强制退出指定组的指定节点
11.extend node --扩展集群节点
12.ep crash group_name.ep_name --设定指定节点故障
13.check crash over group_name --检查指定组故障处理是否结束
14.exit --退出监视器
---------------------------------------------------------------------------------------------
show
monitor current time:2022-05-07 16:46:01, n_group:3
=================== group[name = CSS, seq = 0, type = CSS, Control Node = 0] ========================================
[CSS1] auto check = TRUE, global info:
[ASM1] auto restart = FALSE
[DSC1] auto restart = FALSE
[CSS2] auto check = TRUE, global info:
[ASM2] auto restart = FALSE
[DSC2] auto restart = FALSE
ep:css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts
2022-05-07 16:46:01 CSS1 0 9341 Control Node OPEN WORKING OK TRUE 814222959 814227319
2022-05-07 16:46:01 CSS2 1 9343 Normal Node OPEN WORKING OK TRUE 814224801 814229162
=================== group[name = 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
2022-05-07 16:46:01 ASM1 0 9349 Control Node OPEN WORKING OK TRUE 814243194 814247493
2022-05-07 16:46:01 ASM2 1 9351 Normal Node OPEN WORKING OK TRUE 814244236 814248534
=================== group[name = 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
2022-05-07 16:46:01 DSC1 0 5700 Control Node OPEN WORKING OK TRUE 643987850 643988471
2022-05-07 16:46:01 DSC2 1 5700 Normal Node OPEN WORKING OK TRUE 644031032 644031512
==================================================================================================================
14、数据一致性测试。
节点1建表：
[dmdba@server01 bin]$ disql sysdba/SYSDBA@192.168.118.101:5700
服务器[192.168.118.101:5700]:处于普通打开状态
SQL> select * from v$dsc_ep_info;
行号 EP_NAME EP_SEQNO EP_GUID EP_TIMESTAMP EP_MODE EP_STATUS
---------- ------- ----------- -------------------- -------------------- ------------ ---------
1 DSC1 0 643987850 643989181 Control Node OK
2 DSC2 1 644031032 644032222 Normal Node OK
SQL> select name,INSTANCE_NAME,STATUS$,HOST_NAME from v$instance;
行号 NAME INSTANCE_NAME STATUS$ HOST_NAME
---------- ---- ------------- ------- ---------
1 DSC1 DSC1 OPEN server01
SQL> create table test(id number);
SQL> insert into test values(1);
SQL> commit;
SQL> select * from test;
行号 ID
---------- --
1 1
节点2查询：
[dmdba@server02 ~]$ disql sysdba/SYSDBA@192.168.118.102:5700
SQL> select name,INSTANCE_NAME,STATUS$,HOST_NAME from v$instance;
行号 NAME INSTANCE_NAME STATUS$ HOST_NAME
---------- ---- ------------- ------- ---------
1 DSC2 DSC2 OPEN server02
SQL> select * from test;
行号 ID
---------- --
1 1
查询到的结果与节点1一致。
15、集群服务连续性测试。
通过第3个节点客户端连接DSC数据库。
[dmdba@server03 ~]$ vim /etc/dm_svc.conf
TIME_ZONE=(480)
LANGUAGE=(cn)
dmdsc=(192.168.118.101:5700,192.168.118.102:5700)
[dmdba@server02 ~]$ disql sysdba/SYSDBA@dmdsc
SQL>insert into test values(2);
SQL>/
SQL>/
模拟主节点网络故障，杀掉DSC1节点数据库进程。
[dmdba@server01 ~]$ ps -elf|grep dmserver
0 S dmdba 13571 1 1 80 0 - 1042154 n_tty_ 22:13 ? 00:00:08 /opt/dmdbms/bin/dmserver path=/opt/dmdbms/config/dsc1/dm.ini dcr_ini=/opt/dmdbms/config/dmdcr.ini
[dmdba@server01 ~]$ kill -9 13571
客户端卡顿了几秒后仍可连续重复插入数据，切会话一直未中断。
从DMCSS的监控监控日志中可以看到，DSC1故障后DMCSS完成了如下几个操作：
1.检测到DSC1出现故障，标记DSC1为故障状态。
2.设置DSC2为控制节点。
3.重启实例DSC1。
4.将DSC1重新加入EP
5.故障EP恢复结束。
6.设置EP DSC1[0]为控制节点。
7.故障处理已完成。
DMCSS日志如下：
[CSS1] [2022-05-07 22:25:54:866] [DB]: 检测到EP DSC1[0]故障在PROCESS_LINK_CHECK中
[CSS1] [2022-05-07 22:25:54:943] [DB]: 设置EP DSC1[0]为故障EP
[CSS1] [2022-05-07 22:25:56:090] [DB]: 设置EP DSC2[1]为控制节点
[CSS1] [2022-05-07 22:25:56:155] [DB]: 设置命令[EP_CRASH], 目标站点 DSC2[1], 命令序号[47]
[CSS1] [2022-05-07 22:26:02:119] [DB]: 设置命令[NONE], 目标站点 DSC2[1], 命令序号[0]
[CSS1] [2022-05-07 22:26:02:122] [DB]: 命令[EP_CRASH]处理结束
[CSS1] [2022-05-07 22:26:02:530] [DB]: 设置命令[CMD CLEAR], 目标站点 DSC2[1], 命令序号[50]
[CSS1] [2022-05-07 22:26:05:832] [CSS]: 设置命令[CONFIG VIP], 目标站点 CSS2[1], 命令序号[3]
[CSS1] [2022-05-07 22:26:07:878] [DB]: 设置命令[CONFIG VIP], 目标站点 DSC2[1], 命令序号[55]
[CSS1] [2022-05-07 22:26:08:915] [DB]: 设置命令[NONE], 目标站点 DSC2[1], 命令序号[0]
[CSS1] [2022-05-07 22:26:08:919] [DB]: 命令[CONFIG VIP]处理结束
[CSS1] [2022-05-07 22:27:16:124] [CSS]: 重启本地DB实例，命令：[/opt/dmdbms/bin/dmserver path=/opt/dmdbms/config/dsc1/dm.ini dcr_ini=/opt/dmdbms/config/dmdcr.ini]
[CSS1] [2022-05-07 22:27:26:238] [DB]: 设置EP DSC1[0]为故障重加入EP
[CSS1] [2022-05-07 22:27:26:267] [DB]: 设置命令[START NOTIFY], 目标站点 DSC1[0], 命令序号[60]
[CSS1] [2022-05-07 22:27:27:321] [DB]: 设置命令[SUSPEND EP WORKER THREAD], 目标站点 DSC2[1], 命令序号[61]
[CSS1] [2022-05-07 22:27:30:371] [DB]: 暂停工作线程结束
[CSS1] [2022-05-07 22:27:30:615] [DB]: 设置命令[DCR_LOAD], 目标站点 DSC1[0], 命令序号[62]
[CSS1] [2022-05-07 22:27:30:627] [DB]: 设置命令[DCR_LOAD], 目标站点 DSC2[1], 命令序号[63]
[CSS1] [2022-05-07 22:27:31:806] [DB]: 故障EP重新加入DSC结束
[CSS1] [2022-05-07 22:27:31:816] [DB]: 设置命令[ERROR EP ADD], 目标站点 DSC1[0], 命令序号[65]
[CSS1] [2022-05-07 22:27:31:849] [DB]: 设置命令[ERROR EP ADD], 目标站点 DSC2[1], 命令序号[66]
[CSS1] [2022-05-07 22:27:32:970] [DB]: 故障EP重新加入DSC结束
[CSS1] [2022-05-07 22:27:32:971] [DB]: 设置命令[EP RECV], 目标站点 DSC2[1], 命令序号[68]
[CSS1] [2022-05-07 22:27:34:038] [DB]: 故障EP恢复结束
[CSS1] [2022-05-07 22:27:34:040] [DB]: 设置命令[EP START], 目标站点 DSC1[0], 命令序号[70]
[CSS1] [2022-05-07 22:27:35:118] [DB]: 设置命令[EP START2], 目标站点 DSC1[0], 命令序号[72]
[CSS1] [2022-05-07 22:27:40:633] [DB]: 设置命令[ADJUST MASTER EP], 目标站点 DSC1[0], 命令序号[74]
[CSS1] [2022-05-07 22:27:40:643] [DB]: 设置命令[ADJUST MASTER EP], 目标站点 DSC2[1], 命令序号[75]
[CSS1] [2022-05-07 22:27:41:795] [DB]: 设置EP DSC1[0]为控制节点
[CSS1] [2022-05-07 22:27:41:797] [DB]: 设置命令[EP OPEN], 目标站点 DSC1[0], 命令序号[77]
[CSS1] [2022-05-07 22:27:42:953] [DB]: 设置命令[NONE], 目标站点 DSC1[0], 命令序号[0]
[CSS1] [2022-05-07 22:27:42:975] [DB]: 设置命令[RESUME EP WORKER THREAD], 目标站点 DSC2[1], 命令序号[79]
[CSS1] [2022-05-07 22:27:44:129] [DB]: 继续工作线程结束
[CSS1] [2022-05-07 22:27:44:148] [DB]: 设置命令[NONE], 目标站点 DSC2[1], 命令序号[0]
[CSS1] [2022-05-07 22:27:44:173] [DB]: 设置命令[EP REAL OPEN], 目标站点 DSC1[0], 命令序号[81]
[CSS1] [2022-05-07 22:27:45:253] [DB]: 设置命令[NONE], 目标站点 DSC1[0], 命令序号[0]
[CSS1] [2022-05-07 22:27:46:282] [DB]: 上次故障处理未真正完成，不允许故障ep重加入
[CSS1] [2022-05-07 22:27:50:555] [DB]: 上次故障处理已完成，允许故障ep重加入
16、集群管理工具的使用。
启动DMCSS工具：
[dmdba@server01 ~]$ dmcssm ini_path=/opt/dmdbms/config/dmcssm.ini
[monitor] 2022-05-07 22:08:03: CSS MONITOR V8
[monitor] 2022-05-07 22:08:03: CSS MONITOR SYSTEM IS READY.
通过DMCSS工具启动ASM实例：
===============================================================================
ep startup ASM
[monitor] 2022-05-07 22:10:22: 通知CSS(seqno:0)执行EP STARTUP(ASM1)
[monitor] 2022-05-07 22:10:30: 通知CSS(seqno:0)执行EP STARTUP(ASM1)成功
[monitor] 2022-05-07 22:10:30: 通知CSS(seqno:1)执行EP STARTUP(ASM2)
[monitor] 2022-05-07 22:10:38: 通知CSS(seqno:1)执行EP STARTUP(ASM2)成功
[monitor] 2022-05-07 22:10:38: 当前不存在活动的CSS或者活动CSS不符合执行条件
[monitor] 2022-05-07 22:10:38: 通知当前活动的CSS执行清理操作
[monitor] 2022-05-07 22:10:39: 清理CSS(0)请求成功
[monitor] 2022-05-07 22:10:39: 清理CSS(1)请求成功
通过DMCSS工具启动DSC实例：
===============================================================================
ep startup DSC
[monitor] 2022-05-07 22:13:11: 通知CSS(seqno:0)执行EP STARTUP(DSC1)
[monitor] 2022-05-07 22:13:20: 通知CSS(seqno:0)执行EP STARTUP(DSC1)成功
[monitor] 2022-05-07 22:13:20: 通知CSS(seqno:1)执行EP STARTUP(DSC2)
[monitor] 2022-05-07 22:13:36: 通知CSS(seqno:1)执行EP STARTUP(DSC2)成功
[monitor] 2022-05-07 22:13:36: 通知CSS(seqno:0)打开节点(DSC1)的自动拉起功能
[monitor] 2022-05-07 22:13:36: 通知CSS(seqno:0)打开节点(DSC1)的自动拉起功能成功
[monitor] 2022-05-07 22:13:36: 通知CSS(seqno:1)打开节点(DSC2)的自动拉起功能
[monitor] 2022-05-07 22:13:36: 通知CSS(seqno:1)打开节点(DSC2)的自动拉起功能成功
[monitor] 2022-05-07 22:13:36: 打开CSS自动拉起功能成功
[monitor] 2022-05-07 22:13:36: 通知当前活动的CSS执行清理操作
[monitor] 2022-05-07 22:13:36: 清理CSS(0)请求成功
[monitor] 2022-05-07 22:13:37: 清理CSS(1)请求成功
[monitor] 2022-05-07 22:13:37: 命令EP STARTUP DSC执行成功
社区地址：https://eco.dameng.com
