dmdsc集群安装

Asian 2024-06-21

一、共享盘配置

1.创建共享盘

cd /d D:\vmware

vmware-vdiskmanager.exe -c -s 10Gb -a lsilogic -t 2 "D:\vmwaremachine\sharedisk\VOTE.vmdk"

vmware-vdiskmanager.exe -c -s 10Gb -a lsilogic -t 2 "D:\vmwaremachine\sharedisk\DCR.vmdk"

vmware-vdiskmanager.exe -c -s 20Gb -a lsilogic -t 2 "D:\vmwaremachine\sharedisk\DATA.vmdk"

vmware-vdiskmanager.exe -c -s 20Gb -a lsilogic -t 2 "D:\vmwaremachine\sharedisk\ARCH.vmdk"

vmware-vdiskmanager.exe -c -s 20Gb -a lsilogic -t 2 "D:\vmwaremachine\sharedisk\LOG.vmdk"

2.在虚拟机配置文件下新增如下参数，使得功能盘的uuid能够显示出来，如不加一下参数，两台机器将会无法同时启动

disk.locking="FALSE"

disk.EnableUUID ="TRUE"

3.目录管理

本地磁盘挂载在/home目录下，并配置好自动挂载

mkfs.xfs /dev/vdb

lsblk -f

vim /etc/fstab

4.创建用户和用户组

groupadd -g 2001 dinstall

useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba

passwd dmdba

JTh93*#K

5.udev绑定

5.1查看共享盘对应的uuid

/usr/lib/udev/scsi_id -g -u -d /dev/sdb

/usr/lib/udev/scsi_id -g -u -d /dev/sdc

/usr/lib/udev/scsi_id -g -u -d /dev/sdd

/usr/lib/udev/scsi_id -g -u -d /dev/sde

/usr/lib/udev/scsi_id -g -u -d /dev/sdf

节点1

[root@dsc01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdb

36000c2980127e77bae8ba0de08adee42

[root@dsc01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc

36000c29883e54562deaa754700be01cc

[root@dsc01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdd

36000c2940e5e2d17b3b9772f041459fc

[root@dsc01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sde

36000c29bfd8289007f5551f5aa21c3f6

[root@dsc01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdf

36000c29b3a9cbe0442c91a1bb4f3ee57

节点2

[root@dsc02 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdb

36000c2980127e77bae8ba0de08adee42

[root@dsc02 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc

36000c29883e54562deaa754700be01cc

[root@dsc02 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdd

36000c29bfd8289007f5551f5aa21c3f6

[root@dsc02 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sde

36000c2940e5e2d17b3b9772f041459fc

[root@dsc02 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdf

36000c29b3a9cbe0442c91a1bb4f3ee57

5.2生成udev规则文件

for i in b c d e f ;

echo "KERNEL==\"sd?\",SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\",RESULT==\"`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", SYMLINK+=\"asm-disk$i\",OWNER=\"dmdba\", GROUP=\"dinstall\",MODE=\"0660\""

done

vi /etc/udev/rules.d/66-dmdevices.rules

KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c2980127e77bae8ba0de08adee42", SYMLINK+="DM_DATA",OWNER="dmdba", GROUP="dinstall",MODE="0660"

KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29883e54562deaa754700be01cc", SYMLINK+="DM_ARCH",OWNER="dmdba", GROUP="dinstall",MODE="0660"

KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c2940e5e2d17b3b9772f041459fc", SYMLINK+="DM_DCR",OWNER="dmdba", GROUP="dinstall",MODE="0660"

KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29bfd8289007f5551f5aa21c3f6", SYMLINK+="DM_LOG",OWNER="dmdba", GROUP="dinstall",MODE="0660"

KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29b3a9cbe0442c91a1bb4f3ee57", SYMLINK+="DM_VOTE",OWNER="dmdba", GROUP="dinstall",MODE="0660"

5.3加载UDEV规则

/sbin/udevadm control --reload

/sbin/udevadm trigger --type=devices --action=change

或

systemctl restart systemd-udev-trigger

5.4查看udev规则是否绑定成功

[root@dsc01 dev]# ls -lL /dev/DM_*

brw-rw---- 1 dmdba dinstall 8, 80 6月 4 15:12 /dev/DM_ARCH

brw-rw---- 1 dmdba dinstall 8, 64 6月 4 15:12 /dev/DM_DATA

brw-rw---- 1 dmdba dinstall 8, 16 6月 4 15:12 /dev/DM_DCR

brw-rw---- 1 dmdba dinstall 8, 48 6月 4 15:12 /dev/DM_LOG

brw-rw---- 1 dmdba dinstall 8, 32 6月 4 15:12 /dev/DM_VOTE

6.创建软链接，防止机器上有多个集群导致css无法识别共享盘

mkdir /dev_DMDATA/

chown dmdba:dinstall /dev_DMDATA/

dmdba用户执行

ln -s /dev/DM_ARCH /dev_DMDATA/DM_ARCH

ln -s /dev/DM_DATA /dev_DMDATA/DM_DATA

ln -s /dev/DM_DCR /dev_DMDATA/DM_DCR

ln -s /dev/DM_LOG /dev_DMDATA/DM_LOG

ln -s /dev/DM_VOTE /dev_DMDATA/DM_VOTE

删除软链接

unlink /dev_DMDATA/DM_ARCH

unlink /dev_DMDATA/DM_DATA

unlink /dev_DMDATA/DM_DCR

unlink /dev_DMDATA/DM_LOG

unlink /dev_DMDATA/DM_VOTE

查看创建软链接是否成功

[dmdba@dsc02 ~]$ ls -lth /dev_DMDATA/

总用量 0

lrwxrwxrwx 1 dmdba dinstall 12 6月 4 15:22 DM_VOTE -> /dev/DM_VOTE

lrwxrwxrwx 1 dmdba dinstall 11 6月 4 15:22 DM_LOG -> /dev/DM_LOG

lrwxrwxrwx 1 dmdba dinstall 11 6月 4 15:22 DM_DCR -> /dev/DM_DCR

lrwxrwxrwx 1 dmdba dinstall 12 6月 4 15:22 DM_DATA -> /dev/DM_DATA

lrwxrwxrwx 1 dmdba dinstall 12 6月 4 15:22 DM_ARCH -> /dev/DM_ARCH

二、部署DSC集群

1.安装数据库软件

1.1查看防火墙环境

systemctl status firewalld

systemctl stop firewalld

systemctl disable firewalld

--查看Selinux状态。

getenforce

--临时关闭selinux服务

setenforce 0

--永久关闭selinux服务。

sed -i '/^SELINUX=/cSELINUX=disabled' /etc/selinux/config

--或者vim编辑/etc/selinux/config，修改SELINUX=disabled。

1.2操作系统资源限制检查

vi /etc/security/limits.conf

添加如下内容：

dmdba soft fsize unlimited

dmdba hard fsize unlimited

dmdba soft nproc 131072

dmdba hard nproc 131072

dmdba soft nofile 131072

dmdba hard nofile 131072

dmdba soft core unlimited

dmdba hard core unlimited

dmdba soft data unlimited

dmdba hard data unlimited

1.3操作系统内存参数检查

vi /etc/sysctl.conf

vm.overcommit_memory=0

sysctl -p

1.4检查numa是否关闭

dmesg | grep -i numa

编辑vim /etc/default/grub，在在GRUB_CMDLINE_LINUX一栏添加numa=off；

1.5创建软件包挂载目录

mkdir -p /data/iso

chown dmdba:dinstall /data/iso/

mkdir -p /data/install_tmp

chmod 755 /data/install_tmp

chown -R dmdba:dinstall /data/install_tmp

mount -o loop dm8_20240426_x86_kylin10_64.iso /data/iso

1.6设置环境变量（dmdba用户）

export PATH

export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/home/dmdba/dmdbms/bin"

export DM_HOME="/home/dmdba/dmdbms"

export PATH=$PATH:$DM_HOME/bin

export MALLOC_ARENA_MAX=1

DM_INSTALL_TMPDIR=/data/install_tmp

export DM_INSTALL_TMPDIR

export LANG=zh_CN.UTF-8

1.7安装

su - dmdba

cd /data/iso

./DMInstall.bin -i

安装路径：/home/dmdba/dmdbms

2.搭建基于ASM的共享存储集群

2.1创建用于存储配置文件的目录

在任意一个节点中：

mkdir -p /home/dmdba/dmdsc/dsc01

mkdir -p /home/dmdba/dmcssm/log

2.2创建用于格式化dcr和vote的配置文件dmdcr_cfg.ini

cd /home/dmdba/dmdsc/dsc01/

vi dmdcr_cfg.ini

DCR_N_GRP = 3 #集群环境配置了1个DMCSS集群、1个DMASM集群、1个DMDSC集群，则DCR_N_GRP=3

DCR_VTD_PATH = /dev_DMDATA/DM_VOTE #VOTE DISK路径

DCR_OGUID = 63623 #消息表示，DMCSSM登录DMCSS消息校验用

[GRP]

DCR_GRP_TYPE = CSS

DCR_GRP_NAME = GRP_CSS

DCR_GRP_N_EP = 2

DCR_GRP_DSKCHK_CNT = 10

[GRP_CSS]

DCR_EP_NAME = CSS0

DCR_EP_HOST = 192.168.6.131

DCR_EP_PORT = 9341

[GRP_CSS]

DCR_EP_NAME = CSS1

DCR_EP_HOST = 192.168.6.132

DCR_EP_PORT = 9343

[GRP]

DCR_GRP_TYPE = ASM

DCR_GRP_NAME = GRP_ASM

DCR_GRP_N_EP = 2

DCR_GRP_DSKCHK_CNT = 10

[GRP_ASM]

DCR_EP_NAME = ASM0

DCR_EP_SHM_KEY = 93360

DCR_EP_SHM_SIZE = 100

DCR_EP_HOST = 192.168.6.131

DCR_EP_PORT = 9349

DCR_EP_ASM_LOAD_PATH = /dev_DMDATA

[GRP_ASM]

DCR_EP_NAME = ASM1

DCR_EP_SHM_KEY = 93361

DCR_EP_SHM_SIZE = 100

DCR_EP_HOST = 192.168.6.132

DCR_EP_PORT = 9351

DCR_EP_ASM_LOAD_PATH = /dev_DMDATA

[GRP]

DCR_GRP_TYPE = DB

DCR_GRP_NAME = GRP_DSC

DCR_GRP_N_EP = 2

DCR_GRP_DSKCHK_CNT = 10

[GRP_DSC]

DCR_EP_NAME = DSC01

DCR_EP_SEQNO = 0

DCR_EP_PORT = 10038

DCR_CHECK_PORT = 9741

[GRP_DSC]

DCR_EP_NAME = DSC02

DCR_EP_SEQNO = 1

DCR_EP_PORT = 10038

DCR_CHECK_PORT = 9742

2.3使用dmasmcmd工具初始化磁盘

./dmasmcmd 依次输入以下命令：

create dcrdisk '/dev_DMDATA/DM_DCR' 'dcr'

create votedisk '/dev_DMDATA/DM_VOTE' 'vote'

create asmdisk '/dev_DMDATA/DM_LOG' 'LOG0'

create asmdisk '/dev_DMDATA/DM_DATA' 'DATA0'

create asmdisk '/dev_DMDATA/DM_ARCH' 'ARCH0'

create asmdisk '/dev_DMDATA/DM_BAK' 'BAK0'

init dcrdisk '/dev_DMDATA/DM_DCR' from '/home/dmdba/dmdsc/dsc01/dmdcr_cfg.ini' identified by 'SYSDBA'

init votedisk '/dev_DMDATA/DM_VOTE' from '/home/dmdba/dmdsc/dsc01/dmdcr_cfg.ini'

2.4创建dmasm的mal配置文件dmasvrmal.ini，两个节点都需要配置此文件

vi /home/dmdba/dmdsc/dsc01/dmasvrmal.ini

vi /home/dmdba/dmdsc/dsc02/dmasvrmal.ini

[MAL_INST1]

MAL_INST_NAME = ASM0

MAL_HOST = 192.168.6.131

MAL_PORT = 7236

[MAL_INST2]

MAL_INST_NAME = ASM1

MAL_HOST = 192.168.6.132

MAL_PORT = 7237

2.5双节点分别配置dmdcr.ini文件，用于DMCSS、DMASMSVR、DMASMTOOL等工具的输入参数

节点1：

vi /home/dmdba/dmdsc/dsc01/dmdcr.ini

DMDCR_PATH = /dev_DMDATA/DM_DCR

#dmasmsvr使用的MAL配置文件路径

DMDCR_MAL_PATH = /home/dmdba/dmdsc/dsc01/dmasvrmal.ini

DMDCR_SEQNO = 0 #记录当前节点号

#ASM重启参数，命令行方式启动

DMDCR_ASM_RESTART_INTERVAL = 0 #先设置为0，不自动拉起本地ASM实例

DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdsc/dsc01/dmdcr.ini

#DB重启参数，命令行方式启动

DMDCR_DB_RESTART_INTERVAL = 0 #先设置为0，不自动拉起本地实例

DMDCR_DB_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdsc/dsc01/dsc01_config/dm.ini dcr_ini=/home/dmdba/dmdsc/dsc01/dmdcr.ini

节点2：

vi /home/dmdba/dmdsc/dsc02/dmdcr.ini

DMDCR_PATH = /dev_DMDATA/DM_DCR

#dmasmsvr使用的MAL配置文件路径

DMDCR_MAL_PATH = /home/dmdba/dmdsc/dsc02/dmasvrmal.ini

DMDCR_SEQNO = 1 #记录当前节点号

#ASM重启参数，命令行方式启动

DMDCR_ASM_RESTART_INTERVAL = 0 #先设置为0，不自动拉起本地ASM实例

DMDCR_ASM_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmasmsvr dcr_ini=/home/dmdba/dmdsc/dsc02/dmdcr.ini

#DB重启参数，命令行方式启动

DMDCR_DB_RESTART_INTERVAL = 0 #先设置为0，不自动拉起本地实例

DMDCR_DB_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver path=/home/dmdba/dmdsc/dsc02/dsc02_conf/dm.ini dcr_ini=/home/dmdba/dmdsc/dsc02/dmdcr.ini

2.6启动DMCSS、DMASM服务程序

两个节点先后分别启动dmcss、dmasmsvr程序

./dmcss dcr_ini=/home/dmdba/dmdsc/dsc01/dmdcr.ini

./dmasmsvr dcr_ini=/home/dmdba/dmdsc/dsc01/dmdcr.ini

./dmcss dcr_ini=/home/dmdba/dmdsc/dsc02/dmdcr.ini

./dmasmsvr dcr_ini=/home/dmdba/dmdsc/dsc02/dmdcr.ini

2.7使用dmasmtool工具创建DMASM磁盘组，任意一节点中操作

节点1：

./dmasmtool dcr_ini=/home/dmdba/dmdsc/dsc01/dmdcr.ini

create diskgroup 'DMLOG' asmdisk '/dev_DMDATA/DM_LOG'

create diskgroup 'DMDATA' asmdisk '/dev_DMDATA/DM_DATA'

create diskgroup 'DMARCH' asmdisk '/dev_DMDATA/DM_ARCH'

create diskgroup 'DMBAK' asmdisk '/dev_DMDATA/DM_BAK'

2.8创建用于初始化数据库实例的控制文件dminit.ini

节点1上：

vi /home/dmdba/dmdsc/dsc01/dminit.ini

db_name = dsc

system_path = +DMDATA/data

system = +DMDATA/data/dsc/system.dbf

system_size = 128

roll = +DMDATA/data/dsc/roll.dbf

roll_size = 1024

main = +DMDATA/data/dsc/main.dbf

main_size = 1024

ctl_path = +DMDATA/data/dsc/dm.ctl

ctl_size = 8

log_size = 2048

page_size = 32 #默认页大小8k

charset = 0 #0代表GB18030，1代表UTF-8，2代表韩文字符集 EUC-KR。默认为0

case_sensitive= 1

length_in_char= 0

blank_pad_mode= 0

dcr_path = /dev_DMDATA/DM_DCR #dcr磁盘路径，目前不支持asm，只能是裸设备

dcr_seqno = 0

auto_overwrite = 1

[dsc01] #inst_name跟dmdcr_cfg.ini中DB类型group中DCR_EP_NAME对应

config_path = /home/dmdba/dmdsc/dsc01/dsc01_conf

port_num = 10038

mal_host = 192.168.6.131

mal_port = 9340

log_path = +DMLOG/log/dsc01_log01.log

log_path = +DMLOG/log/dsc01_log02.log

[dsc02]

config_path = /home/dmdba/dmdsc/dsc02/dsc02_conf

port_num = 10038

mal_host = 192.168.6.132

mal_port = 9341

log_path = +DMLOG/log/dsc02_log01.log

log_path = +DMLOG/log/dsc02_log02.log

2.9使用dminit初始化DB环境

节点1上执行dminit完成后，会在/home/dmdba/dmdsc/dsc01/dsc01_conf和/home/dmdba/dmdsc/dsc02/dsc02_conf目录下生成各节点的dm.ini和dmmal.ini等配置文件

./dminit control=/home/dmdba/dmdsc/dsc01/dminit.ini

2.10将节点1上/home/dmdba/dmdsc/dsc02/* 拷贝到节点2对应目录下

scp -r /home/dmdba/dmdsc/dsc02/* dmdba@192.168.6.132:/home/dmdba/dmdsc/dsc02/

2.11启动数据库服务器

双节点分别启动dmserver

./dmserver /home/dmdba/dmdsc/dsc01/dsc01_conf/dm.ini dcr_ini=/home/dmdba/dmdsc/dsc01/dmdcr.ini

./dmserver /home/dmdba/dmdsc/dsc02/dsc02_conf/dm.ini dcr_ini=/home/dmdba/dmdsc/dsc02/dmdcr.ini

2.12配置DMCSSM监视器

建议是放在独立的第三方服务器上

vim /home/dmdba/dmcssm/dmcssm.ini

#和 DMDCR_CFG.INI 中的 DCR_OGUID 保持一致

CSSM_OGUID = 63623

#配置所有 CSS 的连接信息，

#与 DMDCR_CFG.INI 中 CSS 配置项的 DCR_EP_HOST 和 DCR_EP_PORT 保持一致

CSSM_CSS_IP = 172.17.50.57:9341

CSSM_CSS_IP = 172.17.50.138:9343

CSSM_LOG_PATH = /home/dmdba/dmcssm/log #监视器日志文件存放路径

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

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

启动监视器： ./dmcssm ini_path=/home/dmdba/dmcssm/dmcssm.ini

2.13注册服务，双节点上都注册服务

节点1上：

#注册dmcss服务，root用户下

./dm_service_installer.sh -t dmcss -dcr_ini /home/dmdba/dmdsc/dsc01/dmdcr.ini -p CSS0

#注册dmasmsvr服务

./dm_service_installer.sh -t dmasmsvr -dcr_ini /home/dmdba/dmdsc/dsc01/dmdcr.ini -p ASM0 -y DmCSSServiceCSS0

#注册dmserver服务

./dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dmdsc/dsc01/dsc01_conf/dm.ini -dcr_ini /home/dmdba/dmdsc/dsc01/dmdcr.ini -p DM01 -y DmASMSvrServiceASM0

节点2上：

#注册dmcss服务，root用户下

./dm_service_installer.sh -t dmcss -dcr_ini /home/dmdba/dmdsc/dsc02/dmdcr.ini -p CSS1

#注册dmasmsvr服务

./dm_service_installer.sh -t dmasmsvr -dcr_ini /home/dmdba/dmdsc/dsc02/dmdcr.ini -p ASM1 -y DmCSSServiceCSS1

#注册dmserver服务

./dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dmdsc/dsc02/dsc02_conf/dm.ini -dcr_ini /home/dmdba/dmdsc/dsc02/dmdcr.ini -p DM02 -y DmASMSvrServiceASM1

2.14根据需求关闭服务自启

systemctl disable DmCSSServiceCSS0

systemctl disable DmASMSvrServiceASM0

systemcyl disable DmServiceDM01

systemctl disable DmCSSServiceCSS1

systemctl disable DmASMSvrServiceASM1

systemctl disable DmServiceDM02

3.数据库参数调整

双节点执行优化脚本的调优结果

4.备份策略

5.开启归档

开启归档前需要登录asmtool创建归档所需目录，然后双节点配置dmarch.ini文件

节点1：

vim /home/dmdba/dmdsc/dsc01/dsc01_conf/dmarch.ini

ARCH_WAIT_APPLY = 0

ARCH_LOCAL_SHARE = 1

ARCH_LOCAL_SHARE_CHECK=0

[ARCHIVE_LOCAL1]

ARCH_TYPE = LOCAL

ARCH_DEST = +DMARCH/ARCH/DSC01/arch

ARCH_FILE_SIZE = 2048

ARCH_SPACE_LIMIT = 102400

[ARCHIVE_REMOTE1]

ARCH_TYPE = REMOTE

ARCH_DEST = DSC02

ARCH_INCOMING_PATH = +DMARCH/ARCH/DSC02/arch

ARCH_FILE_SIZE = 2048

ARCH_SPACE_LIMIT = 102400

节点2：

vim /home/dmdba/dmdsc/dsc02/dsc02_conf/dmarch.ini

ARCH_WAIT_APPLY = 0

ARCH_LOCAL_SHARE = 1

ARCH_LOCAL_SHARE_CHECK=0

[ARCHIVE_LOCAL1]

ARCH_TYPE = LOCAL

ARCH_DEST = +DMARCH/ARCH/DSC02/arch

ARCH_FILE_SIZE = 2048

ARCH_SPACE_LIMIT = 102400

[ARCHIVE_REMOTE1]

ARCH_TYPE = REMOTE

ARCH_DEST = DSC01

ARCH_INCOMING_PATH = +DMARCH/ARCH/DSC01/arch

ARCH_FILE_SIZE = 2048

ARCH_SPACE_LIMIT = 102400

6.配置备份作业

全量备份 +DMBAK/dmbak/full_bak 每周日晚02:00执行全量备份压缩+并行

增量备份 +DMBAK/dmbak/incr_bak 每周一至每周六晚02:00执行差异增量备份压缩+并行

##登录asmtool后创建备份所需目录

./dmasmtool dcr_ini=/home/dmdba/dmdsc/dsc01/dmdcr.ini

ASM>cd DMBAK

ASM>mkdir dmbak/full_bak

ASM>mkdir dmbak/incr_bak

#节点1执行备份作业

call SP_INIT_JOB_SYS(1);

call SP_CREATE_JOB('full_bak',1,0,'',0,0,'',0,'');

call SP_JOB_CONFIG_START('full_bak');

call SP_ADD_JOB_STEP('full_bak', 'fbak', 6, '01020000+DMBAK/dmbak/full_bak', 1, 2, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('full_bak', 'meizhou', 1, 2, 1, 1, 0, '23:00:00', NULL, '2020-07-08 11:39:58', NULL, '');

call SP_JOB_CONFIG_COMMIT('full_bak');

call SP_CREATE_JOB('incre_bak',1,0,'',0,0,'',0,'');

call SP_JOB_CONFIG_START('incre_bak');

call SP_ADD_JOB_STEP('incre_bak', 'incre_bak', 6, '11020000+DMBAK/dmbak/full_bak|+DMBAK/dmbak/incr_bak', 1, 2, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('incre_bak', 'tian', 1, 2, 1, 126, 0, '02:00:00', NULL, '2022-10-26 11:39:58', NULL, '');

call SP_JOB_CONFIG_COMMIT('incre_bak');

call SP_CREATE_JOB('bak_clear',1,0,'',0,0,'',0,'每天删除30天前的备份');

call SP_JOB_CONFIG_START('bak_clear');

call SP_ADD_JOB_STEP('bak_clear', 'del_bak', 0, 'SF_BAKSET_BACKUP_DIR_ADD(''DISK'',''+DMBAK/dmbak/full_bak'');SF_BAKSET_BACKUP_DIR_ADD(''DISK'',''+DMBAK/dmbak/incr_bak''); CALL SP_DB_BAKSET_REMOVE_BATCH(''DISK'',SYSDATE-30);', 1, 2, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('bak_clear', 'diaodu_del', 1, 1, 1, 0, 0, '03:00:00', NULL, '2020-06-25 22:54:03', NULL, '');

call SP_JOB_CONFIG_COMMIT('bak_clear');

7.配置dm_svc.conf文件

GRP1=(10.236.245.36:5236,10.236.245.37:5236)

[GRP1]

LOGIN_MODE=(1)

SWITCH_TIME=(3)

SWITCH_INTERVAL=(2000)

墨力计划

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

dmdsc集群安装

评论