某一天博主收到个任务给某家医院系统更换双活存储,登到系统一看是mulitipath的多路径存储,操作也比较简单,有需要的朋友可以收藏一下,以备不时之需。
需求是这样:更换ocr,3个data磁盘组,采用add drop 磁盘的方式
一.添加新存储到mulitipath中
查看新磁盘uuid
/sbin/scsi_id -g -u -d /dev/sdb
更改配置文件
vi /etc/multipath.conf
multipaths {
multipath {
wwid 36005076802820a0cc000000000000017
alias OCR1
}
multipath {
wwid 36005076802820a0cc000000000000018
alias OCR2
}
multipath {
wwid 36005076802820a0cc000000000000016
alias OCR3
}
multipath {
wwid 36005076802820a0cc000000000000014
alias DATA1
}
multipath {
wwid 36005076802820a0cc000000000000012
alias DATA2
}
multipath {
wwid 36005076802820a0cc000000000000011
alias DATA3
}
multipath {
wwid 36005076802820a0cc000000000000013
alias DATA4
}
multipath {
wwid 36005076802820a0cc000000000000015
alias DATA5
}
multipath {
wwid 3600a098038314274422b515971635553
alias OCRNEW1
}
multipath {
wwid 3600a098038314274422b515971635554
alias OCRNEW2
}
multipath {
wwid 3600a098038314274422b515971635555
alias OCRNEW3
}
multipath {
wwid 3600a098038314274422b515971635550
alias DATANEW1
}
multipath {
wwid 3600a098038314274422b515971635551
alias DATANEW2
}
multipath {
wwid 3600a098038314274422b515971635552
alias DATANEW3
}
multipath {
wwid 3600a098038314274422b51597163554e
alias DATANEW4
}
multipath {
wwid 3600a098038314274422b51597163554f
alias DATANEW5
}
}
删除多路径设备:
multipath –F
重新扫描设备:
multipath –v3
查看生效情况
multipath –ll
二.udev生效磁盘权限
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-36005076802820a0cc000000000000015",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-36005076802820a0cc000000000000016",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-36005076802820a0cc000000000000013",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-36005076802820a0cc000000000000018",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-36005076802820a0cc000000000000011",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-36005076802820a0cc000000000000017",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-36005076802820a0cc000000000000012",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-36005076802820a0cc000000000000014",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-3600a098038314274422b515971635553",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-3600a098038314274422b515971635554",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-3600a098038314274422b515971635555",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-3600a098038314274422b515971635550",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-3600a098038314274422b515971635551",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-3600a098038314274422b515971635552",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-3600a098038314274422b51597163554e",OWNER="grid",GROUP="dba",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-3600a098038314274422b51597163554f",OWNER="grid",GROUP="dba",MODE="0660"
不掉盘生效udev
udevadm trigger --subsystem-match=block
查出各磁盘名name信息
select TOTAL_MB,OS_MB,name,PATH from v$asm_disk;
三.添加新磁盘到磁盘组中,启用图形加盘
alter diskgroup OCRVT add disk '/dev/dm-9';
alter diskgroup OCRVT add disk '/dev/dm-10';
alter diskgroup OCRVT add disk '/dev/dm-11';
alter diskgroup PACSDATA add disk '/dev/dm-12';
alter diskgroup PACSDATA add disk '/dev/dm-13';
alter diskgroup PACSDATA add disk '/dev/dm-14';
alter diskgroup SPIRITDATA add disk '/dev/dm-15';
alter diskgroup JHEMRDATA add disk '/dev/dm-16';
四.踢出老磁盘,删除mulitipath配置文件和udev老磁盘信息
alter diskgroup OCRVT drop disk OCRVT_0000;
alter diskgroup OCRVT drop disk OCRVT_0001;
alter diskgroup OCRVT drop disk OCRVT_0002;
alter diskgroup PACSDATA drop disk PACSDATA_0000;
alter diskgroup PACSDATA drop disk PACSDATA_0001;
alter diskgroup PACSDATA drop disk PACSDATA_0002;
alter diskgroup SPIRITDATA drop disk SPIRITDATA_0000;
alter diskgroup JHEMRDATA drop disk JHEMRDATA_0000;
五.最后查询平衡进度
select * from v$asm_operation;
select b.NAME,b.type,t.disk_number,t.TOTAL_MB/1024,t.FREE_MB/1024 from v$asm_disk t,v$asm_diskgroup b
where t.GROUP_NUMBER=b.GROUP_NUMBER order by t.disk_number;
此查询会记录到磁盘的平衡过程。