RAC19C安装-04-扩充OCR磁盘

On By 去哪儿

1、存储服务器添加共享磁盘

#新增加磁盘，未被识别到扫描加载
scsisum=`ll /sys/class/scsi_host/host*|wc -l`

for ((i=0;i<${scsisum};i++))
do
    echo "- - -" > /sys/class/scsi_host/host${i}/scan
done

#查看磁盘
lsblk
NAME   MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sdi      8:128  0   10G  0 disk 

#加到target
targetcli
/> cd backstores/block/
/backstores/block> ls
/backstores/block> create name=disk8 dev=/dev/sdi
Created block storage object disk8 using /dev/sdi.
/backstores/block> cd /iscsi/iqn.2024-03.com.jiae:racdisk/tpg1/luns/
/iscsi/iqn.20...isk/tpg1/luns> ls
/iscsi/iqn.20...isk/tpg1/luns> create lun=lun8 storage_object=/backstores/block/disk8
/iscsi/iqn.20...isk/tpg1/luns> cd /
/> saveconfig 
Configuration saved to /etc/target/saveconfig.json
/> exit
Global pref auto_save_on_exit=true
Last 10 configs saved in /etc/target/backup/.
Configuration saved to /etc/target/saveconfig.json

2、扫描LUN信息，新增新磁盘，配置磁盘多路径别名

#扫描新Lun
iscsiadm -m node -R
或
multipath -v2

3、配置多路径别名，wwid通过multipath -l可查看

vim /etc/multipath.conf
        multipath {
                wwid                    36001405246041b7873f44fabdb02ead2
                alias                   oracle-ocr04
                path_grouping_policy    multibus
                path_selector           "round-robin 0"
                failback                immediate
        }

#重启服务
systemctl reload multipathd
或
systemctl restart multipathd.service

4、查看别名是否成功

#查看别名是否成功
multipath -l | grep oracl | sort
oracle-data01 (360014056a7724400e6a4b0fb404c4862) dm-5 LIO-ORG ,disk4           
oracle-data02 (36001405711b236ebd4445aca167f98a3) dm-4 LIO-ORG ,disk5           
oracle-data03 (36001405cdb85620e14847d7bd25a3f09) dm-1 LIO-ORG ,disk6           
oracle-data04 (36001405dffaec1fbb84401bb74f023bd) dm-0 LIO-ORG ,disk7           
oracle-ocr01 (36001405fdb7d337dbb44918805c9f571) dm-7 LIO-ORG ,disk1           
oracle-ocr02 (3600140525008d466d504d46a3402bfbb) dm-6 LIO-ORG ,disk2           
oracle-ocr03 (36001405e1ee066923264f288e1616923) dm-3 LIO-ORG ,disk3           
oracle-ocr04 (36001405246041b7873f44fabdb02ead2) dm-2 LIO-ORG ,disk8

5、编辑udev配置

vi /etc/udev/rules.d/60-dm.rules 
ENV{DM_NAME}=="oracle-ocr04", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="iscsi/oraasm-{DM_NAME}"
/sbin/udevadm control --reload-rules
/sbin/udevadm trigger --type=devices --action=change
ll /dev/dm-*

6、grid用户启动asmca添加新磁盘，也可用命令alter diskgroup MGMT add disk  ‘/dev/mapper/oracle-ocr04’;

当ASM需要增加磁盘空间时，可将新的磁盘设备添加到磁盘组，ASM磁盘组会按照一定比例将数据从一个或多个已有的磁盘移动到新的磁盘，从而维持所有磁盘之间整体的I/O平衡。这种特性也提供了将整个数据库从一组较慢的磁盘迁移到一组较快磁盘的迁移方法，而且整个过程数据库能保持联机状态。当重新平衡操作完成后，我们可以剔除较慢的磁盘组，保留较快磁盘的磁盘组，从而完成联机状态下的数据迁移。

可以通过更改ASM初始参数，可控制磁盘重平衡的速度及对运行数据库I/O的影响。数值越大并发越高，重平衡速度也越快，后台I/O消耗越大。

alter diskgroup DATA add disk ‘/dev/mapper/data6′,’/dev/mapper/data7′,’/dev/mapper/data8′,’/dev/mapper/data9’ rebalance power 6;

查看平衡状态

sqlplus / as sysasm

select * from v$asm_operation;

select name,state from v$asm_diskgroup;

列出磁盘组：asmcmd lsdg 列出所有的ASM磁盘组及其状态。

列出ASM磁盘：asmcmd lsdsk 列出所有ASM磁盘及其详细信息，包括磁盘路径、磁盘组、状态等。

列出特定磁盘组的磁盘：asmcmd lsdsk -G DATA

查询ASM磁盘组的使用容量：asmcmd du

select GROUP_NUMBER,path,state,TOTAL_MB,FREE_MB from v$asm_disk;

select name,path from v$asm_disk;   

select name,state,type,total_mb,free_mb from v$asm_diskgroup;

select GROUP_NUMBER,path,state,TOTAL_MB,FREE_MB from v$asm_disk;