2节点dsc+1节点dw
2、在机器DSC0上准备dmdcr_cfg.ini配置文件 2
3、准备DMASM的MAL配置文件(命名为dmasvrmal.ini) 3
5、在DSC0上使用dmasmtool工具创建DMASM磁盘组 4
6、准备dminit.ini配置文件,保存到/home/dmdba/dmdbms/data 5
一、规划
配置环境说明
机器名 |
IP地址 |
初始化状态 |
操作系统 |
damneg01 |
192.168.138.198 |
主库 DSC0 DSC1 |
中标麒麟 |
dameng02 |
192.168.138.199 |
GRP1_RT_01 |
中标麒麟 |
dameng03 |
192.168.138.120 |
确认监视器 |
中标麒麟 |
端口规划
实例名 |
PORT_NUM |
MAL_INST_DW_PORT |
MAL_HOST |
MAL_PORT |
MAL_DW_PORT |
DSC0 |
5236 |
4567 |
192.168.138.198 |
8338 |
3567 |
DSC1 |
5237 |
4568 |
192.168.138.198 |
8339 |
3568 |
GRP1_RT_01 |
5236 |
4569 |
192.168.138.120 |
8738 |
3569 |
二、配置DMDSC主库环境
因为2个dsc节点都在一台机器上,所以在data目录下创建dsc0和dsc1两个不同的文件夹来存放两个节点的配置。
1、准备共享硬盘
2、在机器DSC0上准备dmdcr_cfg.ini配置文件
保存在/home/dmdba/dmdbms/data
DCR_N_GRP = 3 DCR_VTD_PATH = /dev/raw/raw2 DCR_OGUID = 63635 [GRP] DCR_GRP_TYPE = CSS DCR_GRP_NAME = GRP_CSS DCR_GRP_N_EP = 2 DCR_GRP_DSKCHK_CNT = 60 [GRP_CSS] DCR_EP_NAME = CSS0 DCR_EP_HOST = 192.168.138.198 DCR_EP_PORT = 9341 [GRP_CSS] DCR_EP_NAME = CSS1 DCR_EP_HOST = 192.168.138.198 DCR_EP_PORT = 9343 [GRP] DCR_GRP_TYPE = ASM DCR_GRP_NAME = GRP_ASM DCR_GRP_N_EP = 2 DCR_GRP_DSKCHK_CNT = 60 [GRP_ASM] DCR_EP_NAME = ASM0 DCR_EP_SHM_KEY = 93360 DCR_EP_SHM_SIZE = 10 DCR_EP_HOST = 192.168.138.198 DCR_EP_PORT = 9349 DCR_EP_ASM_LOAD_PATH = /dev/raw [GRP_ASM] DCR_EP_NAME = ASM1 DCR_EP_SHM_KEY = 93361 DCR_EP_SHM_SIZE = 10 DCR_EP_HOST = 192.168.138.198 DCR_EP_PORT = 9351 DCR_EP_ASM_LOAD_PATH = /dev/raw [GRP] DCR_GRP_TYPE = DB DCR_GRP_NAME = GRP_DSC DCR_GRP_N_EP = 2 DCR_GRP_DSKCHK_CNT = 60 [GRP_DSC] DCR_EP_NAME = DSC0 DCR_EP_SEQNO = 0 DCR_EP_PORT = 5236 DCR_CHECK_PORT = 9741 [GRP_DSC] DCR_EP_NAME = DSC1 DCR_EP_SEQNO = 1 DCR_EP_PORT = 5237 DCR_CHECK_PORT = 9742 |
3、准备DMASM的MAL配置文件(命名为dmasvrmal.ini)
[MAL_INST1]
MAL_INST_NAME = ASM0
MAL_HOST = 192.168.138.198
MAL_PORT = 7236
[MAL_INST2]
MAL_INST_NAME = ASM1
MAL_HOST = 192.168.138.198
MAL_PORT = 7237
4、准备dmdcr.ini 配置文件
在dmdba用户下的/home/dmdba/dmdbms/data目录下配置dmdcr.ini,其中dmdcr_path相同,dmasvrmal.ini文件内容也相同,dmdcr_seqo分别为0和1
节点DSC0 192.168.138.198:5236
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/dmdbms/data/dsc0/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 0
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 0
DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdbms/data/dsc0/dmdcr.ini
#DB 重启参数,命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdbms/data/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdbms/data/dsc0/dmdcr.ini mount
节点DSC1 192.168.138.198:5237
DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/home/dmdba/dmdbms/data/dsc1/dmasvrmal.ini #dmasmsvr 使用的 MAL 配置文件路径
DMDCR_SEQNO = 1
#ASM 重启参数,命令行方式启动
DMDCR_ASM_RESTART_INTERVAL = 0
DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdbms/data/dsc1/dmdcr.ini
#DB 重启参数,命令行方式启动
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD=/home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdbms/data/dsc1_config/dm.ini dcr_ini=/home/dmdba/dmdbms/data/dsc1/dmdcr.ini mount
5、在DSC0上使用dmasmtool工具创建DMASM磁盘组
./dmasmtool DCR_INI=/home/dmdba/dmdbms/data/dsc0/dmdcr.ini
#创建日志磁盘组
create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
#创建数据磁盘组
create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'
6、准备dminit.ini配置文件,保存到/home/dmdba/dmdbms/data
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 log_size = 256 dcr_path = /dev/raw/raw1 #dcr 磁盘路径,目前不支持 asm,只能是裸设备 dcr_seqno = 0 auto_overwrite = 1 [DSC0] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应 config_path = /home/dmdba/dmdbms/data/dsc0_config port_num = 5236 mal_host = 192.168.138.198 mal_port = 9340 log_path = +DMLOG/log/dsc0_log01.log log_path = +DMLOG/log/dsc0_log02.log [DSC1] #inst_name 跟 dmdcr_cfg.ini 中 DB 类型 group 中 DCR_EP_NAME 对应 config_path = /home/dmdba/dmdbms/data/dsc1_config port_num = 5237 mal_host = 192.168.138.198 mal_port = 9341 log_path = +DMLOG/log/dsc1_log01.log log_path = +DMLOG/log/dsc1_log02.log |
7、使用 dminit 初始化 DB 环境
选择一个节点DSC0,启动dminit工具初始化数据库。dminit执行完成后,会在config_path目录下生成配置文件dm.ini和dmal.ini
[dmdba@dameng01 bin]$ ./dmserver /home/dmdba/dmdbms/data/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdbms/data/dsc0/dmdcr.ini
[dmdba@dameng01 bin]$ ./dmserver /home/dmdba/dmdbms/data/dsc1_config/dm.ini dcr_ini=/home/dmdba/dmdbms/data/dsc1/dmdcr.ini
主库的dsc搭建完成。
搭建完成后,正常退出DMDSC集群的两个dmserver节点实例,不需要退出dmcss和dmasmsvr。
8、配置DSC0和DSC1的dmarch.ini文件
分别编辑两个DMDSC节点的dmarch.ini文件,增加本地归档和远程归档,dmarch.ini文件放在各自dm.ini中指定的CONFIG_PATH目录下。
配置dsc0:
[ARCHIVE_LOCAL1]
ARCH_TYPE= LOCAL
ARCH_DEST= /home/dmdba/dmdbms/data/dsc0/arch
ARCH_FILE_SIZE= 128
ARCH_SPACE_LIMIT= 0
[ARCHIVE_REMOTE]
ARCH_TYPE= REMOTE
ARCH_DEST= DSC1
ARCH_FILE_SIZE= 128
ARCH_SPACE_LIMIT= 0
ARCH_INCOMING_PATH = /home/dmdba/dmdbms/data/dsc0/arch_remote
配置dsc1:
[ARCHIVE_LOCAL1]
ARCH_TYPE= LOCAL
ARCH_DEST= /home/dmdba/dmdbms/data/dsc1/arch
ARCH_FILE_SIZE= 128
ARCH_SPACE_LIMIT= 0
[ARCHIVE_REMOTE]
ARCH_TYPE= REMOTE
ARCH_DEST= DSC0
ARCH_FILE_SIZE= 128
ARCH_SPACE_LIMIT= 0
ARCH_INCOMING_PATH = /home/dmdba/dmdbms/data/dsc1/arch_remote
9、配置dm.ini
分别编辑两个DMDSC节点的dm.ini文件,打开归档参数:ARCH_INI= 1
10、备份DSC
重启DMDSC集群的两个dmserver实例,然后再正常退出。在DMDSC集群生成有归档日志的情况下进行脱机备份,以便后续校验日志连续性时使用。
[dmdba@dameng01 bin]$ ./dmrman use_ap=2 dcr_ini=/home/dmdba/dmdbms/data/dsc0/dmdcr.ini
backup database '/home/dmdba/dmdbms/data/dsc0_config/dm.ini' full backupset '/home/dmdba/dmdbms/data/db_full_bak_for_dsc';
三、配置单节点备库
1、准备备库环境
--初始化备库
./dminit path=/home/dmdba/dmdbms/data/EP01/
--将dsc主库下的备份集发送到备库
[dmdba@dameng01 data]$ scp -r db_full_bak_for_dsc dmdba@192.168.138.199:/home/dmdba/dmdbms/data/
--启动dmrman
./dmrman use_ap=2
--还原、恢复、更新
restore database '/home/dmdba/dmdbms/data/EP01/DAMENG/dm.ini' from backupset '/home/dmdba/dmdbms/data/db_full_bak_for_dsc';
recover database '/home/dmdba/dmdbms/data/EP01/DAMENG/dm.ini' from backupset '/home/dmdba/dmdbms/data/db_full_bak_for_dsc';
recover database '/home/dmdba/dmdbms/data/EP01/DAMENG/dm.ini' update DB_MAGIC;
2、配置dm.ini
依次配置DMDSC主库所有节点和单节点备库的dm.ini文件,修改数据守护相关的参数配置。
(1)配置DSC0的dm.ini文件
#实例名,建议使用―组名_守护环境_序号‖的命名方式,总长度不能超过16
INSTANCE_NAME= DSC0
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)配置DSC1的dm.ini文件
INSTANCE_NAME= DSC1
PORT_NUM= 5237#数据库实例监听端口
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次的日志发送信息
(3)配置GRP1_RT_01的dm.ini文件
INSTANCE_NAME= GRP1_RT_01
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、配置dmmal.ini
MAL_CHECK_INTERVAL = 30 #MAL链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 10 #判定MAL链路断开的时间
[mal_inst0]
mal_inst_name = DSC0
mal_host = 192.168.138.198
mal_port = 9347
MAL_INST_HOST = 192.168.138.198 #实例的对外服务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 = DSC1
mal_host = 192.168.138.198
mal_port = 9348
MAL_INST_HOST = 192.168.138.198 #实例的对外服务IP地址
MAL_INST_PORT = 5237 #实例的对外服务端口,和dm.ini中的PORT_NUM一致
MAL_DW_PORT= 3568 #实例本地的守护进程监听TCP连接的端口
MAL_INST_DW_PORT = 4568 #实例监听守护进程TCP连接的端口
[mal_inst2]
mal_inst_name = GRP1_RT_01
mal_host = 192.168.138.199
mal_port = 8738
MAL_INST_HOST = 192.168.138.199 #实例的对外服务IP地址
MAL_INST_PORT = 5236 #实例的对外服务端口,和dm.ini中的PORT_NUM一致
MAL_DW_PORT= 3569 #实例本地的守护进程监听TCP连接的端口
MAL_INST_DW_PORT = 4569 #实例监听守护进程TCP连接的端口
4、配置dmarch.ini
DSC0配置:
[ARCHIVE_LOCAL1]
ARCH_TYPE= LOCAL
ARCH_DEST= /home/dmdba/dmdbms/data/dsc0/arch
ARCH_FILE_SIZE= 128
ARCH_SPACE_LIMIT= 0
[ARCHIVE_REMOTE]
ARCH_TYPE= REMOTE
ARCH_DEST= DSC1
ARCH_FILE_SIZE= 128
ARCH_SPACE_LIMIT= 0
ARCH_INCOMING_PATH = /home/dmdba/dmdbms/data/dsc0/arch_remote
[ARCHIVE_REALTIME]
ARCH_TYPE= REALTIME
ARCH_DEST= GRP1_RT_01
DSC1配置:
[ARCHIVE_LOCAL1]
ARCH_TYPE= LOCAL
ARCH_DEST= /home/dmdba/dmdbms/data/dsc1/arch
ARCH_FILE_SIZE= 128
ARCH_SPACE_LIMIT= 0
[ARCHIVE_REMOTE]
ARCH_TYPE= REMOTE
ARCH_DEST= DSC0
ARCH_FILE_SIZE= 128
ARCH_SPACE_LIMIT= 0
ARCH_INCOMING_PATH = /home/dmdba/dmdbms/data/dsc1/arch_remote
[ARCHIVE_REALTIME]
ARCH_TYPE= REALTIME
ARCH_DEST= GRP1_RT_01
GRP1_RT_01配置:
[ARCHIVE_LOCAL1]
ARCH_TYPE= LOCAL
ARCH_DEST= /home/dmdba/dmdbms/data/EP01/DAMENG/arch
ARCH_FILE_SIZE= 128
ARCH_SPACE_LIMIT= 0
[ARCHIVE_REALTIME1]
ARCH_TYPE= REALTIME
ARCH_DEST= DSC0/DSC1
5、配置dmwatcher
DSC0的dmwatcher:
[GRP1]
DW_TYPE= GLOBAL #全局守护类型
DW_MODE= MANUAL #手动切换模式
DW_ERROR_TIME= 60#远程守护进程故障认定时间
INST_RECOVER_TIME= 60#主库守护进程启动恢复的间隔时间
INST_ERROR_TIME = 35#本地实例故障认定时间
INST_INI= /home/dmdba/dmdbms/data/dsc0_config/dm.ini #dm.ini配置文件路径
DCR_INI= /home/dmdba/dmdbms/data/dsc0/dmdcr.ini #dmdcr.ini配置文件路径
INST_OGUID = 1000#守护系统唯一OGUID值
INST_STARTUP_CMD= /home/dmdba/dmdbms/bin/dmserver #命令行方式启动
INST_AUTO_RESTART= 0#关闭实例的自动启动功能
RLOG_SEND_THRESHOLD= 0#指定主库发送日志到备库的时间阈值,默认关闭 RLOG_APPLY_THRESHOLD = 0#指定备库重演日志的时间阈值,默认关闭
DSC1的dmwatcher:
[GRP1]
DW_TYPE= GLOBAL #全局守护类型
DW_MODE= MANUAL #手动切换模式
DW_ERROR_TIME= 60#远程守护进程故障认定时间
INST_RECOVER_TIME= 60#主库守护进程启动恢复的间隔时间
INST_ERROR_TIME = 35#本地实例故障认定时间
INST_INI= /home/dmdba/dmdbms/data/dsc1_config/dm.ini #dm.ini配置文件路径
DCR_INI= /home/dmdba/dmdbms/data/dsc1/dmdcr.ini #dmdcr.ini配置文件路径
INST_OGUID = 1000#守护系统唯一OGUID值
INST_STARTUP_CMD= /home/dmdba/dmdbms/bin/dmserver #命令行方式启动
INST_AUTO_RESTART= 0#关闭实例的自动启动功能
RLOG_SEND_THRESHOLD= 0#指定主库发送日志到备库的时间阈值,默认关闭 RLOG_APPLY_THRESHOLD = 0#指定备库重演日志的时间阈值,默认关闭
GRP1_RT_01的dmwatcher.ini文件:
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 60
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 35
INST_INI = /home/dmdba/dmdbms/data/EP01/dm.ini
INST_OGUID = 1000
INST_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver
INST_AUTO_RESTART = 0 #对单节点,如果需要打开自动拉起功能,将此配置修改为1即可 RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
6、配置dmmonitor.ini
编辑dmmonitor.ini文件,放在/home/dmdba/dmdbms/data目录下:
MON_LOG_PATH= /home/dmdba/dmdbms/data/log
MON_LOG_INTERVAL= 60
MON_LOG_FILE_SIZE= 64
MON_LOG_SPACE_LIMIT= 0
MON_DW_CONFIRM= 0
[GRP1]
MON_INST_OGUID= 1000
MON_DW_IP= 192.168.138.198:3567/192.168.138.198:3568
MON_DW_IP= 192.168.138.199:3569
7、启动主备库
注意实例都要使用Mount方式启动。
[dmdba@dameng01 bin]$ ./dmserver /home/dmdba/dmdbms/data/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdbms/data/dsc0/dmdcr.ini mount
[dmdba@dameng01 bin]$ ./dmserver /home/dmdba/dmdbms/data/dsc1_config/dm.ini DCR_INI=/home/dmdba/dmdbms/data/dsc1/dmdcr.ini mount
[dmdba@dameng02 bin]$ ./dmserver /home/dmdba/dmdbms/data/EP01/DAMENG/dm.ini mount
8、设置OGUID
启动命令行工具DIsql,连接DMDSC集群中的任意一个节点,设置DMDSC主库的OGUID值。
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SP_SET_OGUID(1000);
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
DIsql连接单节点备库,设置备库OGUID。
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SP_SET_OGUID(1000);
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
9、修改主备库模式
启动命令行工具DIsql,连接DMDSC集群中的任意一个节点,修改DMDSC库为Primary模式。
ALTER DATABASE PRIMARY;
DIsql连接单节点备库,修改备库为Standby模式。
ALTER DATABASE STANDBY;
10、启动主备守护线程
[dmdba@dameng01 bin]$ ./dmwatcher /home/dmdba/dmdbms/data/dsc0_config/dmwatcher.ini
[dmdba@dameng01 bin]$ ./dmwatcher /home/dmdba/dmdbms/data/dsc1_config/dmwatcher.ini
[dmdba@dameng02 bin]$ ./dmwatcher /home/dmdba/dmdbms/data/EP01/DAMENG/dmwatcher.ini
11、启动监视器
[dmdba@dameng03 bin]$ ./dmmonitor /home/dmdba/dmdbms/data/dmmonitor.ini [monitor] 2020-12-11 09:56:12: DMMONITOR[4.0] V8 [monitor] 2020-12-11 09:56:17: DMMONITOR[4.0] IS READY. [monitor] 2020-12-11 09:56:17: 收到守护进程(GRP1_RT_01)消息 WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN 2020-12-11 09:56:17 OPEN OK GRP1_RT_01 OPEN STANDBY NULL 5 48001 48001 [monitor] 2020-12-11 09:56:17: 收到守护进程(DSC0)消息 WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN 2020-12-11 09:56:16 OPEN OK DSC0 OPEN PRIMARY VALID 5 48001 48001 [monitor] 2020-12-11 09:56:17: 收到守护进程(DSC1)消息 WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN 2020-12-11 09:56:16 STARTUP OK DSC0 OPEN PRIMARY VALID 5 48001 48001 |
show 2020-12-11 10:03:05 #================================================================================# GROUP OGUID MON_CONFIRM MODE MPP_FLAG GRP1 1000 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.138.198 3567 2020-12-11 10:03:05 GLOBAL VALID OPEN DSC0 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 DSC0 OPEN PRIMARY 0 0 REALTIME VALID 3955 48001 3955 48001 NONE 5237 OK DSC1 OPEN PRIMARY 1 0 REALTIME VALID 2494 48001 2494 48001 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.138.199 3569 2020-12-11 10:03:04 GLOBAL VALID OPEN GRP1_RT_01 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 GRP1_RT_01 OPEN STANDBY 0 0 REALTIME VALID 3946 48001 3946 48001 NONE DATABASE(GRP1_RT_01) APPLY INFO FROM (DSC0): DSC_SEQNO[0], (ASEQ, SSEQ, KSEQ)[3955, 3955, 3955], (ALSN, SLSN, KLSN)[48001, 48001, 48001], N_TSK[0], TSK_MEM_USE[0] DSC_SEQNO[1], (ASEQ, SSEQ, KSEQ)[2494, 2494, 2494], (ALSN, SLSN, KLSN)[48001, 48001, 48001], N_TSK[0], TSK_MEM_USE[0] #================================================================================# |
测试:在dsc0建表,dsc1中插入数据,在GRP1_RT_01中查询。如果三个节点都能查询到则测试搭建成功。