add disk to asm操作步骤及注意事项

操作介绍

记录在AIX操作系统向ASM卷组中添加新磁盘的操作过程及注意事项。

环境介绍

操作系统： AIX 5.3

数据库版本： Oracle 10.2.0.5 2结点RAC

集群存储管理软件： ASM(自动存储管理)

操作过程

1.查看需要添加的磁盘

使用命令lspv查看磁盘信息

结点1

hdisk49 none None

hdisk50 none None

结点2

hdisk49 none None

hdisk50 none None

注：如果哪个结点未列出需要添加的磁盘，使用以下命令进行从新添加

# /usr/sbin/cfgmgr

2.检查磁盘对应关系(结点1hdisk49和结点2hdisk49可能不是同一块物理设备)

结点1hdisk49

root@htdb1:/dev/# lscfg -vpsl hdisk49

hdisk49 U789D.001.DQD4R9Y-P1-C1-T1-W50060E8005947628-L2F000000000000

XP Disk Array(Fibre)

Manufacturer................HP

Machine Type andModel......OPEN-V

Part Number.................

ROS Level andID............36303037

Serial Number...............5009476

EC Level....................

FRU Number..................

Device Specific.(Z0)........00000332CF000002

Device Specific.(Z1)........04813J....

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

结点1hdisk50

root@htdb1:/dev/# lscfg -vpsl hdisk50

hdisk50 U789D.001.DQD4R9Y-P1-C1-T1-W50060E8005947628-L30000000000000

XP Disk Array(Fibre)

Manufacturer................HP

Machine Type andModel......OPEN-V

Part Number.................

ROS Level andID............36303037

Serial Number...............5009476

EC Level....................

FRU Number..................

Device Specific.(Z0)........00000332CF000002

Device Specific.(Z1)........04823J....

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

结点2hdisk49

root@htdb2:/# lscfg -vl hdisk49

hdisk49 U78A0.001.DNWK5C4-P1-C4-T2-W50060E8005947628-L2F000000000000 XP MPIO Disk XP24000(Fibre)

Manufacturer................HP

Machine Type andModel......OPEN-V

Part Number.................

ROS Level andID............36303037

Serial Number...............5009476

EC Level....................

FRU Number..................

Device Specific.(Z0)........00000332CF000002

Device Specific.(Z1)........04813J....

Device Specific.(Z2).........

Device Specific.(Z3).........

Device Specific.(Z4)..........en

Device Specific.(Z5)........

Device Specific.(Z6)........

结点2hdisk50

root@htdb2:/# lscfg -vl hdisk50

hdisk50 U78A0.001.DNWK5C4-P1-C4-T2-W50060E8005947628-L30000000000000 XP MPIO Disk XP24000(Fibre)

Manufacturer................HP

Machine Type andModel......OPEN-V

Part Number.................

ROS Level andID............36303037

Serial Number...............5009476

EC Level....................

FRU Number..................

Device Specific.(Z0)........00000332CF000002

Device Specific.(Z1)........04823J....

Device Specific.(Z2).........

Device Specific.(Z3).........

Device Specific.(Z4)..........en

Device Specific.(Z5)........

Device Specific.(Z6)........

总结

• 结点1hdisk49 对应结点2hdisk49

• 结点1hdisk50 对应结点2hdisk50

3.查看磁盘主设备号和从设备号

结点1

root@htdb1:/dev/# ls -alF /dev/*hdisk49

brw-------1root system23,49Mar2211:03/dev/hdisk49

crw-------1root system23,49Mar2211:03/dev/rhdisk49

root@htdb1:/dev/# ls -alF /dev/*hdisk50

brw-------1root system23,50Mar2211:03/dev/hdisk50

crw-------1root system23,50Mar2211:03/dev/rhdisk50

结点2

root@htdb2:/dev/# ls -alF /dev/*hdisk49

brw-------1root system24,50Mar2117:19/dev/hdisk49

crw-------1root system24,50Mar2117:19/dev/rhdisk49

root@htdb2:/dev/# ls -alF /dev/*hdisk50

brw-------1root system24,49Mar2117:19/dev/hdisk50

crw-------1root system24,49Mar2117:19/dev/rhdisk50

/dev/rhdisk*代表字符设备，23/24代表设备major number(设备类型), 49/50 代表minor numbers(具体设备)。

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 rawdevice file.

5.修改磁盘属性(2结点分别执行)

/usr/sbin/chdev -l hdisk49 -a reserve_policy=no_reserve

/usr/sbin/chdev -l hdisk50 -a reserve_policy=no_reserve

To enablesimultaneous access to a disk device from multiple nodes, you must set theappropriate Object Data Manager (ODM) attribute listed in the following tableto the value shown, depending on the disk type:

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

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';

系统检查

• 查看磁盘组使用情况

select group_number,name,total_mb,free_mb fromv$asm_disk_stat;

• 检查alert日志是否正常

注意事项

• 修改磁盘组属性（reserve_lock/reserve_policy）

• 同一块磁盘在不同结点，磁盘名称可能不同
  

• 操作完成后检查ASM和数据库实例日志

• 不要设置PVID

参考文档

《Oracle?Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide10g Release 2(10.2) for AIX》

《Assigninga Physical Volume ID(PVID) To An Existing ASM Disk Corrupts the ASM DiskHeader(Doc ID 353761.1)》