注册
DM8 DSC 集群 + DW 主备集群部署报告
技术分享/ 文章详情 /

DM8 DSC 集群 + DW 主备集群部署报告

好运连连 2026/11/17 37 0 0

DM8 DSC 集群 + DW 主备集群部署报告

1. 实验环境规划

1.1 主机信息

角色 主机名 IP 地址
主库 dm1 192.168.234.31
备库 dm2 192.168.234.32
监视器 dsc_dw 192.168.234.33

1.2 操作系统及硬件配置

项目 配置
操作系统 CentOS 7.9
CPU Intel Core i9-13900HX,2 核
内存 4 GB

1.3 目录规划

用途 路径
数据根目录 /dmdata/
数据库软件目录 /home/dmdba/dmdbms
归档目录 /dmdata/arch
备份目录 /dmdata/dmbak

2. 共享磁盘配置

本次测试设备限制,使用vmware的虚拟磁盘作为共享磁盘

2.1 创建 VMware 虚拟磁盘

使用 cmd 进入 VMware 软件目录:

.\vmware-vdiskmanager.exe -c -s 1g -a lsilogic -t 2 F:\dsc_disk\dcr_disk1.vmdk .\vmware-vdiskmanager.exe -c -s 1g -a lsilogic -t 2 F:\dsc_disk\vote_disk1.vmdk .\vmware-vdiskmanager.exe -c -s 20g -a lsilogic -t 2 F:\dsc_disk\dmdata_disk1.vmdk .\vmware-vdiskmanager.exe -c -s 10g -a lsilogic -t 2 F:\dsc_disk\dmlog_disk1.vmdk .\vmware-vdiskmanager.exe -c -s 10g -a lsilogic -t 2 F:\dsc_disk\dmarch_disk1.vmdk

2.2 配置虚拟机共享磁盘

进入虚拟机目录下,编辑虚拟机名.vmx,在末尾加上

disk.locking = "FALSE" diskLib.dataCacheMaxSize = "0" diskLib.dataCacheMaxReadAheadSize = "0" diskLib.dataCacheMinReadAheadSize = "0" diskLib.maxUnsyncedWrites = "0" scsi1.present = "TRUE" scsi1.virtualDev = "lsilogic" scsi1.sharedBus = "VIRTUAL" scsi1:0.present = "TRUE" scsi1:0.mode = "independent-persistent" scsi1:0.fileName = "F:\dsc_disk\dcr_disk1.vmdk" scsi1:0.deviceType = "disk" scsi1:0.redo = "" scsi1:1.present = "TRUE" scsi1:1.mode = "independent-persistent" scsi1:1.fileName = "F:\dsc_disk\vote_disk1.vmdk" scsi1:1.deviceType = "disk" scsi1:1.redo = "" scsi1:2.present = "TRUE" scsi1:2.mode = "independent-persistent" scsi1:2.fileName = "F:\dsc_disk\dmdata_disk1.vmdk" scsi1:2.deviceType = "disk" scsi1:2.redo = "" scsi1:3.present = "TRUE" scsi1:3.mode = "independent-persistent" scsi1:3.fileName = "F:\dsc_disk\dmlog_disk1.vmdk" scsi1:3.deviceType = "disk" scsi1:3.redo = "" scsi1:4.present = "TRUE" scsi1:4.mode = "independent-persistent" scsi1:4.fileName = "F:\dsc_disk\dmarch_disk1.vmdk" scsi1:4.deviceType = "disk" scsi1:4.redo = "" scsi1.pciSlotNumber = "36" usb:0.present = "TRUE" usb:0.deviceType = "hid" usb:0.port = "0" usb:0.parent = "-1"

重启虚拟机即可

2.3 识别磁盘设备与配置 UDEV 规则

for i in `cat /proc/partitions | awk '{print $4}' |grep sd | grep [b-z]$`; do echo "### $i: `/usr/lib/udev/scsi_id -g -u -d /dev/$i`"; done lsblk

编辑 UDEV 规则文件:

vi /etc/udev/rules.d/88-dm-asmdevices.rules

根据上面命令查询信息编写如下规则

KERNEL=="sd?", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c2945abaa61ebb7974ffd6c49a21", SYMLINK+="ASM/asm-dmdcr", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="sd?", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c294556fbc582d2290939382926c", SYMLINK+="ASM/asm-dmvote", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="sd?", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c29314aed45e888bd256d09a0ca4", SYMLINK+="ASM/asm-dmdata", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="sd?", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c299e100d986c1f5f1fd7257ce51", SYMLINK+="ASM/asm-dmlog", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="sd?", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c2929219fca9315e76fc4c1580ec", SYMLINK+="ASM/asm-dmarch", OWNER="dmdba", GROUP="dinstall", MODE="0660"

2.4 加载规则并检查磁盘

保存退出后,执行以下命令,使其生效

udevadm control --reload-rules udevadm trigger systemctl restart systemd-udev-trigger.service

执行授权语句:

chown dmdba:dinstall /dev/ASM/asm-* -R

检查软链是否生成:

ls -lth /dev/ASM blockdev --getsize64 /dev/ASM/asm-*

至此,虚拟磁盘配置完成

3. 部署前系统环境准备

以下系统配置需要在三台主机上按需完成。

3.1 防火墙

查看状态:

systemctl status firewalld

本次实验选择关闭防火墙:

systemctl stop firewalld systemctl disable firewalld

生产环境应根据实际端口规划配置防火墙规则,不建议直接关闭防火墙。

3.2 SELinux

查看状态:

getenforce

临时切换为宽松模式:

setenforce 0

如需永久禁用,编辑 /etc/selinux/config:

SELINUX=disabled

修改后需重启系统生效。

3.3 透明大页(THP)

创建服务文件:

cat > /etc/systemd/system/disable-thp.service <<'EOF' [Unit] Description=Disable Transparent Huge Pages (THP) [Service] Type=oneshot ExecStart=/bin/sh -c "echo never > /sys/kernel/mm/transparent_hugepage/enabled; echo never > /sys/kernel/mm/transparent_hugepage/defrag" RemainAfterExit=yes [Install] WantedBy=multi-user.target EOF

加载配置并启用:

systemctl daemon-reload systemctl enable --now disable-thp

检查设置:

cat /sys/kernel/mm/transparent_hugepage/enabled cat /sys/kernel/mm/transparent_hugepage/defrag

3.4 内核参数

查看当前值:

cat /proc/sys/vm/overcommit_memory

本次实验设置为 0:

sysctl -w vm.overcommit_memory=0

如需持久化,在 /etc/sysctl.conf 中增加:

vm.overcommit_memory = 0

应用配置:

sysctl -p

3.5 用户资源限制

检查当前配置:

grep -vE '^\s*#|^\s*$' /etc/security/limits.conf

按部署要求,为 dmdba 配置以下限制:

dmdba soft nice 0
dmdba hard nice 0
dmdba soft as unlimited
dmdba hard as unlimited
dmdba soft fsize unlimited
dmdba hard fsize unlimited
dmdba soft nproc 65536
dmdba hard nproc 65536
dmdba soft nofile 65536
dmdba hard nofile 65536
dmdba soft core unlimited
dmdba hard core unlimited
dmdba soft data unlimited
dmdba hard data unlimited

修改后重新登录 dmdba 用户,使配置生效。

3.6 时间同步

本次实验使用 chronyd 同步节点时间。请根据实际网络配置时间服务器,并确保相关网络端口可达。

在时间服务器节点编辑 /etc/chrony.conf,按需配置:

allow all
local stratum 10
rtcsync

在其他节点配置时间服务器地址,例如:

server 192.168.234.31 iburst prefer
makestep 1.0 3
rtcsync

重启服务并检查同步状态:

systemctl restart chronyd chronyc tracking

4. 创建用户与目录

4.1 创建用户和用户组

在需要部署 DM8 的主机上执行:

groupadd -g 2001 dinstall useradd -u 1001 -g dinstall dmdba passwd dmdba

如果用户或用户组已经存在,请先检查现有配置,不要重复创建。

4.2 创建目录

mkdir -p /dmdata/{arch,dmbak} chown -R dmdba:dinstall /dmdata/{arch,dmbak} chmod -R 755 /dmdata/{arch,dmbak}

5. DM8 软件安装

三台主机均需安装 DM8 软件。

5.1 安装软件

将安装介质挂载到系统,并确认安装文件可访问。切换至 dmdba 用户,进入安装介质目录执行:

./DMInstall.bin -i

本次安装选项如下:

项目 选择
安装语言 简体中文
Key 文件 未指定,按实验环境选择
时区 中国标准时间(GTM+08:00)
安装类型 典型安装
软件目录 /home/dmdba/dmdbms

安装完成后,以 root 用户执行:

/home/dmdba/dmdbms/script/root/root_installer.sh

检查 DMAP 服务:

systemctl status DmAPService

5.2 配置环境变量

在 /home/dmdba/.bash_profile 中配置相应环境变量。若已设置 DM_HOME,可增加:

export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool

使配置生效并检查工具路径:

source /home/dmdba/.bash_profile echo "$DM_HOME" which dminit which disql

6. DSC 安装

该步骤仅在192.168.234.31、192.168.234.32节点操作

6.1 调整依赖包

su - dmdba cd /home/dmdba/dmdbms/bin cp -r dependencies/* ./

6.2 配置dmdcr_cfg.ini

配置集群全局信息文件dmdcr_cfg.ini,所有节点内容需要一致

mkdir -p /home/dmdba/dmdbms/config cat > /home/dmdba/dmdbms/config/dmdcr_cfg.ini << EOF DCR_N_GRP = 3 DCR_VTD_PATH = /dev/ASM/asm-dmvote 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.234.31 DCR_EP_PORT = 11286 [GRP_CSS] DCR_EP_NAME = CSS1 DCR_EP_HOST = 192.168.234.32 DCR_EP_PORT = 11286 [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 = 1024 DCR_EP_HOST = 192.168.234.31 DCR_EP_PORT = 11276 DCR_EP_ASM_LOAD_PATH = /dev/ASM [GRP_ASM] DCR_EP_NAME = ASM1 DCR_EP_SHM_KEY = 93361 DCR_EP_SHM_SIZE = 1024 DCR_EP_HOST = 192.168.234.32 DCR_EP_PORT = 11276 DCR_EP_ASM_LOAD_PATH = /dev/ASM [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 = 5237 DCR_CHECK_PORT = 11256 [GRP_DSC] DCR_EP_NAME = DSC1 DCR_EP_SEQNO = 1 DCR_EP_PORT = 5237 DCR_CHECK_PORT = 11257 EOF

6.3 创建ASM磁盘

在任意一个节点执行

--打开ASM命令行管理 dmasmcmd --创建磁盘 create dcrdisk '/dev/ASM/asm-dmdcr' 'dcr' create votedisk '/dev/ASM/asm-dmvote' 'vote' create asmdisk '/dev/ASM/asm-dmlog' 'LOG0' create asmdisk '/dev/ASM/asm-dmdata' 'DATA0' create asmdisk '/dev/ASM/asm-dmarch' 'ARCH0' init dcrdisk '/dev/ASM/asm-dmdcr' from '/home/dmdba/dmdbms/config/dmdcr_cfg.ini' identified by 'Wei_739867901' init votedisk '/dev/ASM/asm-dmvote' from '/home/dmdba/dmdbms/config/dmdcr_cfg.ini'

6.4 配置dmasvrmal.ini

所有节点的内容一致

cat > /home/dmdba/dmdbms/config/dmasvrmal.ini << EOF [MAL_INST1] MAL_INST_NAME = ASM0 MAL_HOST = 192.168.234.31 MAL_PORT = 11266 [MAL_INST2] MAL_INST_NAME = ASM1 MAL_HOST = 192.168.234.32 MAL_PORT = 11266 EOF

6.5 配置dmdcr.ini

两个节点的配置DMDCR_SEQNO、PATH不同

节点1:

cat > /home/dmdba/dmdbms/config/dmdcr.ini << EOF DMDCR_PATH = /dev/ASM/asm-dmdcr DMDCR_MAL_PATH =/home/dmdba/dmdbms/config/dmasvrmal.ini DMDCR_SEQNO = 0 #DMDCR_ASM_RESTART_INTERVAL = 30 # ASM 重启参数,命令行方式启动 #DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini # 初次搭建环境时,取消该参数,需要手动运行ASM服务,后面搭建无误后,在使该参数生效 #DMDCR_DB_RESTART_INTERVAL = 60 # DB 重启参数,命令行方式启动 #DMDCR_DB_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver PATH=/home/dmdba/dmdbms/dmdata/dsc0_config/dm.ini DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini # 初次搭建环境时,取消该参数,需要手动运行DB服务,后面搭建无误后,在使该参数生效 DMDCR_AUTO_OPEN_CHECK = 30 DMDCR_ASM_TRACE_LEVEL = 2 DMDCR_LINK_CHECK_IP =192.168.234.33 #建议配置心跳网互通第三台IP DMDCR_ASM_MAX_FILE_OPEN=4096 DMDCR_CRASH_CHECK_OPT_COUNT=30 DMDCR_CHECK_CSS_ACTIVE=1 EOF

节点2:

cat > /home/dmdba/dmdbms/config/dmdcr.ini << EOF DMDCR_PATH = /dev/ASM/asm-dmdcr DMDCR_MAL_PATH =/home/dmdba/dmdbms/config/dmasvrmal.ini DMDCR_SEQNO = 1 #DMDCR_ASM_RESTART_INTERVAL = 30 # ASM 重启参数,命令行方式启动 #DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini # 初次搭建环境时,取消该参数,需要手动运行ASM服务,后面搭建无误后,在使该参数生效 #DMDCR_DB_RESTART_INTERVAL = 60 # DB 重启参数,命令行方式启动 #DMDCR_DB_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver PATH=/home/dmdba/dmdbms/dmdata/dsc1_config/dm.ini DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini # 初次搭建环境时,取消该参数,需要手动运行DB服务,后面搭建无误后,在使该参数生效 DMDCR_AUTO_OPEN_CHECK = 30 DMDCR_ASM_TRACE_LEVEL = 2 DMDCR_LINK_CHECK_IP =192.168.234.33 #建议配置心跳网互通第三台IP DMDCR_ASM_MAX_FILE_OPEN=4096 DMDCR_CRASH_CHECK_OPT_COUNT=30 DMDCR_CHECK_CSS_ACTIVE=1 EOF

6.6 手动拉起CSS与ASM服务

所有节点进行,此步骤确认组件能否正常拉起

6.6.1 拉起DMCSS

dmcss DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini

6.6.2 拉起ASM

dmasmsvr DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini

6.7 创建ASM磁盘组

任意一个节点执行即可

-- 启动dmasmtool dmasmtool DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini #创建日志磁盘组 create diskgroup 'DMLOG' asmdisk '/dev/ASM/asm-dmlog' #创建数据磁盘组 create diskgroup 'DMDATA' asmdisk '/dev/ASM/asm-dmdata' #创建归档磁盘组 create diskgroup 'DMARCH' asmdisk '/dev/ASM/asm-dmarch'

6.8 配置dminit.ini

仅在节点1操作

cat > /home/dmdba/dmdbms/config/dminit.ini << EOF 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 = 2048 dcr_path = /dev/ASM/asm-dmdcr dcr_seqno = 0 auto_overwrite = 1 PAGE_SIZE = 32 EXTENT_SIZE = 32 CASE_SENSITIVE = 0 BLANK_PAD_MODE = 1 CHARSET = 1 SYSDBA_PWD = Wei_739867901 SYSAUDITOR_PWD = Wei_739867901 [DSC0] config_path = /home/dmdba/dmdbms/dmdata/dsc0_config port_num = 5237 mal_host = 192.168.234.31 mal_port = 11246 log_path = +DMLOG/log/dsc0_log01.log log_path = +DMLOG/log/dsc0_log02.log [DSC1] config_path = /home/dmdba/dmdbms/dmdata/dsc1_config port_num = 5237 mal_host = 192.168.234.32 mal_port = 11246 log_path = +DMLOG/log/dsc1_log01.log log_path = +DMLOG/log/dsc1_log02.log EOF

6.9 初始化数据库

dminit control=/home/dmdba/dmdbms/config/dminit.ini

6.10 传输配置文件

在节点1初始化后,在配置目录中会生成dsc0、dsc1的配置文件,此时需要降dsc1的配置文件移动到节点2中

--节点2创建目录 mkdir -p /home/dmdba/dmdbms/dmdata/ --从节点1移动配置文件 scp -r /home/dmdba/dmdbms/dmdata/dsc1_config dmdba@192.168.234.32:/home/dmdba/dmdbms/dmdata/

6.11 配置归档

配置文件开启归档

-- 节点1 vi /home/dmdba/dmdbms/dmdata/dsc0_config/dm.ini ARCH_INI = 1 -- 节点2 vi /home/dmdba/dmdbms/dmdata/dsc1_config/dm.ini ARCH_INI = 1

配置归档文件

-- 节点1 cat > /home/dmdba/dmdbms/dmdata/dsc0_config/dmarch.ini << EOF ARCH_LOCAL_SHARE=1 [ARCHIVE_LOCAL1] ARCH_TYPE = LOCAL ARCH_DEST = +DMARCH/DSC0/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 40960 [ARCH_REMOTE1] ARCH_TYPE = REMOTE ARCH_DEST = DSC1 ARCH_INCOMING_PATH =+DMARCH/DSC1/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 40960 EOF -- 节点2 cat > /home/dmdba/dmdbms/dmdata/dsc1_config/dmarch.ini << EOF ARCH_LOCAL_SHARE=1 [ARCHIVE_LOCAL1] ARCH_TYPE = LOCAL ARCH_DEST = +DMARCH/DSC1/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 40960 [ARCH_REMOTE1] ARCH_TYPE = REMOTE ARCH_DEST = DSC0 ARCH_INCOMING_PATH =+DMARCH/DSC0/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 40960 EOF

6.12 启动DMSERVER服务

测试服务是否能正常启动

-- 节点1 dmserver /home/dmdba/dmdbms/dmdata/dsc0_config/dm.ini dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini -- 节点2 dmserver /home/dmdba/dmdbms/dmdata/dsc1_config/dm.ini dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini

6.13 注册服务

前台启动存在风险,如果误触可能直接导致服务关闭,需要配置服务以进行后台启动

cp /home/dmdba/dmdbms/bin/service_template/DmCSSService /home/dmdba/dmdbms/bin/DmCSSService cp /home/dmdba/dmdbms/bin/service_template/DmASMSvrService /home/dmdba/dmdbms/bin/DmASMSvrService cp /home/dmdba/dmdbms/bin/service_template/DmService /home/dmdba/dmdbms/bin/DmService sed -i 's/DCR_INI_PATH=%DCR_INI_PATH%/DCR_INI_PATH=\/home\/dmdba\/dmdbms\/config\/dmdcr.ini/' /home/dmdba/dmdbms/bin/DmCSSService sed -i 's/DCR_INI_PATH=%DCR_INI_PATH%/DCR_INI_PATH=\/home\/dmdba\/dmdbms\/config\/dmdcr.ini/' /home/dmdba/dmdbms/bin/DmASMSvrService sed -i 's/DCR_INI_PATH=%DCR_INI_PATH%/DCR_INI_PATH=\/home\/dmdba\/dmdbms\/config\/dmdcr.ini/' /home/dmdba/dmdbms/bin/DmService -- 节点1 sed -i 's/INI_PATH=%INI_PATH%/INI_PATH=\/home\/dmdba\/dmdbms\/dmdata\/dsc0_config\/dm.ini/' /home/dmdba/dmdbms/bin/DmService -- 节点2 sed -i 's/INI_PATH=%INI_PATH%/INI_PATH=\/home\/dmdba\/dmdbms\/dmdata\/dsc1_config\/dm.ini/' /home/dmdba/dmdbms/bin/DmService

6.14 创建并启动监视器

cat > /home/dmdba/dmdbms/bin/dmcssm.ini << EOF
CSSM_OGUID = 63635
CSSM_CSS_IP = 192.168.234.31:11286
CSSM_CSS_IP = 192.168.234.32:11286
CSSM_LOG_PATH = /home/dmdba/dmdbms/log
CSSM_LOG_FILE_SIZE = 1024
CSSM_LOG_SPACE_LIMIT = 0
EOF

使用以下命令启动监视器

dmcssm ini_path=/home/dmdba/dmdbms/bin/dmcssm.ini

6.15 启动DSC集群

启动前,需要确保手动启动的dmserver、dmasm、dmcss服务正常退出,顺序为先退出dmserver、dmasm、再退出dmcss

-- 先退出dmserver ep stop grp_dsc -- 再退出dmasm ep stop grp_asm -- 最后退出dmcss 执行exit退出两个前台手动启动的css服务 -- setcap授权 setcap cap_net_raw,cap_net_admin=eip /home/dmdba/dmdbms/bin/dmserver setcap cap_net_raw,cap_net_admin=eip /home/dmdba/dmdbms/bin/dmasmsvr getcap /home/dmdba/dmdbms/bin/dmserver getcap /home/dmdba/dmdbms/bin/dmasmsvr -- 检查dmcss dmasm dmserver是否已经全部退出 ps -ef | grep -E "dmcss|dmasmsvr|dmserver" | grep -v grep -- DSC所有节点修改配置文件,取消注释 vi /home/dmdba/dmdbms/config/dmdcr.ini -- 两个节点启动DmCSSService DmCSSService start

7 实时备库部署及配置

7.1 备库搭建

此步骤在192.168.234.33节点执行

7.1.1 初始化实例

-- 初始化备库 dminit path=/dmdata port_num=5237 log_size=2048 page_size=32 db_name=DAMENG instance_name=DSC_DW extent_size=32 CASE_SENSITIVE=0 BLANK_PAD_MODE=1 charset=1 sysdba_pwd=Wei_739867901 sysauditor_pwd=Wei_739867901 --配置服务 cp /home/dmdba/dmdbms/bin/service_template/DmService /home/dmdba/dmdbms/bin/DmService --调整服务配置 sed -i 's/INI_PATH=%INI_PATH%/INI_PATH=\/dmdata\/DAMENG\/dm.ini/' /home/dmdba/dmdbms/bin/DmService

7.1.2 开启归档

vi /dmdata/DAMENG/dm.ini

ARCH_INI = 1

7.1.3 关闭DSC服务和备库

-- 使用dscsm关闭dsc
ep stop grp_dsc

-- 关闭备库
DmService stop

7.1.4 备份DMDSC并在备库还原

使用dmrman在DSC节点进行脱机物理备份

-- 启动dmrman
dmrman use_ap=2 dcr_ini=/home/dmdba/dmdbms/config/dmdcr.ini
-- 执行全库备份
backup database '/home/dmdba/dmdbms/dmdata/dsc0_config/dm.ini' full backupset '/dmdata/dmbak/db_full_bak'
-- 校验备份
check BACKUPSET  '/dmdata/dmbak/db_full_bak'
-- 将备份文件复制至备库
scp -r /dmdata/dmbak/db_full_bak dmdba@192.168.234.33:/dmdata/dmbak/

在备库中还原

--启动dmrman dmrman USE_AP=2 -- 执行恢复 restore database '/dmdata/DAMENG/dm.ini' from backupset '/dmdata/dmbak/db_full_bak' recover database '/dmdata/DAMENG/dm.ini' from backupset '/dmdata/dmbak/db_full_bak' recover database '/dmdata/DAMENG/dm.ini' update db_magic;

7.2 调整配置文件

7.2.1 修改dm.ini

DSC0

vi /home/dmdba/dmdbms/dmdata/dsc0_config/dm.ini
INSTANCE_NAME = DSC0 
PORT_NUM = 5237     #数据库实例监听端口 
DW_INACTIVE_INTERVAL = 60        #接收守护进程消息超时时间 
ALTER_MODE_STATUS = 0       #不允许手工方式修改实例模式/状态 
ENABLE_OFFLINE_TS = 2        #不允许备库 OFFLINE 表空间 
MAL_INI = 1         #打开 MAL 系统 
ARCH_INI = 1           #打开归档配置 
RLOG_SEND_APPLY_MON = 64        #统计最近 64 次的日志发送信息 

DSC1

vi /home/dmdba/dmdbms/dmdata/dsc1_config/dm.ini
INSTANCE_NAME = DSC1
PORT_NUM = 5237     #数据库实例监听端口 
DW_INACTIVE_INTERVAL = 60        #接收守护进程消息超时时间 
ALTER_MODE_STATUS = 0       #不允许手工方式修改实例模式/状态 
ENABLE_OFFLINE_TS = 2        #不允许备库 OFFLINE 表空间 
MAL_INI = 1         #打开 MAL 系统 
ARCH_INI = 1           #打开归档配置 
RLOG_SEND_APPLY_MON = 64        #统计最近 64 次的日志发送信息 

DSC_DW

vi /dmdata/DAMENG/dm.ini
INSTANCE_NAME = DSC_DW
PORT_NUM = 5237     #数据库实例监听端口 
DW_INACTIVE_INTERVAL = 60        #接收守护进程消息超时时间 
ALTER_MODE_STATUS = 0       #不允许手工方式修改实例模式/状态 
ENABLE_OFFLINE_TS = 2        #不允许备库 OFFLINE 表空间 
MAL_INI = 1         #打开 MAL 系统 
ARCH_INI = 1           #打开归档配置 
RLOG_SEND_APPLY_MON = 64        #统计最近 64 次的日志发送信息 

7.2.2 配置dmmal.ini

需要增加备库DSC_DW的配置,三个节点的dmmal.ini配置相同(DSC_DW的dmmal.ini放在数据目录下)

MAL_CHECK_INTERVAL = 87 MAL_CONN_FAIL_INTERVAL =33 [MAL_INST0] MAL_INST_NAME = DSC0 MAL_HOST = 192.168.234.31 MAL_PORT = 11246 MAL_INST_HOST = 192.168.234.31 MAL_INST_PORT = 5237 MAL_DW_PORT = 11296 MAL_INST_DW_PORT = 11306 [MAL_INST1] MAL_INST_NAME = DSC1 MAL_HOST = 192.168.234.32 MAL_PORT = 11246 MAL_INST_HOST = 192.168.234.32 MAL_INST_PORT = 5237 MAL_DW_PORT = 11296 MAL_INST_DW_PORT = 11306 [MAL_INST2] MAL_INST_NAME = DSC_DW MAL_HOST = 192.168.234.33 MAL_PORT = 11246 MAL_INST_HOST = 192.168.234.33 MAL_INST_PORT = 5237 MAL_DW_PORT = 11296 MAL_INST_DW_PORT = 11306

7.2.3 配置dmarch.ini

DSC0

vi /home/dmdba/dmdbms/dmdata/dsc0_config/dmarch.ini ARCH_LOCAL_SHARE=1 [ARCHIVE_LOCAL1] ARCH_TYPE = LOCAL ARCH_DEST = +DMARCH/DSC0/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 40960 [ARCH_REMOTE1] ARCH_TYPE = REMOTE ARCH_DEST = DSC1 ARCH_INCOMING_PATH =+DMARCH/DSC1/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 40960 [ARCHIVE_REALTIME] ARCH_TYPE = REALTIME ARCH_DEST = DSC_DW

DSC1

vi /home/dmdba/dmdbms/dmdata/dsc1_config/dmarch.ini ARCH_LOCAL_SHARE=1 [ARCHIVE_LOCAL1] ARCH_TYPE = LOCAL ARCH_DEST = +DMARCH/DSC1/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 40960 [ARCH_REMOTE1] ARCH_TYPE = REMOTE ARCH_DEST = DSC0 ARCH_INCOMING_PATH =+DMARCH/DSC0/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 40960 [ARCHIVE_REALTIME] ARCH_TYPE = REALTIME ARCH_DEST = DSC_DW

DSC_DW

vi /dmdata/DAMENG/dmarch.ini [ARCHIVE_REALTIME] ARCH_TYPE = REALTIME ARCH_DEST = DSC0/DSC1 [ARCHIVE_LOCAL1] ARCH_TYPE = LOCAL ARCH_DEST = /dmdata/arch ARCH_FILE_SIZE = 1024 ARCH_SPACE_LIMIT = 10240

7.2.4 配置dmwatcher.ini

DSC0

cat > /home/dmdba/dmdbms/config/dmwatcher.ini << EOF [GRP1] DW_TYPE = GLOBAL DW_MODE = MANUAL DW_ERROR_TIME = 120 INST_RECOVER_TIME = 60 INST_ERROR_TIME = 60 INST_INI = /home/dmdba/dmdbms/dmdata/dsc0_config/dm.ini DCR_INI = /home/dmdba/dmdbms/config/dmdcr.ini INST_OGUID = 20261116 INST_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver INST_AUTO_RESTART = 0 RLOG_SEND_THRESHOLD = 0 RLOG_APPLY_THRESHOLD = 0 DW_RECONNECT = 2 EOF

DSC1

cat > /home/dmdba/dmdbms/config/dmwatcher.ini << EOF [GRP1] DW_TYPE = GLOBAL DW_MODE = MANUAL DW_ERROR_TIME = 120 INST_RECOVER_TIME = 60 INST_ERROR_TIME = 60 INST_INI = /home/dmdba/dmdbms/dmdata/dsc1_config/dm.ini DCR_INI = /home/dmdba/dmdbms/config/dmdcr.ini INST_OGUID = 20261116 INST_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver INST_AUTO_RESTART = 0 RLOG_SEND_THRESHOLD = 0 RLOG_APPLY_THRESHOLD = 0 DW_RECONNECT = 2 EOF

DSC_DW

cat > /dmdata/DAMENG/dmwatcher.ini << EOF [GRP1] DW_TYPE = GLOBAL DW_MODE = MANUAL DW_ERROR_TIME = 120 INST_RECOVER_TIME = 60 INST_ERROR_TIME = 60 INST_INI = /dmdata/DAMENG/dm.ini INST_OGUID = 20261116 INST_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver INST_AUTO_RESTART = 0 RLOG_SEND_THRESHOLD = 0 RLOG_APPLY_THRESHOLD = 0 DW_RECONNECT = 2 EOF

7.2.5 配置dmmonitor.ini

在DSC_DW节点配置

cat > /dmdata/DAMENG/dmmonitor.ini << EOF MON_LOG_PATH = /home/dmdba/dmdbms/log MON_LOG_INTERVAL = 60 MON_LOG_FILE_SIZE = 64 MON_LOG_SPACE_LIMIT = 0 MON_DW_CONFIRM = 0 [GRP1] MON_INST_OGUID = 20261116 MON_DW_IP = 192.168.234.31:11296/192.168.234.32:11296 MON_DW_IP = 192.168.234.33:11296 EOF

7.3 启动主备库

7.3.1 以mount方式启动数据库

三个节点都启动

-- DSC0/DSC1 vi /home/dmdba/dmdbms/bin/DmService START_MODE=mount DmService start -- DSC_DW vi /home/dmdba/dmdbms/bin/DmService START_MODE=mount DmService start

7.3.2 设置OGUID并且修改格式

-- DSC0 disql SYSDBA/Wei_739867901@localhost:5237 SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); sp_set_oguid(20261116); alter database primary; SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0); -- DSC_DW disql SYSDBA/Wei_739867901@localhost:5237 SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); sp_set_oguid(20261116); alter database standby; SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

7.3.3 启动守护进程

-- 配置DmWatcherService cp /home/dmdba/dmdbms/bin/service_template/DmWatcherService /home/dmdba/dmdbms/bin/DmWatcherService -- DSC0 和 DSC1 sed -i 's/INI_PATH=%INI_PATH%/INI_PATH=\/home\/dmdba\/dmdbms\/config\/dmwatcher.ini/' /home/dmdba/dmdbms/bin/DmWatcherService -- DSC_DW sed -i 's/INI_PATH=%INI_PATH%/INI_PATH=\/dmdata\/DAMENG\/dmwatcher.ini/' /home/dmdba/dmdbms/bin/DmWatcherService -- 先启动DSC两个节点的守护进程,在启动备库的守护进程 DmWatcherService start

7.3.4 确认数据库状态

disql SYSDBA/Wei_739867901@localhost:5237 select status$ from v$instance;

7.3.5 修改dmdcr.ini

编辑DSC0与DSC1的/home/dmdba/dmdbms/config/dmdcr.ini

取消DMDCR_ASM_RESTART_INTERVAL、DMDCR_ASM_STARTUP_CMD 、DMDCR_DB_RESTART_INTERVAL、DMDCR_DB_STARTUP_CMD的注释

7.4 DMDSC+DW集群

重启集群,使自动拉起ASM、DSC组件

7.4.1 关闭集群

-- 1、关闭DSC_DW节点的守护进程
DmWatcherService stop
-- 2、关闭DSC两个节点的守护进程
DmWatcherService stop
-- 3、关闭DSC两个节点的数据库服务
ep stop grp_dsc
-- 4、关闭DSC_DW的数据库服务
DmService stop
-- 5、关闭DSC两个节点的ASM服务
ep stop grp_asm
-- 6、关闭DSC两个节点的CSS服务
DmCSSService stop

7.4.2 启动集群

在之前dmdcr.ini的配置中,设置了以mount状态启动,待守护进程启动后,会将mount设置为open

-- 1. 启动DMDSC主库两个节点的CSS服务
DmCSSService start 

-- 2.启动实时备库的数据库服务
DmService start

-- 3.启动DMDSC主库两个节点的守护进程
DmWatcherService start

-- 4.启动异步备机的守护进程
DmWatcherService start

7.5 应用配置

cat > /etc/dm_svc.conf << EOF time_zone=(480) language=(cn) dmdsc_dw=(192.168.234.31:5237, 192.168.234.32:5237,192.168.234.33:5237) LOGIN_MODE=(1) EOF
评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服