1、操作介绍
记录在AIX操作系统向ASM卷组中添加新磁盘的操作过程及注意事项。
2、环境介绍
操作系统： AIX 5.3
数据库版本： Oracle 10.2.0.5 2结点RAC
集群存储管理软件： ASM(自动存储管理)
3、操作过程
3.1 查看需要添加的磁盘
使用命令lspv查看磁盘信息
结点1
hdisk49 none None
hdisk50 none None
结点2
hdisk49 none None
hdisk50 none None
注：如果哪个结点未列出需要添加的磁盘，使用以下命令进行从新添加
# /usr/sbin/cfgmgr
3.2 检查磁盘对应关系(结点1 hdisk49和结点2 hdisk49可能不是同一块物理设备)
结点1 hdisk49
root@htdb1:/dev/# lscfg -vpsl hdisk49
hdisk49 U789D.001.DQD4R9Y-P1-C1-T1-W50060E8005947628-L2F000000000000
XP Disk Array (Fibre)
Manufacturer................HP
Machine Type and Model......OPEN-V
Part Number.................
ROS Level and ID............36303037
Serial Number...............50 09476
EC Level....................
FRU Number..................
Device
Specific.(Z0)........00000332CF000002
Device Specific.(Z1)........0481 3J ....
Device Specific.(Z2).........
Device Specific.(Z3).........
Device Specific.(Z4)..........W*
Device Specific.(Z5)........
Device Specific.(Z6)........
PLATFORM SPECIFIC
Name: disk
Node: disk
Device Type: block
结点1 hdisk50
root@htdb1:/dev/# lscfg -vpsl hdisk50
hdisk50 U789D.001.DQD4R9Y-P1-C1-T1-W50060E8005947628-L30000000000000
XP Disk Array (Fibre)
Manufacturer................HP
Machine Type and Model......OPEN-V
Part Number.................
ROS Level and ID............36303037
Serial Number...............50 09476
EC Level....................
FRU Number..................
Device Specific.(Z0)........00000332CF000002
Device Specific.(Z1)........0482 3J ....
Device Specific.(Z2).........
Device Specific.(Z3).........
Device
Specific.(Z4)..........W*
Device Specific.(Z5)........
Device Specific.(Z6)........
PLATFORM SPECIFIC
Name: disk
Node: disk
Device Type: block
结点2 hdisk49
root@htdb2:/# lscfg -vl hdisk49
hdisk49 U78A0.001.DNWK5C4-P1-C4-T2-W50060E8005947628-L2F000000000000 XP MPIO Disk XP24000 (Fibre)
Manufacturer................HP
Machine Type and Model......OPEN-V
Part Number.................
ROS Level and ID............36303037
Serial Number...............50 09476
EC Level....................
FRU Number..................
Device Specific.(Z0)........00000332CF000002
Device Specific.(Z1)........0481 3J ....
Device Specific.(Z2).........
Device Specific.(Z3).........
Device Specific.(Z4)..........en
Device Specific.(Z5)........
Device Specific.(Z6)........
结点2 hdisk50
root@htdb2:/# lscfg -vl hdisk50
hdisk50 U78A0.001.DNWK5C4-P1-C4-T2-W50060E8005947628-L30000000000000 XP MPIO Disk XP24000 (Fibre)
Manufacturer................HP
Machine Type and Model......OPEN-V
Part Number.................
ROS Level and ID............36303037
Serial Number...............50 09476
EC Level....................
FRU Number..................
Device Specific.(Z0)........00000332CF000002
Device Specific.(Z1)........0482 3J ....
Device Specific.(Z2).........
Device Specific.(Z3).........
Device Specific.(Z4)..........en
Device Specific.(Z5)........
Device Specific.(Z6)........
总结
结点1 hdisk49 对应结点2 hdisk49
结点1 hdisk50 对应结点2 hdisk50
3.3 查看磁盘主设备号和从设备号
结点1
root@htdb1:/dev/#
ls -alF /dev/*hdisk49
brw------- 1 root system 23, 49 Mar 22 11:03 /dev/hdisk49
crw------- 1 root system 23, 49 Mar 22 11:03 /dev/rhdisk49
root@htdb1:/dev/#
ls -alF /dev/*hdisk50
brw------- 1 root system 23, 50 Mar 22 11:03 /dev/hdisk50
crw------- 1 root system 23, 50 Mar 22 11:03 /dev/rhdisk50
结点2
root@htdb2:/dev/#
ls -alF /dev/*hdisk49
brw------- 1 root system 24, 50 Mar 21 17:19 /dev/hdisk49
crw------- 1 root system 24, 50 Mar 21 17:19 /dev/rhdisk49
root@htdb2:/dev/#
ls -alF /dev/*hdisk50
brw------- 1 root system 24, 49 Mar 21 17:19 /dev/hdisk50
crw------- 1 root system 24, 49 Mar 21 17:19 /dev/rhdisk50
/dev/rhdisk*代表字符设备，23/24代表设备major number(设备类型), 49/50 代表minor numbers(具体设备)。
3.4 创建裸设备文件
节点1：
mknod /dev/htasm/asmdisk35 c 23,49
mknod /dev/htasm/asmdisk36 c 23,50
节点2：
mknod /dev/htasm/asmdisk35 c 24,50
mknod /dev/htasm/asmdisk36 c 24,49
注：
In the following example, you must specify the character c to create a character raw device file.
3.5 修改磁盘属性(2结点分别执行)
/usr/sbin/chdev -l hdisk49 -a reserve_policy=no_reserve
/usr/sbin/chdev -l hdisk50 -a reserve_policy=no_reserve
--检查语句： lsattr -El hdisk49
To enable simultaneous access to a disk device from multiple nodes, you must set the appropriate Object Data Manager (ODM) attribute listed in the following table to the value shown, depending on the disk type:
|
Disk Type |
Attribute |
Value |
|
SSA or FAStT disks |
reserve_lock |
no |
|
ESS, EMC, HDS, CLARiiON, or MPIO-capable disks |
reserve_policy |
no_reserve |
3.6 修改属主及权限(2结点分别执行)
结点1
# chown oracle:dba /dev/htasm/asmdisk35
# chmod 660 /dev/htasm/asmdisk35
# chown oracle:dba /dev/htasm/asmdisk36
# chmod 660 /dev/htasm/asmdisk36
结点2
# chown oracle:dba /dev/htasm/asmdisk35
# chmod 660 /dev/htasm/asmdisk35
# chown oracle:dba /dev/htasm/asmdisk36
# chmod 660 /dev/htasm/asmdisk36
3.7 ASM添加磁盘：
登录asm 扩展磁盘组：
export ORACLE_SID=+ASM1
sqlplus / as sysdba
alter diskgroup DATADG add disk '/dev/htasm/asmdisk35';
alter diskgroup DATADG add disk '/dev/htasm/asmdisk36';
系统检查
1、 查看磁盘组使用情况
select group_number,name,total_mb,free_mb from v$asm_disk_stat;
2、 检查alert日志是否正常
4、注意事项
1、 修改磁盘组属性(reserve_lock/reserve_policy)
2、 同一块磁盘在不同结点，磁盘名称可能不同
3、 操作完成后检查ASM和数据库实例日志
4、 不要设置PVID
参考文档
《Oracle? Database Oracle Clusterware and Oracle Real Application Clusters
Installation Guide
10g Release 2 (10.2) for
AIX》