DM8集群部署RWC集群Linux两节点手切

最近在学习DM数据库集群，今天将RWC集群部署过程记录一下。

环境准备：两台虚拟机，DM8安装包（可以在官网下载）

禁用防火墙（两台机器都禁用）

[test@localhost ~]$ systemctl stop firewalld
[test@localhost ~]$ systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

配置两台虚拟机A和B的网卡，使其能相互ping通

在A、B上分别安装数据库

创建安装用户及用户组

[root@localhost ~]# groupadd dinstall
[root@localhost ~]#  useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
[root@localhost ~]#  passwd dmdba
更改用户 dmdba 的密码 。
新的 密码：
无效的密码： 密码少于 8 个字符
重新输入新的 密码：
passwd：所有的身份验证令牌已经成功更新。

修改文件最大数

[root@localhost ~]# vi /etc/security/limits.conf（最后加入下面四句话）
dmdba hard nofile 65536
dmdba soft nofile 65536
dmdba hard stack 32768
dmdba soft stack 16384

切换到dmdba用户，查看是否生效

[root@localhost ~]# su - dmdba
[dmdba@localhost ~]$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 3755
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) unlimited
open files                      (-n) 65536
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 16384
cpu time               (seconds, -t) unlimited
max user processes              (-u) 3755
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

可使用 dmdba 用户执行如下命令，使设置临时生效

[dmdba@localhost ~]$ ulimit -n 65536

挂载DM数据库的ios安装包

[root@localhost ~]# mount -o loop /dev/cdrom /mnt/

新建安装目录，修改权限

[root@localhost ~]# mkdir /opt/dmdbms
[root@localhost ~]# chown dmdba:dinstall -R /opt/dmdbms/
[root@localhost ~]# chmod -R 755 /opt/dmdbms/

Dmdba用户使用命令行安装DM8

[root@localhost ~]# su - dmdba
上一次登录：四 8月 12 16:39:33 CST 2021pts/0 上
[dmdba@localhost ~]$ cd /mnt/
[dmdba@localhost mnt]$ ls
DM8 Install.pdf  DMInstall.bin
[dmdba@localhost mnt]$ ./DMInstall.bin -i
请选择安装语言(C/c:中文 E/e:英文) [C/c]:c

安装前小结
安装位置: /opt/dmdbms
所需空间: 1075M
可用空间: 31G
版本信息: 
有效日期: 
安装类型: 典型安装

使用root用户执行命令

root@localhost ~]# /opt/dmdbms/script/root/root_installer.sh 
移动 /opt/dmdbms/bin/dm_svc.conf 到/etc目录
修改服务器权限
创建DmAPService服务
Created symlink from /etc/systemd/system/multi-user.target.wants/DmAPService.service to /usr/lib/systemd/system/DmAPService.service.
创建服务(DmAPService)完成
启动DmAPService服务

配置环境变量

export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool
[root@localhost ~]# cd /home/dmdba/
[root@localhost dmdba]#  vim .bash_profile

 切换到dmdba用户，使用以下命令使其生效

[root@localhost dmdba]# su - dmdba
上一次登录：四 8月 12 16:42:02 CST 2021pts/0 上
[dmdba@localhost ~]$ source .bash_profile

配置A机器

初始化实例、备份数据

[dmdba@localhost ~]$ /opt/dmdbms/bin/dminit PATH=/opt/dmdbms/data/ INSTANCE_NAME=RWC1_01 PAGE_SIZE=32 LOG_SIZE=2048
initdb V8
db version: 0x7000b
file dm.key not found, use default license!
License will expire on 2021-09-04

 log file path: /opt/dmdbms/data/DAMENG/DAMENG01.log


 log file path: /opt/dmdbms/data/DAMENG/DAMENG02.log

write to dir [/opt/dmdbms/data/DAMENG].
create dm database success. 2021-08-12 17:00:30

启动服务

dmdba@localhost ~]$ /opt/dmdbms/bin/dmserver /opt/dmdbms/data/DAMENG/dm.ini
file dm.key not found, use default license!
version info: develop
Use normal os_malloc instead of HugeTLB
Use normal os_malloc instead of HugeTLB
DM Database Server x64 V8 1-1-126-20.09.04-126608-ENT  startup...
Database mode = 0, oguid = 0
License will expire on 2021-09-04
file lsn: 0
ndct db load finished
ndct fill fast pool finished
iid page's trxid[1002]
NEXT TRX ID = 1003
pseg_collect_mgr_items, total collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 mgr pages, 0 mgr recs!
total 0 active crash trx, pseg_crash_trx_rollback sys_only(0) begin ...
pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.
pseg_crash_trx_rollback end
pseg recv finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
trx: 2004 purged 1 pages
trx: 2023 purged 1 pages
trx: 2024 purged 1 pages
trx: 2025 purged 1 pages
trx: 2026 purged 1 pages
trx: 2036 purged 1 pages
trx: 2156 purged 1 pages
trx: 2169 purged 1 pages
trx: 2170 purged 1 pages
trx: 2171 purged 1 pages
trx: 2172 purged 1 pages
trx: 2173 purged 1 pages
trx: 2175 purged 1 pages
trx: 2176 purged 1 pages
trx: 2178 purged 1 pages
trx: 2180 purged 1 pages
trx: 2186 purged 1 pages
trx: 2192 purged 1 pages
trx: 2202 purged 1 pages
trx: 2210 purged 10 pages
trx: 2217 purged 1 pages
trx: 2218 purged 1 pages
trx: 2219 purged 1 pages
trx: 2220 purged 1 pages
trx: 2232 purged 1 pages
trx: 2234 purged 1 pages
trx: 2235 purged 1 pages
trx: 2236 purged 1 pages
trx: 2241 purged 6 pages
trx: 2268 purged 1 pages
trx: 2269 purged 1 pages
trx: 2270 purged 1 pages
trx: 2271 purged 1 pages
trx: 2277 purged 1 pages
trx: 2279 purged 1 pages
trx: 2281 purged 1 pages
trx: 2286 purged 1 pages
trx: 2291 purged 1 pages
trx: 2296 purged 1 pages
trx: 2298 purged 1 pages
trx: 2301 purged 1 pages
trx: 2303 purged 1 pages
trx: 2315 purged 1 pages
trx: 2317 purged 1 pages
trx: 2319 purged 1 pages
trx: 2324 purged 1 pages
trx: 2327 purged 1 pages
trx: 2330 purged 1 pages
trx: 2333 purged 1 pages
trx: 2335 purged 1 pages
trx: 2336 purged 1 pages
trx: 2485 purged 1 pages
trx: 2490 purged 1 pages
trx: 2497 purged 2 pages
trx: 2526 purged 1 pages
systables desc init success.
ndct_db_load_info success.
nsvr_process_before_open begin.
nsvr_process_before_open success.
total 0 active crash trx, pseg_crash_trx_rollback sys_only(0) begin ...
pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.
pseg_crash_trx_rollback end
SYSTEM IS READY.

开启归档、备份数据、修改dm.ini

[dmdba@localhost ~]$ /opt/dmdbms/bin/disql SYSDBA/SYSDBA@192.168.28.61:5236

服务器[192.168.28.61:5236]:处于普通打开状态
登录使用时间 : 27.211(ms)
disql V8
SQL> ALTER DATABASE MOUNT;
操作已执行
已用时间: 00:00:01.773. 执行号:0.
SQL> ALTER DATABASE ARCHIVELOG;
操作已执行
已用时间: 7.886(毫秒). 执行号:0.
SQL> ALTER DATABASE ADD ARCHIVELOG 'DEST=/opt/dmdbms/data/DAMENG/arch, TYPE=LOCAL, FILE_SIZE=1024, SPACE_LIMIT=51200';
操作已执行
已用时间: 7.545(毫秒). 执行号:0.
SQL> ALTER DATABASE OPEN;
操作已执行
已用时间: 00:00:01.785. 执行号:0.
SQL> BACKUP DATABASE BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE';
操作已执行
已用时间: 00:00:01.678. 执行号:104.
SQL> SP_SET_PARA_VALUE (2,'PORT_NUM',5236);
DMSQL 过程已成功完成
已用时间: 18.787(毫秒). 执行号:105.
SQL> SP_SET_PARA_VALUE (2,'DW_INACTIVE_INTERVAL',60);
DMSQL 过程已成功完成
已用时间: 3.253(毫秒). 执行号:106.
SQL> SP_SET_PARA_VALUE (2,'ALTER_MODE_STATUS',0);
DMSQL 过程已成功完成
已用时间: 3.011(毫秒). 执行号:107.
SQL> SP_SET_PARA_VALUE (2,'ENABLE_OFFLINE_TS',2);
DMSQL 过程已成功完成
已用时间: 3.074(毫秒). 执行号:108.
SQL> SP_SET_PARA_VALUE (2,'MAL_INI',1);
DMSQL 过程已成功完成
已用时间: 2.975(毫秒). 执行号:109.
SQL> SP_SET_PARA_VALUE (2,'RLOG_SEND_APPLY_MON',64);
DMSQL 过程已成功完成
已用时间: 2.941(毫秒). 执行号:110.

关闭前台服务

替换dmarch.ini

[dmdba@localhost ~]$ vi /opt/dmdbms/data/DAMENG/dmarch.ini
[dmdba@localhost ~]$ cat /opt/dmdbms/data/DAMENG/dmarch.ini 
#DaMeng Database Archive Configuration file
#this is comments
[ARCHIVE_LOCAL]
  ARCH_TYPE                = LOCAL  #本地归档类型
  ARCH_DEST                = /opt/dmdbms/data/DAMENG/arch/  #本地归档存放路径
  ARCH_FILE_SIZE           = 1024  #单个归档大小，单位MB
  ARCH_SPACE_LIMIT         = 51200  #归档上限，单位MB
[ARCHIVE_TIMELY1]
  ARCH_TYPE                = TIMELY  #即时归档类型
  ARCH_DEST                = RWC1_01B  #即时归档目标实例名

创建dmmal.ini

[dmdba@localhost ~]$ vi /opt/dmdbms/data/DAMENG/dmmal.ini
[dmdba@localhost ~]$ cat /opt/dmdbms/data/DAMENG/dmmal.ini 
MAL_CHECK_INTERVAL         = 10  #MAL链路检测时间间隔
MAL_CONN_FAIL_INTERVAL     = 10  #判定MAL链路断开的时间
MAL_TEMP_PATH              = /opt/dmdbms/data/malpath/  #临时文件目录
MAL_BUF_SIZE               = 512  #单个MAL缓存大小，单位MB
MAL_SYS_BUF_SIZE           = 2048  #MAL总大小限制，单位MB
MAL_COMPRESS_LEVEL         = 0  #MAL消息压缩等级，0表示不压缩

[MAL_INST1]
  MAL_INST_NAME            = RWC1_01  #实例名，和 dm.ini的INSTANCE_NAME一致
  MAL_HOST                 = 192.168.28.61  #MAL系统监听TCP连接的IP地址
  MAL_PORT                 = 5336  #MAL系统监听TCP连接的端口
  MAL_INST_HOST            = 192.168.28.61  #实例的对外服务IP地址
  MAL_INST_PORT            = 5236  #实例对外服务端口，和dm.ini的PORT_NUM一致
  MAL_DW_PORT              = 5436  #实例对应的守护进程监听TCP连接的端口
  MAL_INST_DW_PORT         = 5536  #实例监听守护进程TCP连接的端口
[MAL_INST2]
  MAL_INST_NAME            = RWC1_01B
  MAL_HOST                 = 192.168.28.62
  MAL_PORT                 = 5336
  MAL_INST_HOST            = 192.168.28.62
  MAL_INST_PORT            = 5236
  MAL_DW_PORT              = 5436
  MAL_INST_DW_PORT         = 5536

创建dmwatcher.ini

[dmdba@localhost ~]$ vi /opt/dmdbms/data/DAMENG/dmwatcher.ini
[dmdba@localhost ~]$ cat /opt/dmdbms/data/DAMENG/dmwatcher.ini 
[GRWC1]
  DW_TYPE                  = GLOBAL  #全局守护类型
  DW_MODE                  = MANUAL  #故障手动切换模式
  DW_ERROR_TIME            = 20  #远程守护进程故障认定时间
  INST_ERROR_TIME          = 20  #本地实例故障认定时间
  INST_RECOVER_TIME        = 60  #主库守护进程启动恢复的间隔时间
  INST_OGUID               = 45331  #守护系统唯一OGUID值
  INST_INI                 = /opt/dmdbms/data/DAMENG/dm.ini  #dm.ini文件路径
  INST_AUTO_RESTART        = 1  #打开实例的自动启动功能
  INST_STARTUP_CMD         = /opt/dmdbms/bin/dmserver  #命令行方式启动
  RLOG_SEND_THRESHOLD      = 0  #指定主库发送日志到备库的时间阈值，默认关闭
  RLOG_APPLY_THRESHOLD     = 0  #指定备库重演日志的时间阈值，默认关闭

 拷贝实例到B机器

[dmdba@localhost ~]$ scp -r /opt/dmdbms/data/DAMENG dmdba@192.168.28.62:/opt/dmdbms/data/
The authenticity of host '192.168.28.62 (192.168.28.62)' can't be established.
ECDSA key fingerprint is SHA256:JuvfudnNwSPm6+C+s+aqzMVZjkS6HW/fV3HtQobMSAM.
ECDSA key fingerprint is MD5:5d:45:c4:27:3e:ce:4d:e1:d4:ce:73:58:d3:db:95:b1.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.28.62' (ECDSA) to the list of known hosts.
dmdba@192.168.28.62's password: 
BACKUP_FILE.bak                               100%   16MB  68.4MB/s   00:00    
BACKUP_FILE_1.bak                             100%  182KB  21.2MB/s   00:00    
BACKUP_FILE.meta                              100%   81KB  32.4MB/s   00:00    
dminit20210812170027.log                      100%  890   988.2KB/s   00:00    
dm.ini                                        100%   49KB  26.1MB/s   00:00    
sqllog.ini                                    100%  479   480.8KB/s   00:00    
dm.ctl                                        100% 5120     5.8MB/s   00:00    
DAMENG01.log                                  100% 2048MB 104.7MB/s   00:19    
DAMENG02.log                                  100% 2048MB 105.8MB/s   00:19    
dm_20210812170030_215479.ctl                  100% 5120     1.1MB/s   00:00    
dm_20210812170141_282206.ctl                  100% 5120     1.9MB/s   00:00    
dm_20210812171049_151741.ctl                  100% 5120     1.6MB/s   00:00    
SYSTEM.DBF                                    100%   80MB  94.4MB/s   00:00    
dm_service.prikey                             100%  633   156.8KB/s   00:00    
MAIN.DBF                                      100%  128MB 101.7MB/s   00:01    
ROLL.DBF                                      100%  128MB  96.0MB/s   00:01    
TEMP.DBF                                      100%   42MB 104.4MB/s   00:00    
rep_conflict.log                              100%   12     3.7KB/s   00:00    
ARCHIVE_LOCAL1_0x3F69079C[0]_2021-08-12_17-03 100%  260KB  15.3MB/s   00:00    
ARCHIVE_LOCAL1_0x3F69079C[0]_2021-08-12_17-10 100%  183KB  45.2MB/s   00:00    
dmarch.ini                                    100%  491   730.0KB/s   00:00    
dmmal.ini                                     100% 1264     1.8MB/s   00:00    
dmwatcher.ini                                 100%  820     1.2MB/s   00:00

注册服务

[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmserver -p RWC1_01 -dm_ini /opt/dmdbms/data/DAMENG/dm.ini -m mount
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceRWC1_01.service to /usr/lib/systemd/system/DmServiceRWC1_01.service.
创建服务(DmServiceRWC1_01)完成
[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini /opt/dmdbms/data/DAMENG/dmwatcher.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceWatcher.service to /usr/lib/systemd/system/DmWatcherServiceWatcher.service.
创建服务(DmWatcherServiceWatcher)完成

配置B机器

修改dm.ini

[dmdba@localhost data]$ vi /opt/dmdbms/data/DAMENG/dm.ini

 替换dmarch.ini

[dmdba@localhost data]$ vi /opt/dmdbms/data/DAMENG/dmarch.ini
[dmdba@localhost data]$ cat /opt/dmdbms/data/DAMENG/dmarch.ini 
#DaMeng Database Archive Configuration file
#this is comments
[ARCHIVE_LOCAL]
  ARCH_TYPE                = LOCAL  #本地归档类型
  ARCH_DEST                = /opt/dmdbms/data/DAMENG/arch/  #本地归档存放路径
  ARCH_FILE_SIZE           = 1024  #单个归档大小，单位MB
  ARCH_SPACE_LIMIT         = 51200  #归档上限，单位MB
[ARCHIVE_TIMELY1]
  ARCH_TYPE                = TIMELY  #即时归档类型
  ARCH_DEST                = RWC1_01  #即时归档目标实例名

与A机器RWC1_01的dmmal.ini、dawatcher.ini相同

注册服务

[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmserver -p RWC1_01B -dm_ini /opt/dmdbms/data/DAMENG/dm.ini -m mount
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceRWC1_01B.service to /usr/lib/systemd/system/DmServiceRWC1_01B.service.
创建服务(DmServiceRWC1_01B)完成
[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini /opt/dmdbms/data/DAMENG/dmwatcher.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServiceWatcher.service to /usr/lib/systemd/system/DmWatcherServiceWatcher.service.
创建服务(DmWatcherServiceWatcher)完成

恢复数据

[dmdba@localhost ~]$ /opt/dmdbms/bin/dmrman CTLSTMT="RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE'"
dmrman V8
RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE'
file dm.key not found, use default license!
RESTORE DATABASE CHECK......
RESTORE DATABASE,data collect......
RESTORE DATABASE,database refresh ......
RESTORE BACKUPSET [/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE] START......
total 4 packages processed...
total 5 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...
total 5 packages processed!
CMD END.CODE:[0]
restore successfully.
time used: 495.034(ms)

[dmdba@localhost ~]$ /opt/dmdbms/bin/dmrman CTLSTMT="RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE'"
dmrman V8
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE'
file dm.key not found, use default license!
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[38459]
RESTORE RLOG CHECK......
RESTORE RLOG, gen tmp file......
RESTORE RLOG FROM BACKUPSET [/opt/dmdbms/data/DAMENG/bak/BACKUP_FILE] START......
total 3 packages processed...
total 3 packages processed...
total 3 packages processed!
CMD END.CODE:[0]
EP:0 total 1 pkgs applied, percent: 11%
EP:0 total 2 pkgs applied, percent: 22%
EP:0 total 3 pkgs applied, percent: 33%
EP:0 total 4 pkgs applied, percent: 44%
EP:0 total 5 pkgs applied, percent: 55%
EP:0 total 6 pkgs applied, percent: 66%
EP:0 total 7 pkgs applied, percent: 77%
EP:0 total 8 pkgs applied, percent: 88%
EP:0 total 9 pkgs applied, percent: 100%
Recover from archive log finished, time used:0.184s.
recover successfully!
time used: 452.290(ms)

[dmdba@localhost ~]$ /opt/dmdbms/bin/dmrman CTLSTMT="RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' UPDATE DB_MAGIC"
dmrman V8
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' UPDATE DB_MAGIC
file dm.key not found, use default license!
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[39731]
EP[0]'s apply_lsn[39731] >= end_lsn[39731]
recover successfully!
time used: 979.000(ms)

配置监视器

在各个节点数据库的bin目录中存放非确认监视器配置文件。

[dmdba@localhost bin]$ vi /opt/dmdbms/bin/dmmonitor.ini 
[dmdba@localhost bin]$ cat /opt/dmdbms/bin/dmmonitor.ini 
MON_DW_CONFIRM             = 0  #0为非确认，1为确认
MON_LOG_PATH               = /opt/dmdbms/log  #监视器日志文件存放路径
MON_LOG_INTERVAL           = 60  #每隔 60s 定时记录系统信息到日志文件
MON_LOG_FILE_SIZE          = 512  #单个日志大小，单位MB
MON_LOG_SPACE_LIMIT        = 2048  #日志上限，单位MB

[GRWC1]
  MON_INST_OGUID           = 45331  #组GRWC1的唯一OGUID 值
  MON_DW_IP                = 192.168.28.61:5436  #IP对应MAL_HOST，PORT对应MAL_DW_PORT
  MON_DW_IP                = 192.168.28.62:5436 

注册服务

[root@localhost ~]# /opt/dmdbms/script/root/dm_service_installer.sh -t dmmonitor -p Monitor -monitor_ini /opt/dmdbms/bin/dmmonitor.ini
Created symlink from /etc/systemd/system/multi-user.target.wants/DmMonitorServiceMonitor.service to /usr/lib/systemd/system/DmMonitorServiceMonitor.service.
创建服务(DmMonitorServiceMonitor)完成

启动数据并修改参数

A机器

[dmdba@localhost ~]$ /opt/dmdbms/bin/DmServiceRWC1_01 start
Starting DmServiceRWC1_01:                                 [ OK ]
[dmdba@localhost ~]$ /opt/dmdbms/bin/disql SYSDBA/SYSDBA@192.168.28.61:5236

服务器[192.168.28.61:5236]:处于普通配置状态
登录使用时间 : 28.294(ms)
disql V8
SQL> SP_SET_OGUID(45331);
DMSQL 过程已成功完成
已用时间: 78.018(毫秒). 执行号:0.
SQL> ALTER DATABASE PRIMARY;
操作已执行
已用时间: 5.016(毫秒). 执行号:0.

B机器

[dmdba@localhost ~]$ /opt/dmdbms/bin/disql SYSDBA/SYSDBA@192.168.28.62:5236

服务器[192.168.28.62:5236]:处于普通配置状态
登录使用时间 : 52.254(ms)
disql V8
SQL> SP_SET_OGUID(45331);
DMSQL 过程已成功完成
已用时间: 77.343(毫秒). 执行号:0.
SQL> ALTER DATABASE STANDBY;
操作已执行
已用时间: 70.005(毫秒). 执行号:0.

A/B机器启动守护进程

[dmdba@localhost ~]$ /opt/dmdbms/bin/DmWatcherServiceWatcher start
Starting DmWatcherServiceWatcher:                          [ OK ]

启动监视器

mdba@localhost bin]$ ./dmmonitor /opt/dmdbms/bin/dmmonitor.ini 
[monitor]         2021-08-12 18:14:12: DMMONITOR[4.0] V8
[monitor]         2021-08-12 18:14:12: DMMONITOR[4.0] IS READY.

[monitor]         2021-08-12 18:14:12: 收到守护进程(RWC1_01)消息
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2021-08-12 18:14:12  OPEN           OK        RWC1_01          OPEN        PRIMARY   VALID    6        44204           44204           

[monitor]         2021-08-12 18:14:12: 收到守护进程(RWC1_01B)消息
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            
                  2021-08-12 18:14:12  OPEN           OK        RWC1_01B         OPEN        STANDBY   VALID    6        44204           44204           

tip
[monitor]         2021-08-12 18:14:15: [!!! 提示：本监视器不是确认监视器，在故障自动切换模式下如果发生主库故障，本监视器无法执行自动接管 !!!]

[monitor]         2021-08-12 18:14:15: 实例RWC1_01[PRIMARY, OPEN, ISTAT_SAME:TRUE]不可加入其他实例，守护进程状态：OPEN，Open记录状态：VALID
[monitor]         2021-08-12 18:14:15: 实例RWC1_01[PRIMARY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor]         2021-08-12 18:14:15: 实例RWC1_01[PRIMARY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态，守护类型是GLOBAL

[monitor]         2021-08-12 18:14:15: 实例RWC1_01B[STANDBY, OPEN, ISTAT_SAME:TRUE]可加入实例RWC1_01[PRIMARY, OPEN, ISTAT_SAME:TRUE]
[monitor]         2021-08-12 18:14:15: 实例RWC1_01B[STANDBY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor]         2021-08-12 18:14:15: 实例RWC1_01B[STANDBY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态，守护类型是GLOBAL

[monitor]         2021-08-12 18:14:15: 组(GRWC1)当前活动实例运行正常

[monitor]         2021-08-12 18:14:15: 所有组中的活动实例运行正常！

可以看到所有实例运行正常，RWC集群部署完成。

更多资讯请上达梦技术社区了解：https://eco.dameng.com