DM数据库学习之路(十四）DM8DSC(DMASM)共享存储集群部署

本文链接：https://blog.csdn.net/weixin_44460848/article/details/136211110

DM8DSC环境准备
1. DM8DSC规划
  1. 主机规划

主机名	内存	业务IP/私网IP	操作系统
dm8db01	16G	84.0.191.10	Kylin-Server-V10-SP3
dm8db02	16G	84.0.191.11	Kylin-Server-V10-SP3
dm8db01_priv		10.10.10.10
dm8db02_priv		10.10.10.11

1. 1. 磁盘规划

名称	机器 A（dm8db01）	机器 B（dm8db02）	备注
安装目录	/dm/dmdbms	/dm/dmdbms	数据库安装路径，存放数据库运行日志等信息
备份目录	/dm/dmbak	/dm/dmbak	用于存放数据库备份文件
SQL日志目录	/dm/dmsqllog	/dm/dmsqllog	用于存放数据库 dmsql 日志
集群配置文件目录	/dm/dmdbms/dsc_config	/dm/dmdbms/dsc_config	用于存放数据库集群配置文件
系统 core 目录	/dm/core	/dm/core	用户存放系统的 core 文件

1. 1. 共享存储规划

DMDSC 集群为了实现多实例同时访问和修改数据，需要数据文件、控制文件和日志文件都放到共享存储上。DM支持两种共享存储，裸设备和DMASM，裸设备是未经过格式化的特殊字符设备，推荐使用DMASM共享存储。

其中，VOTE 是表决磁盘，一个集群一个表决磁盘。DCR是DM集群注册表的简称，用于存储、维护集群配置的详细信息，一个集群一个注册表。生产环境中，共享存储一般由操作系统管理员进行划分。

共享存储规划可参照下表：

(以下为测试环境共享存储规划，便于在操作系统层面区分每个盘大小)

名称	磁盘别名	LUN大小	备注
VOTE 磁盘	/dev/dm/asm-dmvote	2GB	记录集群成员信息，集群通过 Voting Disk 进行心跳检测，确定集群中节点的状态
DCR 盘	/dev/dm/asm-dmdcr	3GB	用于存储、维护集群配置的详细信息，整个集群环境共享 DCR 配置信息
Redo 日志盘	/dev/dm/asm-dmlog	4GB	用于存储数据库集群 Redo log
数据盘	/dev/dm/asm-dmdata*	20GB	用户存放数据
归档盘	/dev/dm/asm-dmarch	10GB	用于存储数据库集群各实例的归档日志

1. 1. 端口规划

数据库服务器名称		dm8db01	dm8db02
业务服务名		[db8_service_name]
业务 IP		84.0.191.10	84.0.191.11
内部数据交换网络 IP		10.10.10.10	10.10.10.11
dmdcr_cfg	CSS	DCR_EP_NAME	CSS0	CSS1
		DCR_EP_HOST	10.10.10.10	10.10.10.11
		DCR_EP_PORT	11286	11286
	ASM	DCR_EP_NAME	ASM0	ASM1
		DCR_EP_HOST	10.10.10.10	10.10.10.11
		DCR_EP_PORT	11276	11277
	DB	DCR_EP_NAME	DSC0	DSC1
		DCR_EP_PORT	5237	5237
		DCR_CHECK_PORT	11256	11257
dmasvrmal		MAL_INST_NAME	ASM0	ASM1
		MAL_HOST	10.10.10.10	10.10.10.11
		MAL_PORT	11266	11266
dminit		实例名	DSC0	DSC1
		PORT_NUM	5237	5237
		MAL_HOST	10.10.10.10	10.10.10.11
		MAL_PORT	11246	11246
OGUID		210715

1. DM8DSC准备工作
  1. hosts配置

# vi /etc/hosts

84.0.191.10 dm8db01

84.0.191.11 dm8db02

10.10.10.10 dm8db01priv

10.10.10.11 dm8db02priv

1. 1. 关闭防火墙

systemctl stop firewalld

systemctl disable firewalld

sed -i '/^SELINUX=.*/ s//SELINUX=disabled/' /etc/selinux/config

setenforce 0

1. 1. sysctl.conf参数配置

# vi /etc/systemd/system.conf

DefaultLimitNOFILE=65536

DefaultLimitNPROC=10240

1. 1. limits.conf参数配置

# vi /etc/security/limits.conf

##在最后面添加以下内容

dmdba soft nproc 10240

dmdba hard nproc 10240

dmdba soft nofile 65536

dmdba hard nofile 65536

dmdba hard stack 32768

dmdba soft stack 16384

dmdba hard data unlimited

dmdba soft data unlimited

dmdba hard fsize unlimited

dmdba soft fsize unlimited

dmdba soft core unlimited

dmdba hard core unlimited

1. 1. nproc.conf参数配置

soft 表示软限制，hard 表示硬限制，nproc 进程数，nofile 文件数。

# vi /etc/security/limits.d/nproc.conf

dmdba soft nproc 65536

dmdba hard nproc 65536

1. 1. 建安装用户

groupadd dinstall

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

passwd dmdba

mkdir -p /dm/dmdbms

chmod 755 -R /dm

1. 1. 环境变量配置

su - dmdba

vi ~/.bash_profile

export DM_HOME=/dm8/dmdbms

export PATH=$DM_HOME/bin:$PATH:$DM_HOME/tool:$PATH:HOME/bin:/usr/local/bin

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$DM_HOME/bin

source ~/.bash_profile

1. DM8DSC添加共享磁盘
  1. 虚拟机添加共享磁盘

磁盘	大小	路径
DMVOTE	2G	sdb	/dev/dm/asm-dmvote
DMDCR	3G	sdc	/dev/dm/asm-dmdcr
DMLOG	4G	sdd	/dev/dm/asm-dmlog
DMDATA	40G	sde	/dev/dm/asm-dmdata
DMARCH	10G	sdf	/dev/dm/asm-dmarch

注：便于实验，每个盘做了单独区分

使用VM工具创建

"C:\Program Files (x86)\VMware\VMware Workstation\vmware-vdiskmanager.exe" -c -s 2GB -a lsilogic -t 2 "D:\vmware\Kylin_DM\DM8_RAC_Kylin\DM8_RAC1\VOTO-2G.vmdk"

"C:\Program Files (x86)\VMware\VMware Workstation\vmware-vdiskmanager.exe" -c -s 3GB -a lsilogic -t 2 "D:\vmware\Kylin_DM\DM8_RAC_Kylin\DM8_RAC1\DCR-3G.vmdk"

"C:\Program Files (x86)\VMware\VMware Workstation\vmware-vdiskmanager.exe" -c -s 4GB -a lsilogic -t 2 "D:\vmware\Kylin_DM\DM8_RAC_Kylin\DM8_RAC1\LOG-4G.vmdk"

"C:\Program Files (x86)\VMware\VMware Workstation\vmware-vdiskmanager.exe" -c -s 20GB -a lsilogic -t 2 "D:\vmware\Kylin_DM\DM8_RAC_Kylin\DM8_RAC1\DATA-20G.vmdk"

"C:\Program Files (x86)\VMware\VMware Workstation\vmware-vdiskmanager.exe" -c -s 10GB -a lsilogic -t 2 "D:\vmware\Kylin_DM\DM8_RAC_Kylin\DM8_RAC1\ARCH-10G.vmdk"

添加磁盘—使用现在磁盘

disk.EnableUUID = "TRUE"

disk.locking = "FALSE"

注意：

如果不添加，重启虚拟机操作系统时会提示磁盘被锁定

1. 1. 查询块设备 UUID

# lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT

sda 8:0 0 60G 0 disk

├─sda1 8:1 0 300M 0 part /boot

└─sda2 8:2 0 59.7G 0 part

├─klas-root 253:0 0 51.7G 0 lvm /

└─klas-swap 253:1 0 8G 0 lvm [SWAP]

sdb 8:16 0 2G 0 disk

sdc 8:32 0 3G 0 disk

sdd 8:48 0 4G 0 disk

sde 8:64 0 20G 0 disk

sdf 8:80 0 10G 0 disk

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

36000c2949464c72aaa61b860e1ddb55b

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

36000c2937554aba6b5faf2c80d7b8ef7

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

36000c295e9f5f5c22c07f4a32b5f1dd4

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

36000c293a9214223b00c0e784a82e6ac

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

36000c29c8b1575dd8192e4bcafca6db7

1. 1. 块设备UUID绑定
    1. 编辑88-dm-asmdevices.rules

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=="36000c2949464c72aaa61b860e1ddb55b",SYMLINK+="dm/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=="36000c2937554aba6b5faf2c80d7b8ef7",SYMLINK+="dm/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=="36000c295e9f5f5c22c07f4a32b5f1dd4",SYMLINK+="dm/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=="36000c293a9214223b00c0e784a82e6ac",SYMLINK+="dm/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=="36000c29c8b1575dd8192e4bcafca6db7",SYMLINK+="dm/asm-dmarch",OWNER="dmdba",GROUP="dinstall",MODE="0660"

1. 1. 1. 将配置文件拷贝到其它节点

将修改完的 88-dm-asmdevices.rules 配置文件 cp 到 DSC 的每个节点上。

scp 88-dm-asmdevices.rules 84.0.191.11:/etc/udev/rules.d/

1. 1. 1. 重启udev服务

/sbin/udevadm control --reload-rules #（重新加载udev服务）

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

1. 1. 1. 路径授权（此文件防止重启属组权限失效）

#vi /etc/udev/rules.d/99-dm-permissons.rules

PROGRAM="/bin/chown -R dmdba:dinstall /dev/dm/asm-dmvote"

PROGRAM="/bin/chown -R dmdba:dinstall /dev/dm/asm-dmdcr"

PROGRAM="/bin/chown -R dmdba:dinstall /dev/dm/asm-dmlog"

PROGRAM="/bin/chown -R dmdba:dinstall /dev/dm/asm-dmdata"

PROGRAM="/bin/chown -R dmdba:dinstall /dev/dm/asm-dmarch"

重启测试

1. 1. 1. 验证共享磁盘映射是否生效

blockdev --getsize64 /dev/dm/asm-dmdcr

blockdev --getsize64 /dev/dm/asm-dmvote

blockdev --getsize64 /dev/dm/asm-dmlog

blockdev --getsize64 /dev/dm/asm-dmdata

blockdev --getsize64 /dev/dm/asm-dmarch

1. 1. 安装前环境检查

共享存储集群部署前应进行完整的环境检查，检查共享存储设备绑定情况。如果使用了多路径软件，可对比2台服务器的多路径信息，重点确认2台服务器绑定的设备uuid是否一致，并检查绑定是否生效。

1. 1. 1. 检查设备uuid是否一致

multipath -ll

1. 1. 1. 检查绑定是否生效

blockdev --getsize64 /dev/dm/asm-dmvote

blockdev --getsize64 /dev/dm/asm-dmdcr

blockdev --getsize64 /dev/dm/asm-dmlog

blockdev --getsize64 /dev/dm/asm-dmarch

blockdev --getsize64 /dev/dm/asm-dmdata

DM8DSC集群部署
1. DM8 SOFT安装
  1. 上传ISO文件并挂载

# mount -o loop /soft/dm8_20231116_x86_rh6_64.iso /mnt

1. 1. 命令行安装DM8 soft

su - dmdba

cd /mnt/

$ ./DMInstall.bin -i

root 用户执行root_installer.sh

# /dm/dmdbms/script/root/root_installer.sh

这里不需要初始化数据库，只需安装DM软件即可，切记切记！！

1. DM8DSC集群初始化
  1. 配置 dmdcr_cfg.ini

db01 和 db02 机器配置相同。

$ vi /dm/dmdbms/dsc_config/dmdcr_cfg.ini

DCR_N_GRP = 3 ##集群环境有多少个 GROUP，范围：1~16

DCR_VTD_PATH = /dev/dm/asm-dmvote ##规划为 vote 的磁盘

DCR_OGUID = 210715 ## 消息标识，一个组里面只有一个。

[GRP] #新建一个 GROUP

DCR_GRP_TYPE = CSS ##组类型（CSS/ASM/DB）

DCR_GRP_NAME = GRP_CSS ##组名

DCR_GRP_N_EP = 2 ##组内节点个数

DCR_GRP_DSKCHK_CNT = 65 ##磁盘心跳容错时间，单位:秒

[GRP_CSS]

DCR_EP_NAME = CSS0 ##CSS 节点名

DCR_EP_HOST = 10.10.10.10 ##心跳地址

DCR_EP_PORT = 11286 ##CSS 端口

[GRP_CSS]

DCR_EP_NAME = CSS1

DCR_EP_HOST = 10.10.10.11

DCR_EP_PORT = 11286

[GRP]

DCR_GRP_TYPE = ASM

DCR_GRP_NAME = GRP_ASM

DCR_GRP_N_EP = 2

DCR_GRP_DSKCHK_CNT = 61

[GRP_ASM]

DCR_EP_NAME = ASM0 ##ASM 节点名，和 dmasvrmal 的 MAL_INST_NAME 一致

DCR_EP_SHM_KEY = 42424 ##共享内存标识

DCR_EP_SHM_SIZE = 1024 ##共享内存大小

DCR_EP_HOST = 10.10.10.10 ##心跳地址

DCR_EP_PORT = 11276 ##ASM 端口

DCR_EP_ASM_LOAD_PATH = /dev/dm

[GRP_ASM]

DCR_EP_NAME = ASM1

DCR_EP_SHM_KEY = 42425

DCR_EP_SHM_SIZE = 1024

DCR_EP_HOST = 10.10.10.11

DCR_EP_PORT = 11277

DCR_EP_ASM_LOAD_PATH = /dev/dm

[GRP]

DCR_GRP_TYPE = DB

DCR_GRP_NAME = GRP_DSC

DCR_GRP_N_EP = 2

DCR_GRP_DSKCHK_CNT = 57

[GRP_DSC]

DCR_EP_NAME = DSC0 ##实例名，和 dm.ini 的 INSTANCE_NAME 一致

DCR_EP_SEQNO = 0 ##组内序号，不能重复

DCR_EP_PORT = 5237 ##实例端口，和 dm.ini 的 PORT_NUM 一致

DCR_CHECK_PORT = 11256 ##DCR 检查端口

[GRP_DSC]

DCR_EP_NAME = DSC1

DCR_EP_SEQNO = 1

DCR_EP_PORT = 5237

DCR_CHECK_PORT = 11257

拷贝到其它节点

$ scp -rp /dm/dmdbms/dsc_config/dmdcr_cfg.ini 84.0.191.11:/dm/dmdbms/dsc_config

1. 1. 初始化磁盘组

操作范围【db01服务器】

$ /dm/dmdbms/bin/dmasmcmd

ASM>create dcrdisk '/dev/dm/asm-dmdcr' 'DCR'

ASM>create votedisk '/dev/dm/asm-dmvote' 'VOTE'

ASM>init dcrdisk '/dev/dm/asm-dmdcr' from '/dm/dmdbms/dsc_config/dmdcr_cfg.ini' identified by 'hust4400'

ASM>init votedisk '/dev/dm/asm-dmvote' from '/dm/dmdbms/dsc_config/dmdcr_cfg.ini'

ASM>create asmdisk '/dev/dm/asm-dmdata' 'DATA0'

ASM>create asmdisk '/dev/dm/asm-dmlog' 'LOG0'

ASM>create asmdisk '/dev/dm/asm-dmarch' 'ARCH0'

1. 1. 配置 dmasvrmal.ini

$ vi /dm/dmdbms/dsc_config/dmasvrmal.ini

[MAL_INST0]

MAL_INST_NAME = ASM0

MAL_HOST = 10.10.10.10 #心跳地址

MAL_PORT = 11266 #MAL 监听端口和DCR_EP_PORT = 11276 ##ASM 端口要不一致

[MAL_INST1]

MAL_INST_NAME = ASM1

MAL_HOST = 10.10.10.11

MAL_PORT = 11266

将该文件分别拷贝至 db0 和 db1 机器下的 /dm/dmdbms/dsc_config/DSC0 和 /dm/dmdbms/dsc_config/DSC1 目录下。

$ scp -rp /dm/dmdbms/dsc_config/dmasvrmal.ini 84.0.191.11:/dm/dmdbms/dsc_config/

1. 1. 配置 dmdcr.ini 文件

db01 机器配置 dmdcr.ini，dmdcr_seqo 为 0。

$ vi /dm/dmdbms/dsc_config/dmdcr.ini

DMDCR_PATH = /dev/dm/asm-dmdcr

DMDCR_MAL_PATH = /dm/dmdbms/dsc_config/dmasvrmal.ini

DMDCR_SEQNO = 0

DMDCR_AUTO_OPEN_CHECK = 111

DMDCR_ASM_TRACE_LEVEL = 2

##DMDCR_ASM_RESTART_INTERVAL = 60 #CSS 认定 ASM 故障重启的时间

##DMDCR_ASM_STARTUP_CMD = /dm/dmdbms/bin/dmasmsvr dcr_ini=/dm/dmdbms/dsc_config/dmdcr.ini

##DMDCR_DB_RESTART_INTERVAL = 60 ##CSS 认定 DSC 故障重启的时间，设置为 0 不自动拉起

##DMDCR_DB_STARTUP_CMD = /dm/dmdbms/bin/dmasmsvr path=/dm/dmdbms/dsc_config/dsc0_config/dm.ini dcr_ini=/dm/dmdbms/dsc_config/dmdcr.ini

db02 机器配置 dmdcr.ini，dmdcr_seqo 为 1。

$ vi /dm/dmdbms/dsc_config/dmdcr.ini

DMDCR_PATH = /dev/dm/asm-dmdcr

DMDCR_MAL_PATH = /dm/dmdbms/dsc_config/dmasvrmal.ini

DMDCR_SEQNO = 1

DMDCR_AUTO_OPEN_CHECK = 111

DMDCR_ASM_TRACE_LEVEL = 2

##DMDCR_ASM_RESTART_INTERVAL = 60 #CSS 认定 ASM 故障重启的时间

##DMDCR_ASM_STARTUP_CMD = /dm/dmdbms/bin/dmasmsvr dcr_ini=/dm/dmdbms/dsc_config/dmdcr.ini

##DMDCR_DB_RESTART_INTERVAL = 60 ##CSS 认定 DSC 故障重启的时间，设置为 0 不自动拉起

##DMDCR_DB_STARTUP_CMD = /dm/dmdbms/bin/dmasmsvr path=/dm/dmdbms/dsc_config/dsc1_config/dm.ini dcr_ini=/dm/dmdbms/dsc_config/dmdcr.ini

注意

当前为手动拉起 db01机器和 db02机器的 ASM 和 DMSERVER 服务。待集群配置完成后，再修改为自动拉起（删除 dmdcr.ini 中的“##”号即可）。

注：这里全部打上##，等后面DB初始化后，生成dm.ini后再打开

1. 1. 启动 DMCSS、DMASM 服务
    1. 在 2 个节点分别启动 dmcss 命令

$ /dm/dmdbms/bin/dmcss DCR_INI=/dm/dmdbms/dsc_config/dmdcr.ini

1. 1. 1. 在 2 个节点分别启动 dmasmsvr 命令

$ /dm/dmdbms/bin/dmasmsvr DCR_INI=/dm/dmdbms/dsc_config/dmdcr.ini

说明：如果 DMCSS 配置有自动拉起 dmasmsvr 的功能，可以等待 DMCSS 自动拉起 dmasmsvr 程序，不需要手动启动。

1. 1. 创建 DMASM 磁盘组

##在 db01 节点启动 dmasmtool 工具

$ /dm/dmdbms/bin/dmasmtool DCR_INI=/dm/dmdbms/dsc_config/dmdcr.ini

##输入下列语句创建 DMASM 磁盘组

##创建日志磁盘组

ASM> create diskgroup 'DMLOG' asmdisk '/dev/dm/asm-dmlog'

##创建数据磁盘组

ASM> create diskgroup 'DMDATA' asmdisk '/dev/dm/asm-dmdata'

##创建归档磁盘组

ASM> create diskgroup 'DMARCH' asmdisk '/dev/dm/asm-dmarch'

查看

ASM>lsdg

ASM>lsdsk

ASM>lsall

1. 1. 初始化 DB 环境

db01 和 db02 机器配置相同。

##创建 dminit.ini 文件

$ vi /dm/dmdbms/dsc_config/dminit.ini

DB_NAME = DSC

SYSDBA_PWD = SYSDBA_PWD #密码必须9-48

SYSTEM_PATH = +DMDATA/data

SYSTEM = +DMDATA/data/SYSTEM.dbf

SYSTEM_SIZE = 1024

ROLL = +DMDATA/data/ROLL.dbf

ROLL_SIZE = 1024

MAIN = +DMDATA/data/MAIN.dbf

MAIN_SIZE = 1024

CTL_PATH = +DMDATA/data/dm.ctl

CTL_SIZE = 8

LOG_SIZE = 256 #创建4个2048M大小的redo，实验环境配置256即可生产2048

DCR_PATH = /dev/dm/asm-dmdcr

DCR_SEQNO = 0

AUTO_OVERWRITE = 1

PAGE_SIZE = 32

EXTENT_SIZE = 16

BLANK_PAD_MODE = 1

[DSC0]

CONFIG_PATH = /dm/dmdbms/dsc_config/dsc0_config #后面用dsc0

PORT_NUM = 5237

MAL_HOST = 10.10.10.10

MAL_PORT = 11246

LOG_PATH = +DMLOG/DSC0_LOG01.log

LOG_PATH = +DMLOG/DSC0_LOG02.log

[DSC1]

CONFIG_PATH = /dm/dmdbms/dsc_config/dsc1_config #后面用dsc1

PORT_NUM = 5237

MAL_HOST = 10.10.10.11

MAL_PORT = 11246

LOG_PATH = +DMLOG/DSC1_LOG01.log

LOG_PATH = +DMLOG/DSC1_LOG02.log

注：CONFIG_PATH，二个节点，后面名称必须不一样，如果一样就会报File '/dm/dmdbms/dsc_config/dm.ini' has already exist!错误。

1. 1. 1. 初始化DB

操作范围【DB01节点】

$ /dm/dmdbms/bin/dminit control=/dm/dmdbms/dsc_config/dminit.ini

1. 1. 1. 拷贝文件至db02节点

将dsc0_config和dsc1_config二个目录拷到其它节点

$ scp -rp /dm/dmdbms/dsc_config/dsc1_config 84.0.191.11:/dm/dmdbms/dsc_config

$ rm -rf /dm/dmdbms/dsc_config/dsc1_config

1. 1. 配置 dmarch.ini 文件

db01节点

##修改 dm.ini

$ vi /dm/dmdbms/dsc_config/dsc1_config/dm.ini

ARCH_INI = 1

##创建 dmarch.ini

$ vi /dm/dmdbms/dsc_config/dmarch.ini

ARCH_WAIT_APPLY = 0

ARCH_LOCAL_SHARE = 1

ARCH_LOCAL_SHARE_CHECK=0

[ARCHIVE_LOCAL1]

ARCH_TYPE = LOCAL

ARCH_DEST = +DMARCH/ARCH/DSC0/arch

ARCH_FILE_SIZE = 2048

ARCH_SPACE_LIMIT = 102400

[ARCHIVE_REMOTE1]

ARCH_TYPE = REMOTE

ARCH_DEST = DSC1

ARCH_INCOMING_PATH = +DMARCH/ARCH/DSC1/arch

ARCH_FILE_SIZE = 2048

ARCH_SPACE_LIMIT = 102400

db02 节点

##修改 dm.ini

$ vi /dm/dmdbms/dsc_config/DSC1/dm.ini

ARCH_INI = 1

##创建 dmarch.ini

$ vi /dm/dmdbms/dsc_config/dmarch.ini

ARCH_WAIT_APPLY = 0

ARCH_LOCAL_SHARE = 1

ARCH_LOCAL_SHARE_CHECK=0

[ARCHIVE_LOCAL1]

ARCH_TYPE = LOCAL

ARCH_DEST = +DMARCH/ARCH/DSC1/arch

ARCH_FILE_SIZE = 2048

ARCH_SPACE_LIMIT = 102400

[ARCHIVE_REMOTE1]

ARCH_TYPE = REMOTE

ARCH_DEST = DSC0

ARCH_INCOMING_PATH = +DMARCH/ARCH/DSC0/arch

ARCH_FILE_SIZE = 2048

ARCH_SPACE_LIMIT = 102400

1. 1. 启动数据库集群

如果 DMCSS 配置有自动拉起 dmserver 的功能，可以等待 DMCSS 自动拉起实例，不需要手动启动。如果需要手动启动，可参考以下步骤：

##db01 机器

$ /dm/dmdbms/bin/dmserver /dm/dmdbms/dsc_config/dsc0_config/dm.ini dcr_ini=/dm/dmdbms/dsc_config/dmdcr.ini

##db02 机器

$ /dm/dmdbms/bin/dmserver /dm/dmdbms/dsc_config/dsc1_config/dm.ini dcr_ini=/dm/dmdbms/dsc_config/dmdcr.ini

1. 1. 注册 CSS、ASM、DMSERVER 后台服务

##db01 机器(root用户执行)

# /dm/dmdbms/script/root/dm_service_installer.sh -t dmcss -dcr_ini /dm/dmdbms/dsc_config/dmdcr.ini -p CSS

# /dm/dmdbms/script/root/dm_service_installer.sh -t dmasmsvr -dcr_ini /dm/dmdbms/dsc_config/dmdcr.ini -y DmCSSServiceCSS.service -p ASM

# /dm/dmdbms/script/root/dm_service_installer.sh -t dmserver -dm_ini /dm/dmdbms/dsc_config/dsc0_config/dm.ini -dcr_ini /dm/dmdbms/dsc_config/dmdcr.ini -y DmASMSvrServiceASM.service -p DSC

##db02 机器(root用户执行)

[root@dm8db02 ~]# /dm/dmdbms/script/root/dm_service_installer.sh -t dmcss -dcr_ini /dm/dmdbms/dsc_config/dmdcr.ini -p CSS

[root@dm8db02 ~]#/dm/dmdbms/script/root/dm_service_installer.sh -t dmasmsvr -dcr_ini /dm/dmdbms/dsc_config/dmdcr.ini -y DmCSSServiceCSS.service -p ASM

[root@dm8db02 ~]#/dm/dmdbms/script/root/dm_service_installer.sh -t dmserver -dm_ini /dm/dmdbms/dsc_config/dsc1_config/dm.ini -dcr_ini /dm/dmdbms/dsc_config/dmdcr.ini -y DmASMSvrServiceASM.service -p DSC

备注：db01 机器、db02 机器删除自启可参考以下命令。

# /dm/dmdbms/script/root/dm_service_uninstaller.sh -n DmCSSServiceCSS

# /dm/dmdbms/script/root/dm_service_uninstaller.sh -n DmASMSvrServiceASM

# /dm/dmdbms/script/root/dm_service_uninstaller.sh -n DmServiceDSC

1. 1. 配置监视器

创建 dmcssm.ini

## A 机器、B 机器配置相同

$ mkdir -p /dm/monitor/log

$vi /dm/dmdbms/bin/dmcssm.ini

CSSM_OGUID = 210715

CSSM_CSS_IP = 10.10.10.10:11286

CSSM_CSS_IP = 10.10.10.11:11286

CSSM_LOG_PATH = /dm/monitor/log

CSSM_LOG_FILE_SIZE = 512

CSSM_LOG_SPACE_LIMIT = 2048

注册服务（选做）

# /dm/dmdbms/script/root/dm_service_installer.sh -t dmcssm -cssm_ini /dm/dmdbms/bin/dmcssm.ini -p Monitor

##备注：删除自启

# /dm/dmdbms/script/root/dm_service_uninstaller.sh -n DmCSSMonitorServiceMonitor

监视器使用

命令	含义
show	查看所有组的信息
show config	查看 dmdcr_cfg.ini 的配置信息
show monitor	查看当前连接到主 CSS 的所有监视器信息

1. 1. 启停监视器服务

1. 启动监视器

--前台启动：

$/dm/dmdbms/bin/dmcssm INI_PATH=/dm/dmdbms/bin/dmcssm.ini

--后台启动：

$/dm/dmdbms/bin/DmCSSMonitorServiceMonitor start

输入 show 命令，查看 css、asm 和 db 的状态

以 db 为例，inst_status 字段为 OPEN，vtd_status 字段为 WORKING，active 字段为 TRUE 说明 db 服务正常。

1. 1. 启停集群

##启动：A/B 机器 CSS

A/B 机器：$/dm/dmdbms/bin/DmCSSServiceCSS start

##说明：CSS 启动后 30 秒自动拉起 ASM，60 秒自动拉起 DMSERVER。

##停止： A/B 机器 DMSERVER→A/B 机器 ASM→A/B 机器 CSS

A/B 机器：$ /dm/dmdbms/bin/DmServiceDSC stop

A/B 机器：$ /dm/dmdbms/bin/DmASMSvrServiceASM stop

A/B 机器：$ /dm/dmdbms/bin/DmCSSServiceCSS stop

##单个启动A/B 机器CSS→A/B 机器 ASM →A/B 机器DMSERVER

A/B 机器：$ /dm/dmdbms/bin/DmCSSServiceCSS start

A/B 机器：$ /dm/dmdbms/bin/DmASMSvrServiceASM start

A/B 机器：$ /dm/dmdbms/bin/DmServiceDSC start

说明：

DSC 正常停库必须 2 节点同时停止，根据目前脚本配置，CSS 启动后 30 秒自动拉起 ASM，60 秒自动拉起 DMSERVER，所以停止 DMSERVER 和 ASM 后，要尽快停止 CSS，避免被自动拉起。或者在停库前，取消 dmdcr.ini 配置文件中 DMDCR_ASM_RESTART_INTERVAL、DMDCR_ASM_STARTUP_CMD 前面的 # 号。

服务全部停止后，要检查后台进程是否全部停止。

1. 1. 登录数据库

$ disql SYSDBA/SYSDBA_PWD@84.0.191.10:5237

SQL> select NAME,INSTANCE_NAME,HOST_NAME,STATUS$ ,MODE$ FROM GV$INSTANCE;

行号 NAME INSTANCE_NAME HOST_NAME STATUS$ MODE$

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

1 DSC0 DSC0 dm8db01 OPEN NORMAL

2 DSC1 DSC1 dm8db02 OPEN NORMAL

1. DM8DSC集群测试
  1. 查看进程状态

A/B 机器：$ /dm/dmdbms/bin/DmCSSServiceCSS status

DmCSSServiceCSS (pid 14614) is running.

A/B 机器：$ /dm/dmdbms/bin/DmASMSvrServiceASM status

DmASMSvrServiceASM (pid 14661) is running.

A/B 机器：$ /dm/dmdbms/bin/DmServiceDSC status

DmServiceDSC (pid 15088) is running.

结论：全部running

1. 1. 监视器查看数据库状态

$/dm/dmdbms/bin/dmcssm INI_PATH=/dm/dmdbms/bin/dmcssm.ini

1. 1. SQL查看数据库状态

SQL> select * from V$DSC_EP_INFO;

行号 EP_NAME EP_SEQNO EP_GUID EP_TIMESTAMP EP_MODE EP_STATUS

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

1 DSC0 0 805419 816566 Control Node OK

2 DSC1 1 615709 626856 Normal Node OK

结论：数据库实例OPEN

1. 1. 监视器查看数据库配置

show config

monitor current time:2024-02-04 14:47:08

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

DCR_N_GRP = 3

DCR_VTD_PATH = /dev/dm/asm-dmvote

DCR_OGUID = 210715

[GRP]

DCR_GRP_TYPE = CSS

DCR_GRP_NAME = GRP_CSS

DCR_GRP_N_EP = 2

DCR_GRP_DSKCHK_CNT = 65

[GRP_CSS]

DCR_EP_NAME = CSS0

DCR_EP_HOST = 10.10.10.10

DCR_EP_PORT = 11286

[GRP_CSS]

DCR_EP_NAME = CSS1

DCR_EP_HOST = 10.10.10.11

DCR_EP_PORT = 11286

[GRP]

DCR_GRP_TYPE = ASM

DCR_GRP_NAME = GRP_ASM

DCR_GRP_N_EP = 2

DCR_GRP_DSKCHK_CNT = 61

[GRP_ASM]

DCR_EP_NAME = ASM0

DCR_EP_HOST = 10.10.10.10

DCR_EP_PORT = 11276

DCR_EP_SHM_KEY = 42424

DCR_EP_SHM_SIZE = 1024

DCR_EP_ASM_LOAD_PATH = /dev/dm

[GRP_ASM]

DCR_EP_NAME = ASM1

DCR_EP_HOST = 10.10.10.11

DCR_EP_PORT = 11277

DCR_EP_SHM_KEY = 42425

DCR_EP_SHM_SIZE = 1024

DCR_EP_ASM_LOAD_PATH = /dev/dm

[GRP]

DCR_GRP_TYPE = DB

DCR_GRP_NAME = GRP_DSC

DCR_GRP_N_EP = 2

DCR_GRP_DSKCHK_CNT = 57

[GRP_DSC]

DCR_EP_SEQNO = 0

DCR_EP_NAME = DSC0

DCR_EP_PORT = 5237

DCR_CHECK_PORT = 11256

[GRP_DSC]

DCR_EP_SEQNO = 1

DCR_EP_NAME = DSC1

DCR_EP_PORT = 5237

DCR_CHECK_PORT = 11257

1. 1. 监视器显示当前连接到主CSS信息

show monitor

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

Get monitor connect info from css(seqno:0, name:CSS0).

The first line is self connect info.

CONN_TIME MID MON_IP FROM_NAME

2024-02-04 14:23:37 1707027817 ::ffff:10.10.10.10 dmcssm

2024-02-04 11:36:15 1707017037 ::ffff:10.10.10.10 dmcssm

2024-02-04 11:36:15 1707017380 ::ffff:10.10.10.11 dmcssm

1. 1. 查看ASM磁盘组信息

$ /dm/dmdbms/bin/dmasmtool dcr_ini=/dm/dmdbms/dsc_config/dmdcr.ini

asm>help

1. 1. 1. ASM>help
    2. ASM>df

group DMLOG include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmlog

size: 4.00 GB

create_time: 2023-12-21 17:00:18

modify_time: 2023-12-21 17:06:21

belong group: DMLOG

group DMDATA include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmdata

size: 20.00 GB

create_time: 2023-12-21 17:00:12

modify_time: 2023-12-21 17:06:27

belong group: DMDATA

group DMARCH include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmarch

size: 10.00 GB

create_time: 2023-12-21 17:00:23

modify_time: 2023-12-21 17:06:34

belong group: DMARCH

group VOTE include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmvote

size: 2.00 GB

create_time: 2023-12-21 16:59:59

modify_time: 2023-12-21 17:00:08

belong group: VOTE

group DCR include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmdcr

size: 3.00 GB

create_time: 2023-12-21 16:59:53

modify_time: 2023-12-21 17:00:03

belong group: DCR

1. 1. 1. ASM>lsdg

total 5 groups......

1 disk_group:

id: 0

au_size: 1.00 MB

extent_size: 4

total_size: 4.00 GB

free_size: 2.99 GB

total_file_num: 5

2 disk_group:

id: 1

au_size: 1.00 MB

extent_size: 4

total_size: 20.00 GB

free_size: 16.66 GB

total_file_num: 25

3 disk_group:

id: 2

au_size: 1.00 MB

extent_size: 4

total_size: 10.00 GB

free_size: 9.99 GB

total_file_num: 1

4 disk_group:

id: 125

au_size: 1.00 MB

extent_size: 4

total_size: 2.00 GB

free_size: 1.98 GB

total_file_num: 2

5 disk_group:

id: 126

au_size: 1.00 MB

extent_size: 4

total_size: 3.00 GB

free_size: 2.98 GB

total_file_num: 2

1. 1. 1. ASM>lsdsk

group DMLOG include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmlog

size: 4.00 GB

create_time: 2023-12-21 17:00:18

modify_time: 2023-12-21 17:06:21

belong group: DMLOG

group DMDATA include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmdata

size: 20.00 GB

create_time: 2023-12-21 17:00:12

modify_time: 2023-12-21 17:06:27

belong group: DMDATA

group DMARCH include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmarch

size: 10.00 GB

create_time: 2023-12-21 17:00:23

modify_time: 2023-12-21 17:06:34

belong group: DMARCH

group VOTE include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmvote

size: 2.00 GB

create_time: 2023-12-21 16:59:59

modify_time: 2023-12-21 17:00:08

belong group: VOTE

group DCR include 1 disks......

NO.1 disk :

path: /dev/dm/asm-dmdcr

size: 3.00 GB

create_time: 2023-12-21 16:59:53

modify_time: 2023-12-21 17:00:03

belong group: DCR

1. 1. 1. ASM>lsall

disk_group name: DMLOG, id: 0, au_size: 1.00 MB, extent_size: 4, total_size: 4.00 GB, free_size: 2.99 GB

total 1 disks used......

NO.1 disk :

path: /dev/dm/asm-dmlog

size: 4.00 GB

create_time: 2023-12-21 17:00:18

modify_time: 2023-12-21 17:06:21

total 5 files......

NO.1 dir :

path: +DMLOG

fil_id: 0x80000001

create_time: 2023-12-21 17:06:21

modify_time: 2023-12-21 17:06:21

NO.2 file :

path: +DMLOG/DSC0_LOG01.log

size: 256.00 MB (268435456 Bytes)

fil_id: 0x80000002

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

NO.3 file :

path: +DMLOG/DSC0_LOG02.log

size: 256.00 MB (268435456 Bytes)

fil_id: 0x80000003

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

NO.4 file :

path: +DMLOG/DSC1_LOG01.log

size: 256.00 MB (268435456 Bytes)

fil_id: 0x80000004

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

NO.5 file :

path: +DMLOG/DSC1_LOG02.log

size: 256.00 MB (268435456 Bytes)

fil_id: 0x80000005

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

disk_group name: DMDATA, id: 1, au_size: 1.00 MB, extent_size: 4, total_size: 20.00 GB, free_size: 16.66 GB

total 1 disks used......

NO.1 disk :

path: /dev/dm/asm-dmdata

size: 20.00 GB

create_time: 2023-12-21 17:00:12

modify_time: 2023-12-21 17:06:27

total 25 files......

NO.1 dir :

path: +DMDATA

fil_id: 0x81000001

create_time: 2023-12-21 17:06:27

modify_time: 2023-12-21 17:06:27

NO.2 dir :

path: +DMDATA/data

fil_id: 0x81000002

create_time: 2023-12-21 18:33:34

modify_time: 2023-12-21 18:33:34

NO.3 dir :

path: +DMDATA/data/DSC

fil_id: 0x81000003

create_time: 2023-12-21 19:37:15

modify_time: 2023-12-21 19:37:15

NO.4 dir :

path: +DMDATA/data/DSC/bak

fil_id: 0x81000004

create_time: 2023-12-21 19:37:15

modify_time: 2023-12-21 19:37:15

NO.5 file :

path: +DMDATA/data/dm.ctl

size: 7.00 KB (7168 Bytes)

fil_id: 0x81000005

create_time: 2023-12-21 19:37:17

modify_time: 2024-02-04 15:15:34

NO.6 file :

path: +DMDATA/data/SYSTEM.dbf

size: 1.00 GB (1073741824 Bytes)

fil_id: 0x81000009

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

NO.7 dir :

path: +DMDATA/data/DSC/ctl_bak

fil_id: 0x81000007

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

NO.8 file :

path: +DMDATA/data/OMPTS01.DBF

size: 128.00 MB (134217728 Bytes)

fil_id: 0x81000028

create_time: 2024-02-04 15:15:34

modify_time: 2024-02-04 15:15:34

NO.9 file :

path: +DMDATA/data/DSC/dm_service.prikey

size: 0.62 KB (633 Bytes)

fil_id: 0x8100000a

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

NO.10 file :

path: +DMDATA/data/MAIN.dbf

size: 1.00 GB (1073741824 Bytes)

fil_id: 0x8100000b

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

NO.11 file :

path: +DMDATA/data/ROLL.dbf

size: 1.00 GB (1073741824 Bytes)

fil_id: 0x8100000c

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

NO.12 dir :

path: +DMDATA/data/DSC/HMAIN

fil_id: 0x8100000d

create_time: 2023-12-21 19:37:17

modify_time: 2023-12-21 19:37:17

NO.13 file :

path: +DMDATA/data/DSC/TEMP0.DBF

size: 74.00 MB (77594624 Bytes)

fil_id: 0x8100000e

create_time: 2023-12-21 21:12:42

modify_time: 2024-02-04 11:47:47

NO.14 file :

path: +DMDATA/data/DSC/TEMP1.DBF

size: 74.00 MB (77594624 Bytes)

fil_id: 0x8100000f

create_time: 2023-12-21 21:13:38

modify_time: 2024-02-04 11:47:49

NO.15 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20240204114744_542125.ctl

size: 6.00 KB (6144 Bytes)

fil_id: 0x81000025

create_time: 2024-02-04 11:47:44

modify_time: 2024-02-04 11:47:44

NO.16 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20240204114749_148717.ctl

size: 6.00 KB (6144 Bytes)

fil_id: 0x81000027

create_time: 2024-02-04 11:47:49

modify_time: 2024-02-04 11:47:49

NO.17 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20240204151534_614948.ctl

size: 6.50 KB (6656 Bytes)

fil_id: 0x8100002c

create_time: 2024-02-04 15:15:34

modify_time: 2024-02-04 15:15:34

NO.18 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20240204151534_647455.ctl

size: 7.00 KB (7168 Bytes)

fil_id: 0x8100002e

create_time: 2024-02-04 15:15:34

modify_time: 2024-02-04 15:15:34

NO.19 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20240204151534_674511.ctl

size: 7.00 KB (7168 Bytes)

fil_id: 0x81000030

create_time: 2024-02-04 15:15:34

modify_time: 2024-02-04 15:15:34

NO.20 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20240204151534_706597.ctl

size: 7.00 KB (7168 Bytes)

fil_id: 0x81000032

create_time: 2024-02-04 15:15:34

modify_time: 2024-02-04 15:15:34

NO.21 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20231224172703_925784.ctl

size: 6.00 KB (6144 Bytes)

fil_id: 0x8100001d

create_time: 2023-12-24 17:27:03

modify_time: 2023-12-24 17:27:03

NO.22 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20231224172706_363877.ctl

size: 6.00 KB (6144 Bytes)

fil_id: 0x8100001f

create_time: 2023-12-24 17:27:06

modify_time: 2023-12-24 17:27:06

NO.23 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20240204113229_437236.ctl

size: 6.00 KB (6144 Bytes)

fil_id: 0x81000021

create_time: 2024-02-04 11:32:28

modify_time: 2024-02-04 11:32:28

NO.24 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20240204113233_208212.ctl

size: 6.00 KB (6144 Bytes)

fil_id: 0x81000023

create_time: 2024-02-04 11:32:32

modify_time: 2024-02-04 11:32:32

NO.25 file :

path: +DMDATA/data/DSC/ctl_bak/dm_20240204151534_583821.ctl

size: 6.00 KB (6144 Bytes)

fil_id: 0x8100002a

create_time: 2024-02-04 15:15:34

modify_time: 2024-02-04 15:15:34

disk_group name: DMARCH, id: 2, au_size: 1.00 MB, extent_size: 4, total_size: 10.00 GB, free_size: 9.99 GB

total 1 disks used......

NO.1 disk :

path: /dev/dm/asm-dmarch

size: 10.00 GB

create_time: 2023-12-21 17:00:23

modify_time: 2023-12-21 17:06:34

total 1 files......

NO.1 dir :

path: +DMARCH

fil_id: 0x82000001

create_time: 2023-12-21 17:06:34

modify_time: 2023-12-21 17:06:34

disk_group name: VOTE, id: 125, au_size: 1.00 MB, extent_size: 4, total_size: 2.00 GB, free_size: 1.98 GB

total 1 disks used......

NO.1 disk :

path: /dev/dm/asm-dmvote

size: 2.00 GB

create_time: 2023-12-21 16:59:59

modify_time: 2023-12-21 17:00:08

total 2 files......

NO.1 dir :

path: +VOTE

fil_id: 0xfd000001

create_time: 2023-12-21 17:00:08

modify_time: 2023-12-21 17:00:08

NO.2 file :

path: +VOTE/VOTE

size: 12.00 MB (12587008 Bytes)

fil_id: 0xfd000002

create_time: 2023-12-21 17:00:08

modify_time: 2023-12-21 17:00:08

disk_group name: DCR, id: 126, au_size: 1.00 MB, extent_size: 4, total_size: 3.00 GB, free_size: 2.98 GB

total 1 disks used......

NO.1 disk :

path: /dev/dm/asm-dmdcr

size: 3.00 GB

create_time: 2023-12-21 16:59:53

modify_time: 2023-12-21 17:00:03

total 2 files......

NO.1 dir :

path: +DCR

fil_id: 0xfe000001

create_time: 2023-12-21 17:00:03

modify_time: 2023-12-21 17:00:03

NO.2 file :

path: +DCR/DCR

size: 12.00 MB (12587008 Bytes)

fil_id: 0xfe000002

create_time: 2023-12-21 17:00:03

modify_time: 2023-12-21 17:00:03

1. 1. 建表测试
    1. 节点1

$ disql SYSDBA/SYSDBA_PWD@127.0.0.1:5237

create tablespace "OMP_TS" datafile '+DMDATA/data/OMPTS01.DBF' size 128 autoextend on next 1 maxsize 1024 CACHE = NORMAL;

CREATE USER omp IDENTIFIED BY "omp123123!" DEFAULT TABLESPACE OMP_TS;

GRANT RESOURCE TO omp;

create table OMP.year_2001(

ID number(10) primary key not null,

name varchar2(30),

port VARCHAR(255),

speed VARCHAR(255),

type VARCHAR(255),

create_time date

);

begin

for i in 1..100 loop

insert into OMP.year_2001 values(i, 'cisco-'||i,'3306','10000','router-'||i,to_date('2021-06-20 18:31:34','YYYY-MM-DD HH24:MI:SS'));

end loop;

commit;

end;

SQL> select count(*) from OMP.YEAR_2001;

行号 COUNT(*)

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

SQL> select owner,table_name,tablespace_name from dba_tables where owner='OMP';

行号 OWNER TABLE_NAME TABLESPACE_NAME

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

1 OMP YEAR_2001 OMP_TS

1. 1. 1. 节点2

$ disql SYSDBA/SYSDBA_PWD@127.0.0.1:5237

SQL> select count(*) from OMP.YEAR_2001;

行号 COUNT(*)

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

SQL> select owner,table_name,tablespace_name from dba_tables where owner='OMP';

行号 OWNER TABLE_NAME TABLESPACE_NAME

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

1 OMP YEAR_2001 OMP_TS

结论：因为是共享存储，二边数据共享，完全一致。

1. 1. 在线加盘测试

加一块20G共享数据盘，磁盘别名为asm-dmdata02

1. 1. 1. 创建磁盘

"C:\Program Files (x86)\VMware\VMware Workstation\vmware-vdiskmanager.exe" -c -s 20GB -a lsilogic -t 2 "D:\vmware\Kylin_DM\DM8_RAC_Kylin\DM8_RAC1\DATA-20Ga1.vmdk"

# lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT

sda 8:0 0 60G 0 disk

├─sda1 8:1 0 300M 0 part /boot

└─sda2 8:2 0 59.7G 0 part

├─klas-root 253:0 0 51.7G 0 lvm /

└─klas-swap 253:1 0 8G 0 lvm [SWAP]

sdb 8:16 0 2G 0 disk

sdc 8:32 0 3G 0 disk

sdd 8:48 0 4G 0 disk

sde 8:64 0 20G 0 disk

sdf 8:80 0 10G 0 disk

sdg 8:96 0 20G 0 disk

1. 1. 1. 查询UUID

# /usr/lib/udev/scsi_id -g -u -d /dev/sdg

36000c2975d799fc11bfe3a3c38db543a

1. 1. 1. 绑定UUID

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=="36000c2975d799fc11bfe3a3c38db543a",SYMLINK+="dm/asm-dmdata02",OWNER="dmdba",GROUP="dinstall",MODE="0660"