华为存储绑定oracle asm磁盘

1

# HUAWEI 存储 LINUX 平台扩容 ASM 步骤


# 查看当前配置（grid 用户）
asmcmd lsdsk --candidate -p
先确认当前是否已有可添加的候选磁盘

sqlplus / as sysasm
col path for a40
set lin 120 pages 100
select group_number,path,total_mb,free_mb,CREATE_DATE from v$asm_disk order by 1,CREATE_DATE,path;
col name for a30
select group_number,name,total_mb,free_mb  from v$asm_diskgroup order by 1;
show parameter asm_diskstring

查看asm磁盘组使用率

col name for a15
select name,trunc((total_mb-free_mb)/1024) used_g,trunc(total_mb/1024) total_g, trunc(free_mb/1024) free_g,round((total_mb-free_mb)/total_mb*100,2) used_percent from v$asm_diskgroup order by used_percent desc ;


取出还没授权的新盘（root 用户）
rhel6: export SCSI=scsi_id
rhel7: export SCSI=/usr/lib/udev/scsi_id

vi /tmp/a.sh

echo 'device     size     uuid'
for i in `cat /proc/partitions | awk {'print $4'} |grep sd|tail -$1`;
 do val=`/sbin/blockdev --getsize64 /dev/$i` ;
 val2=`expr $val / 1073741824`;
 echo "/dev/$i: $val2 `$SCSI -gud /dev/$i`" ;
done

sh /tmp/a.sh 10
将id信息存放到临时文件，磁盘个数10 从存储工程师提供的信息获得


ls -l /dev/sd*
上述设备应该是root:disk属主

生成绑定描述
rm -fr /tmp/b.sh
vi /tmp/b.sh

rm -fr /tmp/a.rules
j=$2;
for i in ` cat /proc/partitions | awk {'print $4'} |grep sd|tail -$1` ;
do
 j=$(($j+1))
 echo "KERNEL==\"sd*\",SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`$SCSI -gud /dev/$i`\", SYMLINK+=\"asmdisk/DATA$j\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\" " >> /tmp/a.rules ;
done
cat /tmp/a.rules

sh /tmp/b.sh 10 39

磁盘个数10，当前+DATADG磁盘{BANNED}最佳大序号是39

手工检查修改一下设备名称，将 DATA08 改为实际需要的，注意前缀0或ARCH !!!

tail /etc/udev/rules.d/99-oracle-asmdevices.rules

先备份udev文件

cp /etc/udev/rules.d/99-oracle-asmdevices.rules /tmp/99-oracle-asmdevices.rules_$(date "+%Y%m%d%H%M%S")

vi /etc/udev/rules.d/99-oracle-asmdevices.rules

生效

/sbin/udevadm control --reload-rules
/sbin/udevadm trigger --type=devices --action=change

ls -l /dev/asmdisk/* 确认是否有新的asm磁盘，且属主正确

如果没问题直接复制到节点2

scp /etc/udev/rules.d/99-oracle-asmdevices.rules NODE2 :/etc/udev/rules.d/99-oracle-asmdevices.rules
执行上面两个 udevadm 命令，然后ls 看是否和主机1一样


添加到磁盘组（grid用户）
asmcmd lsdsk --candidate -p

图形方式
asmca
sqlplus / as sysasm
alter diskgroup DATADG rebalance power 11;

手工方式
alter diskgroup DATADG add disk '/dev/asmdisk/DATA40','/dev/asmdisk/DATA41','/dev/asmdisk/DATA42','/dev/asmdisk/DATA43' rebalance power 11;


查进度
col error_code for a10
set lin 300 pages 100
select group_number,operation,state,power,actual,sofar,est_work,est_minutes,error_code,round(sofar/ (est_work+0.1)*100,1) per from v$asm_operation;

2