| 角色 | 主机名 | IP 地址 |
|---|---|---|
| 主库 | dm1 | 192.168.234.31 |
| 备库 | dm2 | 192.168.234.32 |
| 监视器 | dsc_dw | 192.168.234.33 |
| 项目 | 配置 |
|---|---|
| 操作系统 | CentOS 7.9 |
| CPU | Intel Core i9-13900HX,2 核 |
| 内存 | 4 GB |
| 用途 | 路径 |
|---|---|
| 数据根目录 | /dmdata/ |
| 数据库软件目录 | /home/dmdba/dmdbms |
| 归档目录 | /dmdata/arch |
| 备份目录 | /dmdata/dmbak |
本次测试设备限制,使用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
进入虚拟机目录下,编辑虚拟机名.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"
重启虚拟机即可
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"
保存退出后,执行以下命令,使其生效
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-*
至此,虚拟磁盘配置完成
以下系统配置需要在三台主机上按需完成。
查看状态:
systemctl status firewalld
本次实验选择关闭防火墙:
systemctl stop firewalld
systemctl disable firewalld
生产环境应根据实际端口规划配置防火墙规则,不建议直接关闭防火墙。
查看状态:
getenforce
临时切换为宽松模式:
setenforce 0
如需永久禁用,编辑 /etc/selinux/config:
SELINUX=disabled
修改后需重启系统生效。
创建服务文件:
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
查看当前值:
cat /proc/sys/vm/overcommit_memory
本次实验设置为 0:
sysctl -w vm.overcommit_memory=0
如需持久化,在 /etc/sysctl.conf 中增加:
vm.overcommit_memory = 0
应用配置:
sysctl -p
检查当前配置:
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 用户,使配置生效。
本次实验使用 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
在需要部署 DM8 的主机上执行:
groupadd -g 2001 dinstall useradd -u 1001 -g dinstall dmdba passwd dmdba
如果用户或用户组已经存在,请先检查现有配置,不要重复创建。
mkdir -p /dmdata/{arch,dmbak} chown -R dmdba:dinstall /dmdata/{arch,dmbak} chmod -R 755 /dmdata/{arch,dmbak}
三台主机均需安装 DM8 软件。
将安装介质挂载到系统,并确认安装文件可访问。切换至 dmdba 用户,进入安装介质目录执行:
./DMInstall.bin -i
本次安装选项如下:
| 项目 | 选择 |
|---|---|
| 安装语言 | 简体中文 |
| Key 文件 | 未指定,按实验环境选择 |
| 时区 | 中国标准时间(GTM+08:00) |
| 安装类型 | 典型安装 |
| 软件目录 | /home/dmdba/dmdbms |
安装完成后,以 root 用户执行:
/home/dmdba/dmdbms/script/root/root_installer.sh
检查 DMAP 服务:
systemctl status DmAPService
在 /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
该步骤仅在192.168.234.31、192.168.234.32节点操作
su - dmdba
cd /home/dmdba/dmdbms/bin
cp -r dependencies/* ./
配置集群全局信息文件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
在任意一个节点执行
--打开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'
所有节点的内容一致
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
两个节点的配置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
所有节点进行,此步骤确认组件能否正常拉起
dmcss DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini
dmasmsvr DCR_INI=/home/dmdba/dmdbms/config/dmdcr.ini
任意一个节点执行即可
-- 启动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'
仅在节点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
dminit control=/home/dmdba/dmdbms/config/dminit.ini
在节点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/
配置文件开启归档
-- 节点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
测试服务是否能正常启动
-- 节点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
前台启动存在风险,如果误触可能直接导致服务关闭,需要配置服务以进行后台启动
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
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
启动前,需要确保手动启动的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
此步骤在192.168.234.33节点执行
-- 初始化备库
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
vi /dmdata/DAMENG/dm.ini
ARCH_INI = 1
-- 使用dscsm关闭dsc
ep stop grp_dsc
-- 关闭备库
DmService stop
使用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;
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 次的日志发送信息
需要增加备库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
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
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
在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
三个节点都启动
-- 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
-- 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);
-- 配置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
disql SYSDBA/Wei_739867901@localhost:5237
select status$ from v$instance;
编辑DSC0与DSC1的/home/dmdba/dmdbms/config/dmdcr.ini
取消DMDCR_ASM_RESTART_INTERVAL、DMDCR_ASM_STARTUP_CMD 、DMDCR_DB_RESTART_INTERVAL、DMDCR_DB_STARTUP_CMD的注释
重启集群,使自动拉起ASM、DSC组件
-- 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
在之前dmdcr.ini的配置中,设置了以mount状态启动,待守护进程启动后,会将mount设置为open
-- 1. 启动DMDSC主库两个节点的CSS服务
DmCSSService start
-- 2.启动实时备库的数据库服务
DmService start
-- 3.启动DMDSC主库两个节点的守护进程
DmWatcherService start
-- 4.启动异步备机的守护进程
DmWatcherService start
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
文章
阅读量
获赞
