DM8 配置读写分离集群

DM8 配置读写分离集群

配置环境说明

机器名

ip地址

初始状态

os

备注

dm1

192.168.43.131

192.168.2.131

主库: GRP1_RWW_01

Centos 7.9

43网段为外部服务

2网段为内部服务

dm2

192.168.43.132

192.168.2.132

备库: GRP1_RWW_02

Centos 7.9

43网段为外部服务

2网段为内部服务

dm3

192.168.43.133

192.168.2.133

备库: GRP1_RWW_03

Centos 7.9

43网段为外部服务

2网段为内部服务

dmm

192.168.43.134

192.168.2.131

确认监视器

Centos 7.9

43网段为外部服务

2网段为内部服务

端口规划

实例名

PORT_NUM

MAL_INST_DW_PORT

MAL_HOST

MAL_PORT

MAL_DW_PORT

GRP1_RWW_01

5236

33141

192.168.2.131

61141

52141

GRP1_RWW_02

5236

33141

192.168.2.132

61141

52141

GRP1_RWW_03

5236

33141

192.168.2.133

61141

52141

dm1 上初始化数据库至目录/dm/data

主库脱机备份:

RMAN> BACKUP DATABASE '/dm/data/DAMENG/dm.ini' full to BACKUP_FILE1 BACKUPSET '/dm/data/BACKUP_FILE_01' ;

BACKUP DATABASE '/dm/data/DAMENG/dm.ini' full to BACKUP_FILE1 BACKUPSET '/dm/data/BACKUP_FILE_01';

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[37398], file_lsn[37398]

Processing backupset /dm/data/BACKUP_FILE_01

[Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]                                 

backup successfully!

time used: 00:00:03.295

RMAN>

复制备份到备份

dmdba@dm1 data]$ scp -r BACKUP_FILE_01 192.168.43.132:/dm/data/

dmdba@192.168.43.132's password:

BACKUP_FILE_01.bak                                                                                                                                      100% 7166KB  32.8MB/s   00:00    

BACKUP_FILE_01.meta                                                                                                                                     100%   81KB  10.0MB/s   00:00    

[dmdba@dm1 data]$ scp -r BACKUP_FILE_01 192.168.43.133:/dm/data/

The authenticity of host '192.168.43.133 (192.168.43.133)' can't be established.

ECDSA key fingerprint is SHA256:1l3JToaSQO8O6/jH7wVNs6u6AEL3N51sfTXhN8k8Dcg.

ECDSA key fingerprint is MD5:e3:f0:7b:8c:2f:88:fa:09:e0:97:f2:5e:27:61:e1:77.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added '192.168.43.133' (ECDSA) to the list of known hosts.

dmdba@192.168.43.133's password:

BACKUP_FILE_01.bak                                                                                                                                      100% 7166KB  37.5MB/s   00:00    

BACKUP_FILE_01.meta                                                                                                                                     100%   81KB  14.7MB/s   00:00    

[dmdba@dm1 data]$

备库还原:

[dmdba@dm2 data]$ dmrman

dmrman V8

RMAN> restore database '/dm/data/DAMENG/dm.ini' from backupset '/dm/data/BACKUP_FILE_01' ;

restore database '/dm/data/DAMENG/dm.ini' from backupset '/dm/data/BACKUP_FILE_01';

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.540

RMAN> recover database '/dm/data/DAMENG/dm.ini' from backupset '/dm/data/BACKUP_FILE_01' ;

recover database '/dm/data/DAMENG/dm.ini' from backupset '/dm/data/BACKUP_FILE_01';

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[37398], file_lsn[37398]

备份集[/dm/data/BACKUP_FILE_01]备份过程中未产生日志

recover successfully!

time used: 317.651(ms)

RMAN> recover database '/dm/data/DAMENG/dm.ini' update DB_MAGIC ;

recover database '/dm/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[37398], file_lsn[37398]

recover successfully!

time used: 00:00:01.046

RMAN>

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

[dmdba@dm3 ~]$ dmrman

dmrman V8

RMAN> restore database '/dm/data/DAMENG/dm.ini' from backupset '/dm/data/BACKUP_FILE_01' ;

restore database '/dm/data/DAMENG/dm.ini' from backupset '/dm/data/BACKUP_FILE_01';

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.460

RMAN> recover database '/dm/data/DAMENG/dm.ini' from backupset '/dm/data/BACKUP_FILE_01' ;

recover database '/dm/data/DAMENG/dm.ini' from backupset '/dm/data/BACKUP_FILE_01';

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[37398], file_lsn[37398]

备份集[/dm/data/BACKUP_FILE_01]备份过程中未产生日志

recover successfully!

time used: 332.288(ms)

RMAN> recover database '/dm/data/DAMENG/dm.ini' update DB_MAGIC ;

recover database '/dm/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[37398], file_lsn[37398]

recover successfully!

time used: 00:00:01.065

RMAN>

主库配置

1.dmarch.ini

[ARCHIVE_TIMELY1]

    ARCH_TYPE = TIMELY #即时归档类型

    ARCH_DEST = GRP1_RWW_02 #即时归档目标实例名

[ARCHIVE_TIMELY2]

    ARCH_TYPE = TIMELY #即时归档类型

    ARCH_DEST = GRP1_RWW_03 #即时归档目标实例名

[ARCHIVE_LOCAL1]

    ARCH_TYPE = LOCAL                     ##本地归档类型

    ARCH_DEST = /dm/data/DAMENG/arch    ##本地归档文件路径

    ARCH_FILE_SIZE = 128                 ##单位Mb,本地单个归档文件最大值

    ARCH_SPACE_LIMIT = 0                 ##单位Mb,0表示无限制,范围1024~2147483647M

2.dmmal.ini

MON_DW_CONFIRM = 1 #确认监视器模式

MON_LOG_PATH = /dm/data/log #监视器日志文件存放路径

MON_LOG_INTERVAL = 60 #每隔 60s 定时记录系统信息到日志文件

MON_LOG_FILE_SIZE = 32 #每个日志文件最大 32M

MON_LOG_SPACE_LIMIT = 0 #不限定日志文件总占用空间

[GRP1]

MON_INST_OGUID = 453332 #组 GRP1 的唯一 OGUID 值 #以下配置为监视器到组 GRP1 的守护进程的连接信息,以―IP:PORT‖的形式配置

#IP 对应 dmmal.ini 中的 MAL_HOST,PORT 对应 dmmal.ini 中的 MAL_DW_PORT

MON_DW_IP = 192.168.2.131:52141

MON_DW_IP = 192.168.2.132:52141

MON_DW_IP = 192.168.2.133:52141

    

3.dmwarcher.ini

[GRP1]

    DW_TYPE =GLOBAL                     ##全局守护类型

    DW_MODE = AUTO                         ##自动切换模式

    DW_ERROR_TIME = 10                     ##远程守护进程故障认定时间

    INST_RECOVER_TIME = 60                 ##主库守护进程启动恢复的间隔时间

    INST_ERROR_TIME = 10                 ##本地实例故障认定时间

    INST_OGUID = 453332                 ##守护系统唯一OGUID值

    INST_INI = /dm/data/DAMENG/dm.ini     ##dm.ini配置文件路径

    INST_AUTO_RESTART = 1                 ##打开实例的自动启动功能

    INST_STARTUP_CMD = /dm/bin/dmserver ##命令行方式启动

    RLOG_SEND_THRESHOLD = 0             ##指定主库发送日志到备库的时间阈值,默认关闭

    RLOG_APPLY_THRESHOLD = 0             ##指定备库重演日志的时间阈值,默认关闭

4.修改dm.ini

#实例名,建议使用―组名_守护环境_序号‖的命名方式,总长度不能超过 16

INSTANCE_NAME

= GRP1_RWW_01

PORT_NUM

= 32141 #数据库实例监听端口

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 次的日志发送信息

复制主库配置到备库.

[root@dm1 DAMENG]# scp d*.ini 192.168.43.132:/dm/data/DAMENG/

The authenticity of host '192.168.43.132 (192.168.43.132)' can't be established.

ECDSA key fingerprint is SHA256:1l3JToaSQO8O6/jH7wVNs6u6AEL3N51sfTXhN8k8Dcg.

ECDSA key fingerprint is MD5:e3:f0:7b:8c:2f:88:fa:09:e0:97:f2:5e:27:61:e1:77.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added '192.168.43.132' (ECDSA) to the list of known hosts.

root@192.168.43.132's password:

dmarch.ini                                                                                                                                              100%  453   410.0KB/s   00:00    

dm.ini                                                                                                                                                  100%   56KB   9.9MB/s   00:00    

dmmal.ini                                                                                                                                               100% 1036   663.0KB/s   00:00    

dmwatcher.ini                                                                                                                                           100%  712   471.0KB/s   00:00    

[root@dm1 DAMENG]# scp d*.ini 192.168.43.133:/dm/data/DAMENG/

The authenticity of host '192.168.43.133 (192.168.43.133)' can't be established.

ECDSA key fingerprint is SHA256:1l3JToaSQO8O6/jH7wVNs6u6AEL3N51sfTXhN8k8Dcg.

ECDSA key fingerprint is MD5:e3:f0:7b:8c:2f:88:fa:09:e0:97:f2:5e:27:61:e1:77.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added '192.168.43.133' (ECDSA) to the list of known hosts.

root@192.168.43.133's password:

Permission denied, please try again.

root@192.168.43.133's password:

dmarch.ini                                                                                                                                              100%  453   275.7KB/s   00:00    

dm.ini                                                                                                                                                  100%   56KB  11.3MB/s   00:00    

dmmal.ini                                                                                                                                               100% 1036   539.2KB/s   00:00    

dmwatcher.ini                                                                                                                                           100%  712   532.5KB/s   00:00    

[root@dm1 DAMENG]#

修改备库参数

GRP1_RWW_02:

1.dm.ini

INSTANCE_NAME                   = GRP1_RWW_02

2.dmarch.ini

[ARCHIVE_TIMELY1]

    ARCH_TYPE = TIMELY #即时归档类型

    ARCH_DEST = GRP1_RWW_01 #即时归档目标实例名

[ARCHIVE_TIMELY2]

    ARCH_TYPE = TIMELY #即时归档类型

    ARCH_DEST = GRP1_RWW_03 #即时归档目标实例名

[ARCHIVE_LOCAL1]

    ARCH_TYPE = LOCAL                     ##本地归档类型

    ARCH_DEST = /dm/data/DAMENG/arch    ##本地归档文件路径

    ARCH_FILE_SIZE = 128                 ##单位Mb,本地单个归档文件最大值

    ARCH_SPACE_LIMIT = 0                 ##单位Mb,0表示无限制,范围1024~2147483647M

GRP1_RWW_03:

1.dm.ini

INSTANCE_NAME                   = GRP1_RWW_03

2.dmarch.ini

[ARCHIVE_TIMELY1]

    ARCH_TYPE = TIMELY #即时归档类型

    ARCH_DEST = GRP1_RWW_02 #即时归档目标实例名

[ARCHIVE_TIMELY2]

    ARCH_TYPE = TIMELY #即时归档类型

    ARCH_DEST = GRP1_RWW_01 #即时归档目标实例名

[ARCHIVE_LOCAL1]

    ARCH_TYPE = LOCAL                     ##本地归档类型

    ARCH_DEST = /dm/data/DAMENG/arch    ##本地归档文件路径

    ARCH_FILE_SIZE = 128                 ##单位Mb,本地单个归档文件最大值

    ARCH_SPACE_LIMIT = 0                 ##单位Mb,0表示无限制,范围1024~2147483647M


主库启动到mount状态

dmserver /dm/data/DAMENG/dm.ini mount

设置OGUID

SQL> SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1) ;

DMSQL 过程已成功完成

已用时间: 10.980(毫秒). 执行号:0.

SQL> SP_SET_OGUID(453332) ;

DMSQL 过程已成功完成

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

SQL> SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',0) ;

DMSQL 过程已成功完成

已用时间: 9.478(毫秒). 执行号:2.

修改数据库模式

SQL> alter database primary ;

操作已执行

已用时间: 6.900(毫秒). 执行号:0.

SQL>

配置备库  GRP1_RWW_02:

启动到mount状态

/dmserver /dm/data/DAMENG/dm.ini mount

设置OGUID

SQL> SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1) ;

DMSQL 过程已成功完成

已用时间: 21.181(毫秒). 执行号:0.

SQL> SP_SET_OGUID(453332);

DMSQL 过程已成功完成

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

SQL> SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',0) ;

DMSQL 过程已成功完成

已用时间: 5.332(毫秒). 执行号:2.

SQL>

修改数据库模式

SQL> alter database standby ;

操作已执行

已用时间: 7.314(毫秒). 执行号:0

配置备库  GRP1_RWW_03:

启动到mount状态

/dmserver /dm/data/DAMENG/dm.ini mount

设置OGUID

SQL> SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1) ;

DMSQL 过程已成功完成

已用时间: 21.181(毫秒). 执行号:0.

SQL> SP_SET_OGUID(453332);

DMSQL 过程已成功完成

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

SQL> SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',0) ;

DMSQL 过程已成功完成

已用时间: 5.332(毫秒). 执行号:2.

SQL>

修改数据库模式

SQL> alter database standby ;

操作已执行

已用时间: 7.314(毫秒). 执行号:0

查看数据库模式:

--主库

SQL> select i.HOST_NAME ,i.NAME ,i."STATUS$",i."MODE$" ,d.ARCH_MODE from v$instance i ,v$database d ;

行号     HOST_NAME NAME        STATUS$ MODE$   ARCH_MODE

---------- --------- ----------- ------- ------- ---------

1          dm1       GRP1_RWW_01 MOUNT   PRIMARY Y

已用时间: 6.074(毫秒). 执行号:3.

--备库

SQL> select i.HOST_NAME ,i.NAME ,i."STATUS$",i."MODE$" ,d.ARCH_MODE from v$instance i ,v$database d ;

行号     HOST_NAME NAME        STATUS$ MODE$   ARCH_MODE

---------- --------- ----------- ------- ------- ---------

1          dm2       GRP1_RWW_02 MOUNT   STANDBY Y

SQL> select i.HOST_NAME ,i.NAME ,i."STATUS$",i."MODE$" ,d.ARCH_MODE from v$instance i ,v$database d ;

行号     HOST_NAME NAME        STATUS$ MODE$   ARCH_MODE

---------- --------- ----------- ------- ------- ---------

1          dm3       GRP1_RWW_03 MOUNT   STANDBY Y

已用时间: 3.735(毫秒). 执行号:3.

配置监视器

添加dmmonitor.ini

MON_LOG_PATH = /dm/data/log

MON_LOG_INTERVAL = 60

MON_LOG_FILE_SIZE = 32

MON_LOG_SPACE_LIMIT = 0

MON_DW_CONFIRM = 1

MON_INST_NUM = 3 #实例总个数

MON_HB_INTERVAL = 60 #通信心跳校验间隔

MON_BRO_INTERVAL = 100 #raft 协议中实例通信心跳间隔

MON_VOTE_INTERVAL = 100 #raft 协议中基础投票间隔

MON_ID = 1 #当前监视器在监视器系统中的

MON_MID = 45614 #当前监视器系统的唯一标识

[GRP1]

MON_INST_OGUID = 453332

MON_DW_IP = 192.168.2.131:52141

MON_DW_IP = 192.168.2.132:52141

MON_DW_IP = 192.168.2.133:52141

[MON1]

MON_HOST = 192.168.2.131 #系统监听 TCP 连接的 IP 地址

MON_PORT = 8339 #系统监听 TCP 连接的端口号

MON_INST_ID = 1 #监视器实例在监视器系统中的 ID

[MON2]

MON_HOST = 192.168.2.132 #系统监听 TCP 连接的 IP 地址

MON_PORT = 8339 #系统监听 TCP 连接的端口号

MON_INST_ID = 1 #监视器实例在监视器系统中的 ID

[MON3]

MON_HOST = 192.168.2.133 #系统监听 TCP 连接的 IP 地址

MON_PORT = 8339 #系统监听 TCP 连接的端口号

MON_INST_ID = 1 #监视器实例在监视器系统中的 ID

启动守护进程

命令

dmwatcher /dm/data/DAMENG/dmwatcher.ini

或者添加为服务

[root@dm1 root]# ./dm_service_installer.sh -t dmwatcher -watcher_ini /dm/data/DAMENG/dmwatcher.ini -p dw1

Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServicedw1.service to /usr/lib/systemd/system/DmWatcherServicedw1.service.

创建服务(DmWatcherServicedw1)完成

[root@dm1 root]# systemctl start DmWatcherServicedw1

[root@dm2 root]# ./dm_service_installer.sh -t dmwatcher -watcher_ini /dm/data/DAMENG/dmwatcher.ini -p dw2

Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServicedw2.service to /usr/lib/systemd/system/DmWatcherServicedw2.service.

创建服务(DmWatcherServicedw2)完成

[root@dm1 root]# systemctl start DmWatcherServicedw2

[root@dm3 root]# ./dm_service_installer.sh -t dmwatcher -watcher_ini /dm/data/DAMENG/dmwatcher.ini -p dw3

Created symlink from /etc/systemd/system/multi-user.target.wants/DmWatcherServicedw1.service to /usr/lib/systemd/system/DmWatcherServicedw1.service.

创建服务(DmWatcherServicedw3)完成

[root@dm1 root]# systemctl start DmWatcherServicedw3

启动监视器

命令

./dmmonitor /dm/data/dmmonitor.ini

注册为服务

[root@dmm root]# ./dm_service_installer.sh -t dmmonitor -monitor_ini /dm/data/DAMENG/dmmonitor.ini -p DM

Created symlink from /etc/systemd/system/multi-user.target.wants/DmMonitorServiceDM.service to /usr/lib/systemd/system/DmMonitorServiceDM.service.

创建服务(DmMonitorServiceDM)完成

启动监视器

[dmdba@dmm ~]$ dmmonitor /dm/data/DAMENG/dmmonitor.ini

[monitor]         2022-08-02 15:13:46: DMMONITOR[4.0] V8

[monitor]         2022-08-02 15:13:46: DMMONITOR[4.0] IS READY.

[monitor]         2022-08-02 15:13:46: 收到守护进程(GRP1_RWW_01)消息

                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            

                  2022-08-02 15:13:46  OPEN           OK        GRP1_RWW_01      OPEN        PRIMARY   VALID    3        38887           38887           

[monitor]         2022-08-02 15:13:46: 收到守护进程(GRP1_RWW_03)消息

                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            

                  2022-08-02 15:13:46  OPEN           OK        GRP1_RWW_03      OPEN        STANDBY   VALID    3        38887           38887           

[monitor]         2022-08-02 15:13:46: 收到守护进程(GRP1_RWW_02)消息

                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN            

                  2022-08-02 15:13:46  OPEN           OK        GRP1_RWW_02      OPEN        STANDBY   VALID    3        38887           38887           

show

2022-08-02 15:13:53

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

GROUP            OGUID       MON_CONFIRM     MODE            MPP_FLAG  

GRP1             453332      TRUE            AUTO            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.2.131       52141        2022-08-02 15:13:52  GLOBAL    VALID     OPEN           GRP1_RWW_01      OK        1     1     OPEN        PRIMARY   DSC_OPEN       TIMELY    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.43.131      5236       OK        GRP1_RWW_01      OPEN        PRIMARY   0          0            TIMELY    VALID    4759            38889           4759            38889           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.2.132       52141        2022-08-02 15:13:52  GLOBAL    VALID     OPEN           GRP1_RWW_02      OK        1     1     OPEN        STANDBY   DSC_OPEN       TIMELY    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.43.132      5236       OK        GRP1_RWW_02      OPEN        STANDBY   0          0            TIMELY    VALID    4522            38889           4522            38889           NONE                  

DATABASE(GRP1_RWW_02) APPLY INFO FROM (GRP1_RWW_01), REDOS_PARALLEL_NUM (1):

DSC_SEQNO[0], (RSEQ, SSEQ, KSEQ)[4759, 4759, 4759], (RLSN, SLSN, KLSN)[38889, 38889, 38889], N_TSK[0], TSK_MEM_USE[0]

REDO_LSN_ARR: (38889)

<<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.2.133       52141        2022-08-02 15:13:52  GLOBAL    VALID     OPEN           GRP1_RWW_03      OK        1     1     OPEN        STANDBY   DSC_OPEN       TIMELY    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.43.133      5236       OK        GRP1_RWW_03      OPEN        STANDBY   0          0            TIMELY    VALID    4522            38889           4522            38889           NONE                  

DATABASE(GRP1_RWW_03) APPLY INFO FROM (GRP1_RWW_01), REDOS_PARALLEL_NUM (1):

DSC_SEQNO[0], (RSEQ, SSEQ, KSEQ)[4759, 4759, 4759], (RLSN, SLSN, KLSN)[38889, 38889, 38889], N_TSK[0], TSK_MEM_USE[0]

REDO_LSN_ARR: (38889)

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

达梦数据库 - 新一代大型通用关系型数据库 | 达梦在线服务平台达梦数据库产品体验站,DM8在线试玩,达梦数据库全系列产品免费下载,官方权威的快速上手文档和产品手册,最活跃的达梦技术社区,面向全行业ISV厂商免费的云适配服务。icon-default.png?t=M7J4https://eco.dameng.com

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值