第三章 DMDSC+DW单机搭建
文章目录
六、DMDSC+DW单机搭建
6.1、集群规划
服务器配置信息
6.2、备份DSC数据库
A机器
[dmdba@dmdsc01 ~]$ dmrman use_ap=2 dcr_ini=/dm8/dsc/config/dmdcr.ini
RMAN> BACKUP DATABASE '/dm8/dsc/config/dsc0_config/dm.ini' FULL BACKUPSET '/dm8/dsc/bak/BACKUP_FILE3';
[dmdba@dmdsc01 ~]$ scp -r /opt/dsc/bak/BACKUP_FILE3 dmdba@192.168.10.102:/dm8/
6.3、初始化实例，还原数据
C机器
--初始化实例
[dmdba@dmdw01 dm8]$dminit path=/dm8/data PAGE_SIZE=32 CASE_SENSITIVE=Y CHARSET=0 LOG_SIZE=2048
--启动服务并退出
[dmdba@dmdw01 dm8]$ /dm8/bin/dmserver /dm8/data/DAMENG/dm.ini
--还原数据
[dmdba@dmdw01 dm8]$ dmrman use_ap=2
dmrman V8
RMAN> restore database '/dm8/data/DAMENG/dm.ini' from backupset '/dm8/BACKUP_FILE3'
restore database '/dm8/data/DAMENG/dm.ini' from backupset '/dm8/BACKUP_FILE'
file dm.key not found, use default license!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]
restore successfully.
time used: 00:00:02.671
RMAN>
RMAN> recover database '/dm8/data/DAMENG/dm.ini' from backupset '/dm8/BACKUP_FILE3'
recover database '/dm8/data/DAMENG/dm.ini' from backupset '/dm8/BACKUP_FILE'
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[84680], file_lsn[84680]
备份集[/dm8/BACKUP_FILE]备份过程中未产生日志
recover successfully!
time used: 306.495(ms)
RMAN> recover database '/dm8/data/DAMENG/dm.ini' update db_magic
recover database '/dm8/data/DAMENG/dm.ini' update db_magic
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[84680], file_lsn[84680]
recover successfully!
time used: 00:00:01.042
6.4、修改dm.ini相关参数
A机器、B机器该配置相同
A机器：[dmdba@dmdsc01 ~]$ vi /dm8/dsc/config/dsc0_config/dm.ini
B机器：[dmdba@dmdsc02 ~]$ vi /dm8/dsc/config/dsc1_config/dm.ini
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 次的日志发送信息
C机器
[dmdba@dmdw01 DAMENG]$ vi /dm8/data/DAMENG/dm.ini
INSTANCE_NAME = DW1_01
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64
6.5、创建dmarch.ini文件
A机器（主要添加红色部分）
[dmdba@dmdsc02 ~]$ vi /dm8/dsc/config/dsc0_config/dmarch.ini
[ARCHIVE_LOCAL]
ARCH_TYPE = LOCAL
ARCH_DEST = /opt/dsc/arch_0
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 51200
[ARCHIVE_REMOTE]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC1
ARCH_INCOMING_PATH = /opt/dsc/arch_0_remote
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 51200
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DW1_01
B机器（主要添加红色部分）
[dmdba@dmdsc02 ~]$ vi /dm8/dsc/config/dsc1_config/dmarch.ini
[ARCHIVE_LOCAL]
ARCH_TYPE = LOCAL
ARCH_DEST = /opt/dsc/arch_1
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 51200
[ARCHIVE_REMOTE]
ARCH_TYPE = REMOTE
ARCH_DEST = DSC0
ARCH_INCOMING_PATH = /opt/dsc/arch_1_remote
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 51200
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DW1_01
C机器
[dmdba@dmdw01 ~]$ vi /dm8/data/DAMENG/dmarch.ini
[ARCHIVE_LOCAL]
ARCH_TYPE = LOCAL
ARCH_DEST = /opt/dmdbms/data/DAMENG/arch
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 102400
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DSC0/DSC1
--注意：DMDSC 集群可以作为主库，也可以作为实时备库、即时备库或者异步备库，当DMDSC集群作为备库配置在数据守护系统中时，要将DMDSC集群作为一个整体配置在源库的dmarch.ini 中，也就是 DMDSC 集群所有节点要配置在同一个归档配置项中，每个节点实例名以“/”分隔开来。
6.6、替换dmmal.ini文件
A机器、B机器、C机器配置相同
A机器：[dmdba@dmdsc01 ~]$ vi /dm8/dsc/config/dsc0_config/dmmal.ini
B机器：[dmdba@dmdsc02 ~]$ vi /dm8/dsc/config/dsc1_config/dmmal.ini
C机器：[dmdba@dmdw01 ~]$ vi /dm8/data/DAMENG/dmmal.ini
MAL_CHECK_INTERVAL = 30 #MAL链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 10 #判定MAL链路断开的时间
[MAL_INST0]
MAL_INST_NAME = DSC0 #实例名，和 dm.ini的INSTANCE_NAME一致
MAL_HOST = 192.168.10.100 #MAL系统监听TCP连接的IP地址
MAL_PORT = 5736 #MAL系统监听TCP连接的端口
MAL_INST_HOST = 192.168.2.100 #实例的对外服务IP地址
MAL_INST_PORT = 5236 #实例对外服务端口，和dm.ini的PORT_NUM一致
MAL_DW_PORT = 5836 #实例对应的守护进程监听TCP连接的端口
MAL_INST_DW_PORT = 5936 #实例监听守护进程TCP连接的端口
[MAL_INST1]
MAL_INST_NAME = DSC1
MAL_HOST = 192.168.10.101
MAL_PORT = 5737
MAL_INST_HOST = 192.168.2.101
MAL_INST_PORT = 5236
MAL_DW_PORT = 5837
MAL_INST_DW_PORT = 5937
[MAL_INST2]
MAL_INST_NAME = DW1_01
MAL_HOST = 192.168.10.102
MAL_PORT = 5738
MAL_INST_HOST = 192.168.2.102
MAL_INST_PORT = 5236
MAL_DW_PORT = 5838
MAL_INST_DW_PORT = 5938
6.7、创建dmwatcher.ini文件
A机器
[dmdba@dmdsc01 ~]$ vi /dm8/dsc/config/dsc0_config/dmwatcher.ini
[GDSCDW1]
DW_TYPE = GLOBAL #全局守护类型
DW_MODE = MANUAL #手动切换模式
DW_ERROR_TIME = 60 #远程守护进程故障认定时间
INST_ERROR_TIME = 35 #本地实例故障认定时间
INST_RECOVER_TIME = 60 #主库守护进程启动恢复的间隔时间
INST_OGUID = 45332 #守护系统唯一OGUID值
INST_INI = /dm8/dsc/config/dsc0_config/dm.ini #dm.ini文件路径
DCR_INI = /dm8/dsc/config/dmdcr.ini #dmdcr.ini文件路径
INST_STARTUP_CMD = /dm8/dsc/bin/dmserver #命令行方式启动
INST_AUTO_RESTART = 0 #关闭实例的自动启动功能
RLOG_SEND_THRESHOLD = 0 #指定主库发送日志到备库的时间阈值，默认关闭
RLOG_APPLY_THRESHOLD = 0 #指定备库重演日志的时间阈值，默认关闭
B机器
[dmdba@dmdsc02 ~]$ vi /dm8/dsc/config/dsc1_config/dmwatcher.ini
[GDSCDW1]
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 60
INST_ERROR_TIME = 35
INST_RECOVER_TIME = 60
INST_OGUID = 45332
INST_INI = /dm8/dsc/config/dsc1_config/dm.ini
DCR_INI = /dm8/dsc/config/dmdcr.ini
INST_STARTUP_CMD = /dm8/dsc/bin/dmserver
INST_AUTO_RESTART = 0
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
C机器
[dmdba@dmdw01 ~]$ vi /dm8/data/DAMENG/dmwatcher.ini
[GDSCDW1]
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 60
INST_ERROR_TIME = 35
INST_RECOVER_TIME = 60
INST_OGUID = 45332
INST_INI = /dm8/data/DAMENG/dm.ini
INST_STARTUP_CMD = /dm8/bin/dmserver
INST_AUTO_RESTART = 1 #开启自动启动
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
--注意：DMDSC集群各节点实例的自动拉起是由各自本地的dmcss执行的，不是由守护进程执行。所以INST_AUTO_RESTART=0，而单节点需要设置为1进行启动。
6.8、修改dmdcr.ini文件（选做）
修改DB启动成mount模式，如果服务配置了启动到open模式，可以自行修改成mount。后面部署完成后也需要修改回去
A机器
[dmdba@dmdsc01 config]$ vi dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH = /dm8/dsc/config/dmasvrmal.ini
DMDCR_SEQNO = 0
DMDCR_AUTO_OPEN_CHECK = 90
DMDCR_ASM_RESTART_INTERVAL = 30 #CSS认定ASM故障重启的时间
DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr dcr_ini=/dm8/dsc/config/dmdcr.ini
DMDCR_DB_RESTART_INTERVAL = 60 #CSS认定DSC故障重启的时间
DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver path=/dm8/dsc/config/dsc0_config/dm.ini dcr_ini=/dm8/dsc/config/dmdcr.ini mount
B机器
[dmdba@dmdsc02 config]$ vi dmdcr.ini
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH = /dm8/dsc/config/dmasvrmal.ini
DMDCR_SEQNO = 1
DMDCR_AUTO_OPEN_CHECK = 90
DMDCR_ASM_RESTART_INTERVAL = 30 #CSS认定ASM故障重启的时间
DMDCR_ASM_STARTUP_CMD = /dm8/bin/dmasmsvr dcr_ini=/dm8/dsc/config/dmdcr.ini
DMDCR_DB_RESTART_INTERVAL = 60 #CSS认定DSC故障重启的时间
DMDCR_DB_STARTUP_CMD = /dm8/bin/dmserver path=/dm8/dsc/config/dsc1_config/dm.ini dcr_ini=/dm8/dsc/config/dmdcr.ini mount
6.9、注册服务
A机器
[root@dmdsc01 root]# ./dm_service_installer.sh -t dmwatcher -watcher_ini /dm8/dsc/config/dsc0_config/dmwatcher.ini -p Watcher
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceWatcher.service to /usr/lib/systemd/system/DmWatcherServiceWatcher.service.
创建服务(DmWatcherServiceWatcher)完成
B机器
[root@dmdsc02 root]# ./dm_service_installer.sh -t dmwatcher -watcher_ini /dm8/dsc/config/dsc1_config/dmwatcher.ini -p Watcher
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceWatcher.service to /usr/lib/systemd/system/DmWatcherServiceWatcher.service.
创建服务(DmWatcherServiceWatcher)完成
C机器
[root@dmdw01 root]# ./dm_service_installer.sh -t dmwatcher -watcher_ini /dm8/data/DAMENG/dmwatcher.ini -p Watcher
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceWatcher.service to /usr/lib/systemd/system/DmWatcherServiceWatcher.service.
创建服务(DmWatcherServiceWatcher)完成
[root@dmdw01 root]# ./dm_service_installer.sh -t dmserver -p DW1_01 -dm_ini /dm8/data/DAMENG/dm.ini -m mount
备注：删除自启
A机器、B机器：[root@dmdsc01 root]#./dm_service_uninstaller.sh -n DmWatcherServiceWatcher
C机器：[root@dmdw01 root]# ./dm_service_uninstaller.sh -n DmServiceDW1_01
C机器：[root@dmdw01 root]# ./dm_service_uninstaller.sh -n DmWatcherServiceWatcher
6.10、配置监视器
6.10.1配置DSC+DW监视器
A机器、B机器、C机器该配置相同
A机器、B机器、C机器：：[dmdba@dmdsc01 ~]$ vi /dm8/bin/dmmonitor.ini
MON_DW_CONFIRM = 0 #0为非确认，1为确认
MON_LOG_PATH = ../log #监视器日志文件存放路径
MON_LOG_INTERVAL = 60 #每隔 60s 定时记录系统信息到日志文件
MON_LOG_FILE_SIZE = 512 #单个日志大小
MON_LOG_SPACE_LIMIT = 2048 #日志上限
[GDSCDW1]
MON_INST_OGUID = 45332 #组GDSCDW1的唯一OGUID 值
MON_DW_IP = 192.168.10.100:5836/192.168.10.101:5837 #IP对应MAL_HOST，PORT对应MAL_DW_PORT
MON_DW_IP = 192.168.10.102:5838
6.10.2注册DSC+DW监视器服务
A机器、B机器、C机器该配置相同
[root@dmdsc01 root]# ./dm_service_installer.sh -t dmmonitor -monitor_ini /dm8/bin/dmmonitor.ini -p Monitor
Created symlink from /etc/systemd/system/multi-user.target.wants/DmMonitorServiceMonitor.service to /usr/lib/systemd/system/DmMonitorServiceMonitor.service.
创建服务(DmMonitorServiceMonitor)完成
[root@dmdsc02 root]# ./dm_service_installer.sh -t dmmonitor -monitor_ini /dm8/bin/dmmonitor.ini -p Monitor
Created symlink from /etc/systemd/system/multi-user.target.wants/DmMonitorServiceMonitor.service to /usr/lib/systemd/system/DmMonitorServiceMonitor.service.
创建服务(DmMonitorServiceMonitor)完成
[root@dmdw01 root]# ./dm_service_installer.sh -t dmmonitor -monitor_ini /dm8/bin/dmmonitor.ini -p Monitor
Created symlink from /etc/systemd/system/multi-user.target.wants/DmMonitorServiceMonitor.service to /usr/lib/systemd/system/DmMonitorServiceMonitor.service.
创建服务(DmMonitorServiceMonitor)完成
备注：删除自启
A机器、B机器、C机器：[root@dmdw01 root]# ./dm_service_uninstaller.sh -n DmMonitorServiceMonitor
6.10.3配置DSC监视器（A\B上面已经注册了）
A机器、B机器、C机器该配置相同
C机器：[dmdba@dmdw01 bin]$ vi /dm8/bin/dmcssm.ini
CSSM_OGUID = 45331
CSSM_CSS_IP = 192.168.10.100:5336
CSSM_CSS_IP = 192.168.10.101:5337
CSSM_LOG_PATH = ../log
CSSM_LOG_FILE_SIZE = 512
CSSM_LOG_SPACE_LIMIT = 2048
6.10.4注册DSC监视器服务
C机器
[root@dmdw01 root]# ./dm_service_installer.sh -t dmcssm -cssm_ini /dm8/bin/dmcssm.ini -p Monitor
Created symlink from /etc/systemd/system/multi-user.target.wants/DmCSSMonitorServiceMonitor.service to /usr/lib/systemd/system/DmCSSMonitorServiceMonitor.service.
创建服务(DmCSSMonitorServiceMonitor)完成
备注：删除自启
A机器、B机器、C机器：[root@dmdw01 root]#./dm_service_uninstaller.sh -n DmCSSMonitorServiceMonitor
6.11、启动配置服务
6.11.1启动数据库并修改参数
--启动数据库
A机器
[dmdba@dmdsc01 ~]$ DmASMSvrServiceASM restart
[dmdba@dmdsc01 ~]$ DmCSSServiceCSS restart
B机器
[dmdba@dmdsc02 ~]$ DmASMSvrServiceASM restart
[dmdba@dmdsc02 ~]$ DmCSSServiceCSS restart
C机器
[dmdba@dmdw01 ~]$ DmServiceDW1_01 start
--修改主备库参数（连接DMDSC集群中的任意一个节点，设置DMDSC主库的OGUID 值）
A机器设置OGUID并修改为主库模式：
[dmdba@dmdsc01 ~]$ disql SYSDBA/SYSDBA
服务器[LOCALHOST:5236]:处于普通配置状态
登录使用时间 : 2.473(ms)
disql V8
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
DMSQL 过程已成功完成
已用时间: 11.551(毫秒). 执行号:0.
SQL> sp_set_oguid(45332);
DMSQL 过程已成功完成
已用时间: 16.767(毫秒). 执行号:1.
SQL> alter database primary;
操作已执行
已用时间: 9.642(毫秒). 执行号:0.
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
DMSQL 过程已成功完成
已用时间: 8.306(毫秒). 执行号:2.
SQL>
C机器设置OGUID并修改为主库模式：
[dmdba@dmdw01 ]$ disql SYSDBA/SYSDBA
服务器[LOCALHOST:5236]:处于普通配置状态
登录使用时间 : 2.473(ms)
disql V8
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
DMSQL 过程已成功完成
已用时间: 11.551(毫秒). 执行号:0.
SQL> sp_set_oguid(45332);
DMSQL 过程已成功完成
已用时间: 16.767(毫秒). 执行号:1.
SQL> alter database standby;
操作已执行
已用时间: 9.642(毫秒). 执行号:0.
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
DMSQL 过程已成功完成
已用时间: 8.306(毫秒). 执行号:2.
SQL>
6.11.2启动守护进程
A/B/C机器：[dmdba@dmdw01 DAMENG]$ DmWatcherServiceWatcher start
Starting DmWatcherServiceWatcher: [ OK ]
6.11.3启动DSC+DW监视器
A机器、B机器、C机器
前台启动：[dmdba@dmdw01 bin]$ dmmonitor dmmonitor.ini
6.11.4启动DSC监视器
A机器、B机器、C机器
[dmdba@dmdw01 ~]$ DmCSSMonitorServiceMonitor start
前台启动：[dmdba@dmdw01 bin]$ ./dmcssm INI_PATH=/dm8/bin/dmcssm.ini
6.11.5启停集群
启动：A/B机器CSS→A/B/C机器守护进程→A/B/C(DSC+DW)监视器
A/B机器：[dmdba@dmdsc01 ~]$ DmCSSServiceCSS start
A/B机器：[dmdba@dmdsc01 ~]$ DmWatcherServiceWatcher start
A/B机器：[dmdba@dmdsc01 ~]$ DmMonitorServiceMonitor start
A/B机器：[dmdba@dmdsc01 ~]$ DmCSSMonitorServiceMonitor start
C机器：[dmdba@dmdw01 bin]$ DmWatcherServiceWatcher start
C机器：[dmdba@dmdw01 bin]$ DmMonitorServiceMonitor start
C机器：[dmdba@dmdw01 bin]$ DmCSSMonitorServiceMonitor start
说明：CSS启动后30秒自动拉起ASM，60秒自动拉起DMSERVER。
停止： A/B/C机器（DSC+DW）监视器→A/B机器DMSERVER→A/B机器ASM→A/B机器CSS→A/B/C机器守护进程→C机器DMSERVER
A/B机器：[dmdba@dmdsc01 ~]$ DmCSSMonitorServiceMonitor stop
C机器：[dmdba@dmdw01 bin]$ DmCSSMonitorServiceMonitor stop
A/B机器：[dmdba@dmdsc01 ~]$ DmMonitorServiceMonitor stop
C机器：[dmdba@dmdw01 bin]$ DmMonitorServiceMonitor stop
A/B机器：[dmdba@dmdsc01 ~]$ DmServiceDSC stop
A/B机器：[dmdba@dmdsc01 ~]$ DmASMSvrServiceASM stop
A/B机器：[dmdba@dmdsc01 ~]$ DmCSSServiceCSS stop
A/B机器：[dmdba@dmdsc01 ~]$ DmWatcherServiceWatcher stop
C机器：[dmdba@dmdw01 bin]$ DmWatcherServiceWatcher stop
C机器：[dmdba@dmdw01 bin]$ DmServiceDW1_01 stop
说明：1)DSC正常停库必须2节点同时停止，根据目前脚本配置，CSS启动后30秒自动拉起ASM，60秒自动拉起DMSERVER，所以停止DMSERVER和ASM后，要尽快停止CSS，避免被自动拉起。2)ASM服务在任意节点停止，2个节点的ASM服务都会停止，为了保险起见，可以两边都执行停止命令。3)服务全部停止后，要检查后台进程是否全部停止。
6.12、查看DSC+DW监视器信息
[dmdba@dmdw01 bin]$ ./dmcssm INI_PATH=/dm8/bin/dmcssm.ini
[monitor] 2022-06-09 10:48:15: CSS MONITOR V8
[monitor] 2022-06-09 10:48:15: CSS MONITOR SYSTEM IS READY.
[monitor] 2022-06-09 10:48:15: Wait CSS Control Node choosed...
[monitor] 2022-06-09 10:48:16: Wait CSS Control Node choosed succeed.
输入命令非法！
show
monitor current time:2022-06-09 10:48:48, n_group:3
=================== group[name = GRP_CSS, seq = 0, type = CSS, Control Node = 0] ========================================
[CSS0] auto check = TRUE, global info:
[ASM0] auto restart = TRUE
[DSC0] auto restart = TRUE
[CSS1] auto check = TRUE, global info:
[ASM1] auto restart = TRUE
[DSC1] auto restart = TRUE
ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts
2022-06-09 10:48:47 CSS0 0 5336 Control Node OPEN WORKING OK TRUE 2305574 2369297
2022-06-09 10:48:47 CSS1 1 5337 Normal Node OPEN WORKING OK TRUE 34941378 35005080
=================== 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
2022-06-09 10:48:47 ASM0 0 5436 Control Node OPEN WORKING OK TRUE 2321132 2384805
2022-06-09 10:48:47 ASM1 1 5437 Normal Node OPEN WORKING OK TRUE 34954716 35018376
=================== 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
2022-06-09 10:48:47 DSC0 0 5236 Control Node OPEN WORKING OK TRUE 8919044 8961376
2022-06-09 10:48:47 DSC1 1 5236 Normal Node OPEN WORKING OK TRUE 41308123 41350399
==================================================================================================================p
--查看DW监视器信息
[dmdba@dmdw01 bin]$ dmmonitor dmmonitor.ini
[monitor] 2022-06-09 11:00:15: DMMONITOR[4.0] V8
[monitor] 2022-06-09 11:00:15: DMMONITOR[4.0] IS READY.
[monitor] 2022-06-09 11:00:15: 收到守护进程(DW1_01)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-06-09 11:00:15 OPEN OK DW1_01 OPEN STANDBY NULL 24 143259 143259
[monitor] 2022-06-09 11:00:15: 收到守护进程(DSC1)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-06-09 11:00:14 STARTUP OK DSC0 OPEN PRIMARY VALID 24 143259 143259
[monitor] 2022-06-09 11:00:16: 收到守护进程(DSC0)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-06-09 11:00:16 OPEN OK DSC0 OPEN PRIMARY VALID 24 143259 143260
show
2022-06-09 11:00:20
#================================================================================#
GROUP OGUID MON_CONFIRM MODE MPP_FLAG
GDSCDW1 45332 FALSE MANUAL FALSE
<<DATABASE GLOBAL INFO:>>
DW_IP MAL_DW_PORT WTIME WTYPE WCTLSTAT WSTATUS INAME INST_OK N_EP N_OK ISTATUS IMODE DSC_STATUS RTYPE RSTAT
192.168.10.100 5836 2022-06-09 11:00:20 GLOBAL VALID OPEN DSC0 OK 2 2 OPEN PRIMARY DSC_OPEN REALTIME VALID
EP INFO:
INST_IP INST_PORT INST_OK INAME ISTATUS IMODE DSC_SEQNO DSC_CTL_NODE RTYPE RSTAT FSEQ FLSN CSEQ CLSN DW_STAT_FLAG
192.168.2.100 5236 OK DSC0 OPEN PRIMARY 0 0 REALTIME VALID 54499 143261 54499 143261 NONE
192.168.2.101 5236 OK DSC1 OPEN PRIMARY 1 0 REALTIME VALID 53877 143261 53877 143261 NONE
<<DATABASE GLOBAL INFO:>>
DW_IP MAL_DW_PORT WTIME WTYPE WCTLSTAT WSTATUS INAME INST_OK N_EP N_OK ISTATUS IMODE DSC_STATUS RTYPE RSTAT
192.168.10.102 5838 2022-06-09 11:00:20 GLOBAL VALID OPEN DW1_01 OK 1 1 OPEN STANDBY DSC_OPEN REALTIME VALID
EP INFO:
INST_IP INST_PORT INST_OK INAME ISTATUS IMODE DSC_SEQNO DSC_CTL_NODE RTYPE RSTAT FSEQ FLSN CSEQ CLSN DW_STAT_FLAG
192.168.2.102 5236 OK DW1_01 OPEN STANDBY 0 0 REALTIME VALID 40112 143261 40112 143261 NONE
DATABASE(DW1_01) APPLY INFO FROM (DSC0), REDOS_PARALLEL_NUM (1):
DSC_SEQNO[0], (RSEQ, SSEQ, KSEQ)[54499, 54499, 54499], (RLSN, SLSN, KLSN)[143261, 143261, 143261], N_TSK[0], TSK_MEM_USE[0]
REDO_LSN_ARR: (143261)
DSC_SEQNO[1], (RSEQ, SSEQ, KSEQ)[53876, 53876, 53877], (RLSN, SLSN, KLSN)[143260, 143260, 143261], N_TSK[0], TSK_MEM_USE[512]
REDO_LSN_ARR: (143260)
#================================================================================#
6.13、测试验证
--主库创建测试表
[dmdba@dmdsc01 config]$ disql SYSDBA/SYSDBA
服务器[LOCALHOST:5236]:处于主库打开状态
登录使用时间 : 6.499(ms)
disql V8
SQL>
SQL> create table test(id number);
操作已执行
已用时间: 48.447(毫秒). 执行号:300.
SQL>
SQL> insert into test values(1);
影响行数 1
已用时间: 4.799(毫秒). 执行号:301.
SQL>
SQL> insert into test values(2);
影响行数 1
已用时间: 0.655(毫秒). 执行号:302.
SQL> commit;
操作已执行
已用时间: 2.767(毫秒). 执行号:303.
SQL>
SQL> select * from test;
行号 ID
---------- --
1 1
2 2
已用时间: 1.447(毫秒). 执行号:304.
--备库查询
[dmdba@dmdw01 DAMENG]$ disql SYSDBA/SYSDBA
服务器[LOCALHOST:5236]:处于备库打开状态
登录使用时间 : 2.271(ms)
disql V8
SQL> select * from test;
行号 ID
---------- --
1 1
2 2
已用时间: 3.432(毫秒). 执行号:100.
七、配置应用连接
Linux环境：dm_svc.conf放在应用服务器/etc目录下。
Windows32环境：dm_svc.conf放在应用服务器System32目录下。
Windows64环境：dm_svc.conf放在应用服务器System32和SysWOW64目录下。
7.1创建dm_svc.conf
[root@~]# vi /etc/dm_svc.conf
TIME_ZONE=(+8:00)
LANGUAGE=(cn)
DSC1=(192.168.2.100:5236,192.168.2.101:5236,192.168.2.102:5236)
[DSC1]
LOGIN_ENCRYPT=(0)
SWITCH_TIME=(20)
SWITCH_INTERVAL=(1000)
7.2应用连接
<DRIVER>dm.jdbc.driver.DmDriver</DRIVER>
<URL>jdbc:dm://DSC1:5236?compatibleMode=oracle</URL>
7.3测试连接
C:\Users\Administrator>disql SYSDBA/SYSDBA@DSC1
服务器[192.168.2.101:5236]:处于普通打开状态
登录使用时间 : 7.444(ms)
disql V8
SQL>
SQL> exit
C:\Users\Administrator>disql SYSDBA/SYSDBA@DSC1
服务器[192.168.2.100:5236]:处于普通打开状态
登录使用时间 : 15.782(ms)
disql V8
SQL>
八、故障恢复
在部署完成后，由于机器配置原因导致虚拟机节点1突然关闭了。
8.1 节点1异常关机
--查看节点2监视器
[dmdba@dmdsc02 bin]$ dmcssm ini_path=/dm8/bin/dmcssm.ini
[monitor] 2022-06-07 12:45:57: CSS MONITOR V8
[monitor] 2022-06-07 12:45:59: CSS MONITOR SYSTEM IS READY.
[monitor] 2022-06-07 12:45:59: Wait CSS Control Node choosed...
[CSS1] [2022-06-07 12:46:05:098] [CSS]: 监测到控制节点关闭
[monitor] 2022-06-07 12:46:05: Wait CSS Control Node choosed failed, if dmcss has startuped and ini configured correctly, please wait a little more before execute command.
[CSS1] [2022-06-07 12:46:05:098] [CSS]: 设置EP [255]为控制节点
[monitor] 2022-06-07 12:46:15: 检测到CSS控制节点发生变化，由CSS[255]变为CSS[1]
[CSS1] [2022-06-07 12:46:13:143] [CSS]: 设置EP CSS1[1]为控制节点
[CSS1] [2022-06-07 12:46:16:148] [ASM]: 设置命令[SYS HALT], 目标站点 ASM0[0], 命令序号[387]
[CSS1] [2022-06-07 12:46:21:239] [ASM]: 设置EP ASM0[0]为故障EP
[CSS1] [2022-06-07 12:46:27:363] [ASM]: 检测到EP ASM0[0]故障在PROCESS_OPEN中
[CSS1] [2022-06-07 12:46:33:470] [ASM]: 设置命令[SUSPEND EP WORKER THREAD], 目标站点 ASM1[1], 命令序号[390]
[CSS1] [2022-06-07 12:46:36:527] [DB]: 设置命令[EP_CRASH], 目标站点 DSC1[1], 命令序号[383]
[CSS1] [2022-06-07 12:46:42:207] [ASM]: 暂停工作线程结束
[CSS1] [2022-06-07 12:46:44:702] [ASM]: 设置EP ASM1[1]为控制节点
[CSS1] [2022-06-07 12:46:46:753] [ASM]: 设置命令[CRASH RECV], 目标站点 ASM1[1], 命令序号[392]
[CSS1] [2022-06-07 12:46:49:208] [ASM]: 设置命令[NONE], 目标站点 ASM1[1], 命令序号[0]
[CSS1] [2022-06-07 12:46:51:239] [ASM]: 设置命令[RESUME EP WORKER THREAD], 目标站点 ASM1[1], 命令序号[394]
[CSS1] [2022-06-07 12:46:54:195] [ASM]: 设置命令[NONE], 目标站点 ASM1[1], 命令序号[0]
[CSS1] [2022-06-07 12:46:56:458] [DB]: 设置命令[NONE], 目标站点 DSC1[1], 命令序号[0]
[CSS1] [2022-06-07 12:47:01:310] [DB]: 命令[EP_CRASH]处理结束
[CSS1] [2022-06-07 12:47:01:328] [DB]: 设置命令[CMD CLEAR], 目标站点 DSC1[1], 命令序号[386]
[CSS1] [2022-06-07 12:47:01:446] [CSS]: 设置命令[CONFIG VIP], 目标站点 CSS0[0], 命令序号[6]
[CSS1] [2022-06-07 12:47:01:852] [DB]: 设置命令[CONFIG VIP], 目标站点 DSC1[1], 命令序号[391]
[CSS1] [2022-06-07 12:47:02:561] [DB]: 设置命令[NONE], 目标站点 DSC1[1], 命令序号[0]
[CSS1] [2022-06-07 12:47:02:561] [DB]: 命令[CONFIG VIP]处理结束
--show查看信息
show
monitor current time:2022-06-07 12:48:03, n_group:3
=================== group[name = GRP_CSS, seq = 0, type = CSS, Control Node = 1] ========================================
[CSS0] auto check = FALSE, global info:
Connect to [CSS0] failed, please check the network or the CSSM_CSS_IP config in [/dm8/bin/dmcssm.ini] .
[CSS1] auto check = TRUE, global info:
[ASM1] auto restart = TRUE
[DSC1] auto restart = TRUE
ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts
2022-06-07 12:48:03 CSS0 0 5336 Normal Node OPEN WORKING OK FALSE 1967539 1971142
2022-06-07 12:48:03 CSS1 1 5337 Control Node OPEN WORKING OK TRUE 2184748 2187804
=================== group[name = GRP_ASM, seq = 1, type = ASM, Control Node = 1] ========================================
n_ok_ep = 1
ok_ep_arr(index, seqno):
(0, 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-06-07 12:48:03 ASM0 0 5436 Normal Node OPEN WORKING ERROR FALSE 1980551 1984111
2022-06-07 12:48:03 ASM1 1 5437 Control Node OPEN WORKING OK TRUE 2198072 2201084
=================== group[name = GRP_DSC, seq = 2, type = DB, Control Node = 1] ========================================
n_ok_ep = 1
ok_ep_arr(index, seqno):
(0, 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-06-07 12:48:03 DSC0 0 5236 Normal Node OPEN WORKING ERROR FALSE 1955988 1959519
2022-06-07 12:48:03 DSC1 1 5236 Control Node OPEN WORKING OK TRUE 2169924 2172905
==================================================================================================================
--验证此时数据库对外服务是否正常
C:\Users\Administrator>disql SYSDBA/SYSDBA@DSC1
服务器[192.168.2.101:5236]:处于普通打开状态
登录使用时间 : 5013.957(ms)
disql V8
SQL> exit
C:\Users\Administrator>disql SYSDBA/SYSDBA@DSC1
服务器[192.168.2.101:5236]:处于普通打开状态
登录使用时间 : 5005.128(ms)
disql V8
正常，都连接到了节点2上面
--尝试恢复虚拟机节点1，虚拟机起来以后监视器状态
[CSS0] [2022-06-07 12:53:30:828] [CSS]: 设置EP CSS1[1]为控制节点
[CSS1] [2022-06-07 12:53:45:690] [ASM]: 设置EP ASM0[0]为故障重加入EP
[CSS1] [2022-06-07 12:53:45:693] [ASM]: 设置命令[START NOTIFY], 目标站点 ASM0[0], 命令序号[398]
[CSS1] [2022-06-07 12:53:46:719] [ASM]: 设置命令[SUSPEND EP WORKER THREAD], 目标站点 ASM1[1], 命令序号[400]
[CSS1] [2022-06-07 12:53:48:539] [ASM]: 暂停工作线程结束
[CSS1] [2022-06-07 12:53:48:558] [ASM]: 设置命令[ERROR EP ADD], 目标站点 ASM0[0], 命令序号[401]
[CSS1] [2022-06-07 12:53:48:578] [ASM]: 设置命令[ERROR EP ADD], 目标站点 ASM1[1], 命令序号[402]
[CSS1] [2022-06-07 12:53:49:512] [ASM]: 故障EP重新加入DSC结束
[CSS1] [2022-06-07 12:53:49:512] [ASM]: 设置命令[EP RECV], 目标站点 ASM1[1], 命令序号[404]
[CSS1] [2022-06-07 12:53:50:546] [ASM]: 设置命令[EP START], 目标站点 ASM0[0], 命令序号[406]
[CSS1] [2022-06-07 12:53:53:388] [ASM]: 设置命令[EP OPEN], 目标站点 ASM0[0], 命令序号[408]
[CSS1] [2022-06-07 12:53:54:399] [ASM]: 设置命令[NONE], 目标站点 ASM0[0], 命令序号[0]
[CSS1] [2022-06-07 12:53:54:404] [ASM]: 设置命令[RESUME EP WORKER THREAD], 目标站点 ASM1[1], 命令序号[410]
[CSS1] [2022-06-07 12:53:54:530] [ASM]: 设置命令[NONE], 目标站点 ASM1[1], 命令序号[0]
[CSS1] [2022-06-07 12:53:54:531] [ASM]: 继续工作线程结束
[CSS1] [2022-06-07 12:53:54:552] [ASM]: 设置命令[EP REAL OPEN], 目标站点 ASM0[0], 命令序号[412]
[CSS1] [2022-06-07 12:53:55:383] [ASM]: 设置命令[NONE], 目标站点 ASM0[0], 命令序号[0]
[CSS1] [2022-06-07 12:53:56:386] [ASM]: 设置命令[LINK_CHECK], 目标站点 ASM0[0], 命令序号[416]
[CSS1] [2022-06-07 12:53:56:386] [ASM]: 设置命令[LINK_CHECK], 目标站点 ASM1[1], 命令序号[417]
[CSS1] [2022-06-07 12:53:56:510] [ASM]: 设置命令[NONE], 目标站点 ASM1[1], 命令序号[0]
[CSS1] [2022-06-07 12:53:57:422] [ASM]: 设置命令[NONE], 目标站点 ASM0[0], 命令序号[0]
[CSS1] [2022-06-07 12:54:24:012] [DB]: 设置EP DSC0[0]为故障重加入EP
[CSS1] [2022-06-07 12:54:24:015] [DB]: 设置命令[START NOTIFY], 目标站点 DSC0[0], 命令序号[396]
[CSS1] [2022-06-07 12:54:25:036] [DB]: 设置命令[SUSPEND EP WORKER THREAD], 目标站点 DSC1[1], 命令序号[397]
[CSS1] [2022-06-07 12:54:25:946] [DB]: 暂停工作线程结束
[CSS1] [2022-06-07 12:54:25:964] [DB]: 设置命令[DCR_LOAD], 目标站点 DSC0[0], 命令序号[398]
[CSS1] [2022-06-07 12:54:25:984] [DB]: 设置命令[DCR_LOAD], 目标站点 DSC1[1], 命令序号[399]
[CSS1] [2022-06-07 12:54:26:916] [DB]: 故障EP重新加入DSC结束
[CSS1] [2022-06-07 12:54:26:917] [DB]: 设置命令[ERROR EP ADD], 目标站点 DSC0[0], 命令序号[401]
[CSS1] [2022-06-07 12:54:26:939] [DB]: 设置命令[ERROR EP ADD], 目标站点 DSC1[1], 命令序号[402]
[CSS1] [2022-06-07 12:54:27:064] [DB]: 故障EP重新加入DSC结束
[CSS1] [2022-06-07 12:54:27:065] [DB]: 设置命令[EP RECV], 目标站点 DSC1[1], 命令序号[404]
[CSS1] [2022-06-07 12:54:27:189] [DB]: 故障EP恢复结束
[CSS1] [2022-06-07 12:54:27:192] [DB]: 设置命令[EP START], 目标站点 DSC0[0], 命令序号[406]
[CSS1] [2022-06-07 12:54:27:418] [DB]: 设置命令[EP START2], 目标站点 DSC0[0], 命令序号[408]
[CSS1] [2022-06-07 12:54:31:111] [DB]: 设置命令[ADJUST MASTER EP], 目标站点 DSC0[0], 命令序号[410]
[CSS1] [2022-06-07 12:54:31:112] [DB]: 设置命令[ADJUST MASTER EP], 目标站点 DSC1[1], 命令序号[411]
[CSS1] [2022-06-07 12:54:31:235] [DB]: 设置EP DSC0[0]为控制节点
[CSS1] [2022-06-07 12:54:31:236] [DB]: 设置命令[EP OPEN], 目标站点 DSC0[0], 命令序号[413]
[CSS1] [2022-06-07 12:54:31:375] [DB]: 设置命令[NONE], 目标站点 DSC0[0], 命令序号[0]
[CSS1] [2022-06-07 12:54:31:376] [DB]: 设置命令[RESUME EP WORKER THREAD], 目标站点 DSC1[1], 命令序号[415]
[CSS1] [2022-06-07 12:54:31:508] [DB]: 继续工作线程结束
[CSS1] [2022-06-07 12:54:31:509] [DB]: 设置命令[NONE], 目标站点 DSC1[1], 命令序号[0]
[CSS1] [2022-06-07 12:54:31:539] [DB]: 设置命令[EP REAL OPEN], 目标站点 DSC0[0], 命令序号[417]
[CSS1] [2022-06-07 12:54:32:482] [DB]: 设置命令[NONE], 目标站点 DSC0[0], 命令序号[0]
[CSS1] [2022-06-07 12:54:33:487] [DB]: 上次故障处理未真正完成，不允许故障ep重加入
[CSS1] [2022-06-07 12:54:35:489] [DB]: 上次故障处理已完成，允许故障ep重加入
输入命令非法！
show
monitor current time:2022-06-07 12:56:14, n_group:3
=================== group[name = GRP_CSS, seq = 0, type = CSS, Control Node = 1] ========================================
[CSS0] auto check = TRUE, global info:
[ASM0] auto restart = TRUE
[DSC0] auto restart = TRUE
[CSS1] auto check = TRUE, global info:
[ASM1] auto restart = TRUE
[DSC1] auto restart = TRUE
ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts
2022-06-07 12:56:14 CSS0 0 5336 Normal Node OPEN WORKING OK TRUE 6470 6639
2022-06-07 12:56:14 CSS1 1 5337 Control Node OPEN WORKING OK TRUE 2184748 2188295
=================== group[name = GRP_ASM, seq = 1, type = ASM, Control Node = 1] ========================================
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-06-07 12:56:14 ASM0 0 5436 Normal Node OPEN WORKING OK TRUE 11817 11967
2022-06-07 12:56:14 ASM1 1 5437 Control Node OPEN WORKING OK TRUE 2198072 2201575
=================== 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
2022-06-07 12:56:14 DSC0 0 5236 Control Node OPEN WORKING OK TRUE 22945 23056
2022-06-07 12:56:14 DSC1 1 5236 Normal Node OPEN WORKING OK TRUE 2169924 2173396
==================================================================================================================
8.2 故障自动切换
根据6.1的配置连接，通过客户端连接数据库
C:\Users\Administrator>disql SYSDBA/SYSDBA@DSC1
服务器[192.168.2.101:5236]:处于普通打开状态
登录使用时间 : 5.344(ms)
disql V8
SQL>
SQL> select instance_name from v$instance;
行号 INSTANCE_NAME
---------- -------------
1 DSC1
已用时间: 3.172(毫秒). 执行号:100.
--以上会话不要关闭，关闭101上的实例
[dmdba@dmdsc02 bin]$ disql SYSDBA/SYSDBA
服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 2.765(ms)
disql V8
SQL> stop instance;
服务器[LOCALHOST:5236]:处于普通打开状态
已连接
操作已执行
已用时间: 1.097(毫秒). 执行号:0.
--查看监视器状态
--继续使用上面的窗口进行查询
SQL> select instance_name from v$instance;
服务器[192.168.2.100:5236]:处于普通打开状态
已连接
行号 INSTANCE_NAME
---------- -------------
1 DSC0
已用时间: 2.718(毫秒). 执行号:0.
已完成故障切换，实例变为了DSC0
--查看监视器，发现CSS已经将stop的实例进行了重启
[CSS1] [2022-06-07 14:12:28:857] [CSS]: 重启本地DB实例，命令：[/dm8/bin/dmserver path=/dm8/dsc/config/dsc1_config/dm.ini dcr_ini=/dm8/dsc/config/dmdcr.ini]
[CSS1] [2022-06-07 14:12:38:888] [DB]: 设置EP DSC1[1]为故障重加入EP
[CSS1] [2022-06-07 14:12:38:890] [DB]: 设置命令[START NOTIFY], 目标站点 DSC1[1], 命令序号[523]
[CSS1] [2022-06-07 14:12:39:911] [DB]: 设置命令[SUSPEND EP WORKER THREAD], 目标站点 DSC0[0], 命令序号[524]
[CSS1] [2022-06-07 14:12:40:215] [DB]: 暂停工作线程结束
[CSS1] [2022-06-07 14:12:40:235] [DB]: 设置命令[DCR_LOAD], 目标站点 DSC0[0], 命令序号[525]
[CSS1] [2022-06-07 14:12:40:260] [DB]: 设置命令[DCR_LOAD], 目标站点 DSC1[1], 命令序号[526]
[CSS1] [2022-06-07 14:12:41:194] [DB]: 故障EP重新加入DSC结束
[CSS1] [2022-06-07 14:12:41:195] [DB]: 设置命令[ERROR EP ADD], 目标站点 DSC0[0], 命令序号[528]
[CSS1] [2022-06-07 14:12:41:220] [DB]: 设置命令[ERROR EP ADD], 目标站点 DSC1[1], 命令序号[529]
[CSS1] [2022-06-07 14:12:41:348] [DB]: 故障EP重新加入DSC结束
[CSS1] [2022-06-07 14:12:41:348] [DB]: 设置命令[EP RECV], 目标站点 DSC0[0], 命令序号[531]
[CSS1] [2022-06-07 14:12:41:475] [DB]: 故障EP恢复结束
[CSS1] [2022-06-07 14:12:41:478] [DB]: 设置命令[EP START], 目标站点 DSC1[1], 命令序号[533]
[CSS1] [2022-06-07 14:12:41:706] [DB]: 设置命令[EP START2], 目标站点 DSC1[1], 命令序号[535]
[CSS1] [2022-06-07 14:12:43:675] [DB]: 设置命令[EP OPEN], 目标站点 DSC1[1], 命令序号[537]
[CSS1] [2022-06-07 14:12:43:778] [DB]: 设置命令[NONE], 目标站点 DSC1[1], 命令序号[0]
[CSS1] [2022-06-07 14:12:43:778] [DB]: 设置命令[RESUME EP WORKER THREAD], 目标站点 DSC0[0], 命令序号[539]
[CSS1] [2022-06-07 14:12:43:907] [DB]: 继续工作线程结束
[CSS1] [2022-06-07 14:12:43:907] [DB]: 设置命令[NONE], 目标站点 DSC0[0], 命令序号[0]
[CSS1] [2022-06-07 14:12:44:932] [DB]: 设置命令[EP REAL OPEN], 目标站点 DSC1[1], 命令序号[541]
[CSS1] [2022-06-07 14:12:45:971] [DB]: 设置命令[NONE], 目标站点 DSC1[1], 命令序号[0]
show
monitor current time:2022-06-07 14:19:59, n_group:3
=================== group[name = GRP_CSS, seq = 0, type = CSS, Control Node = 1] ========================================
[CSS0] auto check = TRUE, global info:
[ASM0] auto restart = TRUE
[DSC0] auto restart = TRUE
[CSS1] auto check = TRUE, global info:
[ASM1] auto restart = TRUE
[DSC1] auto restart = TRUE
ep: css_time inst_name seqno port mode inst_status vtd_status is_ok active guid ts
2022-06-07 14:19:59 CSS0 0 5336 Normal Node OPEN WORKING OK TRUE 6470 11659
2022-06-07 14:19:59 CSS1 1 5337 Control Node OPEN WORKING OK TRUE 2184748 2193315
=================== group[name = GRP_ASM, seq = 1, type = ASM, Control Node = 1] ========================================
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-06-07 14:19:59 ASM0 0 5436 Normal Node OPEN WORKING OK TRUE 11817 16987
2022-06-07 14:19:59 ASM1 1 5437 Control Node OPEN WORKING OK TRUE 2198072 2206596
=================== 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
2022-06-07 14:19:59 DSC0 0 5236 Control Node OPEN WORKING OK TRUE 421057 424896
2022-06-07 14:19:59 DSC1 1 5236 Normal Node OPEN WORKING OK TRUE 4644622 4645064
==================================================================================================================
社区地址：https://eco.dameng.com
扫一扫
296
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
