12C RAC for ASM添加磁盘步骤
发布日期:2021-06-28 20:47:08 浏览次数:2 分类:技术文章

本文共 5442 字,大约阅读时间需要 18 分钟。

RHEL 7.2使用EMC Powerpath扩容2T磁盘空间,需要添加至以用12C RAC for ASM系统中。下面是具体步骤,主机人员告知扩容别名为data_center_16、data_center_17

1:linux 7 系统下添加映射存储LUN(无需重启)

1>查看机器HBA卡信息--两个节点机器都得root用户执行
#ls /sys/class/fc_host
host0-10
2>通过修改文件“scan”权限,让系统重新扫描新的硬件设备
echo '- - -' > /sys/class/scsi_host/host0/scan
echo '- - -' > /sys/class/scsi_host/host1/scan
echo '- - -' > /sys/class/scsi_host/host2/scan
echo '- - -' > /sys/class/scsi_host/host3/scan
echo '- - -' > /sys/class/scsi_host/host4/scan
echo '- - -' > /sys/class/scsi_host/host5/scan
echo '- - -' > /sys/class/scsi_host/host6/scan
echo '- - -' > /sys/class/scsi_host/host7/scan
echo '- - -' > /sys/class/scsi_host/host8/scan
echo '- - -' > /sys/class/scsi_host/host9/scan
echo '- - -' > /sys/class/scsi_host/host10/scan

3>查询新识别出的来设备,两个节点机器都得执行root用户

#powermt display dev=all
#ls -al /dev/emcpower*
#powermt display
#powermt config
#powermt save

4>查询新增的扩容盘为data_center_16、data_center_17

Pseudo name=emcpowert
VNX ID=CKM00141100044 [data_center]
Logical device ID=60060160F7303500ACF6E88706A1E811 [data_center_16]
state=alive; policy=CLAROpt; queued-IOs=0
Owner: default=SP B, current=SP B Array failover mode: 4

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

--------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---

HW Path I/O Paths Interf. Mode State Q-IOs Errors

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

9 lpfc sdcx SP B0 active alive 0 0
9 lpfc sdcv SP A1 active alive 0 0
1 lpfc sdct SP A0 active alive 0 0
1 lpfc sdcr SP B1 active alive 0 0

Pseudo name=emcpoweru

VNX ID=CKM00141100044 [data_center]
Logical device ID=60060160F7303500ADF6E88706A1E811 [data_center_17]
state=alive; policy=CLAROpt; queued-IOs=0
Owner: default=SP B, current=SP B Array failover mode: 4

--------------- Host --------------- - Stor - -- I/O Path -- -- Stats ---

HW Path I/O Paths Interf. Mode State Q-IOs Errors

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

9 lpfc sdcy SP B0 active alive 0 0
9 lpfc sdcw SP A1 active alive 0 0
1 lpfc sdcu SP A0 active alive 0 0
1 lpfc sdcs SP B1 active alive 0 0

并且查看有关系统信息是否有emcpowert、emcpoweru此次扩容盘别名

cat /proc/partitions | awk {'print $4'} |grep emcpower|sort

5> 执行root下脚本asm_udev_ol7.sh

[root@dwdb1 ~]# more asm_udev_ol7.sh

#!/bin/bash
for i in $(cat /proc/partitions | awk {'print $4'} |grep emcpower|sort);
do
echo "ACTION==\"add|change\", KERNEL==\"emcpower*\", ENV{DEVTYPE}==\"disk\",SUBSYSTEM==\"block\", PROGRAM==\"
/usr/lib/udev/scsi_id -g -u -d --whitelisted --replace-whitespace --device=\$devnode\", RESULT==\"/usr/lib/u<br/>dev/scsi_id -g -u -d --whitelisted --replace-whitespace --device=/dev/$i\",RUN+=\"/bin/sh -c 'mknod /dev/asm
-$i b \$major \$minor; chown grid:asmadmin /dev/asm-$i; chmod 0660 /dev/asm-$i'\"" >> /etc/udev/rules.d/
99-oracle-asmdevices.rules_bak
done

6>生成的/etc/udev/rules.d/99-oracle-asmdevices.rules_bak中取出(360060160f7303500acf6e88706a1)

ACTION=="add|change", KERNEL=="emcpower", ENV{DEVTYPE}=="disk",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/s
csi_id -g -u -d --whitelisted --replace-whitespace --device=$devnode", RESULT=="360060160f7303500acf6e88706a1
e811",RUN+="/bin/sh -c 'mknod /dev/asm-emcpowert b $major $minor; chown grid:asmadmin /dev/asm-emcpowert; chm
od 0660 /dev/asm-emcpowert'"
ACTION=="add|change", KERNEL=="emcpower
", ENV{DEVTYPE}=="disk",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/s
csi_id -g -u -d --whitelisted --replace-whitespace --device=$devnode", RESULT=="360060160f7303500adf6e88706a1
e811",RUN+="/bin/sh -c 'mknod /dev/asm-emcpoweru b $major $minor; chown grid:asmadmin /dev/asm-emcpoweru; chm
od 0660 /dev/asm-emcpoweru'"

7>然后vi /etc/udev/rules.d/99-oracle-asmdevices.rules新增两条信息,将改好的文件,scp到节点二。

ACTION=="add|change", KERNEL=="emcpower", ENV{DEVTYPE}=="disk",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/s

csi_id -g -u -d --whitelisted --replace-whitespace --device=$devnode", RESULT=="360060160f7303500acf6e88706a1
e811",RUN+="/bin/sh -c 'mknod /dev/asm-data15 b $major $minor; chown grid:asmadmin /dev/asm-data15; chmod 066
0 /dev/asm-data15'"
ACTION=="add|change", KERNEL=="emcpower
", ENV{DEVTYPE}=="disk",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/s
csi_id -g -u -d --whitelisted --replace-whitespace --device=$devnode", RESULT=="360060160f7303500adf6e88706a1
e811",RUN+="/bin/sh -c 'mknod /dev/asm-data16 b $major $minor; chown grid:asmadmin /dev/asm-data16; chmod 066
0 /dev/asm-data16'"

2、udev 确认99.rules文件在两边后,两个节点执行以下命令;

/sbin/udevadm control --reload
/sbin/udevadm trigger --type=devices --action=change
检查磁盘是否属组正确

3、ASM磁盘组加磁盘或创建新的磁盘组。

[grid@dwdb1 ~]$ sqlplus / as sysasm
sysasm$alter diskgroup DATA add disk '/dev/asm-data15','/dev/asm-data16' rebalance power 10; ###该参数可以动态调整,10太慢的话,可以改到中间值5.

--查看执行效率

select group_number,operation,state ,power,est_minutes from v$asm_operation;

--等到执行完成后,改回1,11值为最小性能,1为最大性能

alter diskgroup DATA rebalance power 1;

--至此扩容工作已经完成,下面是具体监控办法

--检查header_status状态,不应该有MEMBER以外的状态
select group_number,disk_number,name,state,path,header_status from v$asm_disk;

--监控alert日志输出结果

2018-08-17T16:43:33.399676+08:00
NOTE: Assigning number (3,14) to disk (/dev/asm-data15)
SUCCESS: completed reconfiguration of group 3 (DATA)
NOTE: Assigning number (3,15) to disk (/dev/asm-data16)
SUCCESS: completed reconfiguration of group 3 (DATA)

--监控查看rebalance进度,完成后查询为空,改回power 为1

select inst_id, operation, state, power, sofar, est_work, est_rate, est_minutes from gv$asm_operation;

转载地址:https://blog.csdn.net/yangjunfeng0604/article/details/116599629 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!

上一篇:ORA-30013: undo tablespace currently in use故障处理思路
下一篇:由浅入深学优化之like‘%%’坑爹写法

发表评论

最新留言

路过,博主的博客真漂亮。。
[***.116.15.85]2024年04月02日 21时49分34秒

关于作者

    喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!

推荐文章