add disk to asm on aix操作步骤及注意事项-orastar

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》

《Assigning a Physical Volume ID(PVID) To An Existing ASM Disk Corrupts the ASM Disk Header(Doc ID 353761.1)》

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31442014/viewspace-2140212/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31442014/viewspace-2140212/