本文主要是介绍AIX小机环境如何给ASM添加磁盘，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
前面几篇介绍了HPUX,Solaris平台上RAC集群ASM如何添加磁盘的 ，三大UNIX平台只差AIX，本文介绍AIX平台RAC 添加ASM磁盘
environment：
AIX 6.1 + oracle 10.0.2.4
2 nodes RAC (storage HP-6100 FC disk)
1. 存储划盘，并将盘赋予集群两个节点主机
2. 主机上发现新建磁盘
sfc3rac2:/# lspv --show physical volumehdisk0 00c8cb525e033ad7 rootvg activehdisk1 00c8ce2214eb01b4 rootvg activehdisk2 none Nonehdisk3 none Nonehdisk4 none Nonehdisk5 none Nonehdisk6 none Nonehdisk7 none Nonehdisk8 none Nonehdisk9 none Nonesfc3rac2:/# cfgmgr --find the new diskcfgmgr: 0514-621 WARNING: The following device packages are required fordevice support but are not currently installed.devices.fcp.arraydevices.fcp.changersfc3rac2:/# lspvhdisk0 00c8cb525e033ad7 rootvg activehdisk1 00c8ce2214eb01b4 rootvg activehdisk2 none Nonehdisk3 none Nonehdisk4 none Nonehdisk5 none Nonehdisk6 none Nonehdisk7 none Nonehdisk8 none Nonehdisk9 none Nonehdisk10 none None -- new disksfc3rac2:/#sfc3rac2:/# lsattr -El hdisk10PCM PCM/friend/hsvpcm Path Control Module FalsePR_key_value none Persistant Reserve Key Value Truealgorithm fail_over Algorithm Truehcheck_cmd test_unit_rdy Health Check Command Truehcheck_interval 60 Health Check Interval Truehcheck_mode nonactive Health Check Mode Truelocation Location Label Truelun_id 0x9000000000000 Logical Unit Number ID Falselun_reset_spt yes SCSI LUN reset Truemax_transfer 0x40000 Maximum TRANSFER Size Truenode_name 0x50001fe1500e5610 FC Node Name Falsepvid none Physical volume identifier Falseq_type simple Queuing TYPE Truequeue_depth 8 Queue DEPTH Truereserve_policy single_path Reserve Policy Truerw_timeout 60 READ/WRITE time out value Truescsi_id 0x10000 SCSI ID Falseunique_id 34213600508B40006D4B2000100000034000006HSV20002HPfcp Unique device identifier False --checkww_name 0x50001fe1500e561c FC World Wide Name Falsesfc3rac2:/#
3. 修改磁盘属性
ls -l /dev/rhdisk*chown oracle:dba /dev/rhdisk10chmod 660 /dev/rhdisk10ls -l /dev/rhdisk*lsattr -El hdisk10chdev -l hdisk10 -a reserve_policy=no_reservelsattr -El hdisk10sfc3rac2:/# ls -l /dev/rhdisk*crw------- 1 root system 24, 0 Aug 24 2009 /dev/rhdisk0crw------- 2 root system 24, 1 Aug 24 2009 /dev/rhdisk1crw------- 1 root system 24, 10 Dec 30 09:08 /dev/rhdisk10crw-r----- 1 root oinstall 24, 2 Dec 30 09:12 /dev/rhdisk2crw-r--r-- 1 oracle oinstall 24, 3 Dec 30 09:12 /dev/rhdisk3crw-rw---- 1 oracle dba 24, 4 Dec 30 09:12 /dev/rhdisk4crw-rw---- 1 oracle dba 24, 5 Dec 30 08:26 /dev/rhdisk5crw-rw---- 1 oracle dba 24, 6 Dec 30 09:12 /dev/rhdisk6crw-rw---- 1 oracle dba 24, 7 Dec 30 08:26 /dev/rhdisk7crw-rw---- 1 oracle dba 24, 8 Dec 30 08:25 /dev/rhdisk8crw-rw---- 1 oracle dba 24, 9 Dec 30 08:29 /dev/rhdisk9sfc3rac2:/#sfc3rac2:/#sfc3rac2:/# chown oracle:dba /dev/rhdisk10 --change ownersfc3rac2:/# chmod 660 /dev/rhdisk10 --change modesfc3rac2:/# ls -l /dev/rhdisk*crw------- 1 root system 24, 0 Aug 24 2009 /dev/rhdisk0crw------- 2 root system 24, 1 Aug 24 2009 /dev/rhdisk1crw-rw---- 1 oracle dba 24, 10 Dec 30 09:08 /dev/rhdisk10 --checkcrw-r----- 1 root oinstall 24, 2 Dec 30 09:13 /dev/rhdisk2crw-r--r-- 1 oracle oinstall 24, 3 Dec 30 09:13 /dev/rhdisk3crw-rw---- 1 oracle dba 24, 4 Dec 30 09:13 /dev/rhdisk4crw-rw---- 1 oracle dba 24, 5 Dec 30 08:26 /dev/rhdisk5crw-rw---- 1 oracle dba 24, 6 Dec 30 09:13 /dev/rhdisk6crw-rw---- 1 oracle dba 24, 7 Dec 30 08:26 /dev/rhdisk7crw-rw---- 1 oracle dba 24, 8 Dec 30 08:25 /dev/rhdisk8crw-rw---- 1 oracle dba 24, 9 Dec 30 08:29 /dev/rhdisk9sfc3rac2:/#sfc3rac2:/# lsattr -El hdisk10PCM PCM/friend/hsvpcm Path Control Module FalsePR_key_value none Persistant Reserve Key Value Truealgorithm fail_over Algorithm Truehcheck_cmd test_unit_rdy Health Check Command Truehcheck_interval 60 Health Check Interval Truehcheck_mode nonactive Health Check Mode Truelocation Location Label Truelun_id 0x9000000000000 Logical Unit Number ID Falselun_reset_spt yes SCSI LUN reset Truemax_transfer 0x40000 Maximum TRANSFER Size Truenode_name 0x50001fe1500e5610 FC Node Name Falsepvid none Physical volume identifier Falseq_type simple Queuing TYPE Truequeue_depth 8 Queue DEPTH Truereserve_policy single_path Reserve Policy Truerw_timeout 60 READ/WRITE time out value Truescsi_id 0x10000 SCSI ID Falseunique_id 34213600508B40006D4B2000100000034000006HSV20002HPfcp Unique device identifier Falseww_name 0x50001fe1500e561c FC World Wide Name Falsesfc3rac2:/# chdev -l hdisk10 -a reserve_policy=no_reserve --change disk parameterhdisk10 changedsfc3rac2:/# lsattr -El hdisk10PCM PCM/friend/hsvpcm Path Control Module FalsePR_key_value none Persistant Reserve Key Value Truealgorithm fail_over Algorithm Truehcheck_cmd test_unit_rdy Health Check Command Truehcheck_interval 60 Health Check Interval Truehcheck_mode nonactive Health Check Mode Truelocation Location Label Truelun_id 0x9000000000000 Logical Unit Number ID Falselun_reset_spt yes SCSI LUN reset Truemax_transfer 0x40000 Maximum TRANSFER Size Truenode_name 0x50001fe1500e5610 FC Node Name Falsepvid none Physical volume identifier Falseq_type simple Queuing TYPE Truequeue_depth 8 Queue DEPTH Truereserve_policy no_reserve Reserve Policy True --changedrw_timeout 60 READ/WRITE time out value Truescsi_id 0x10000 SCSI ID Falseunique_id 34213600508B40006D4B2000100000034000006HSV20002HPfcp Unique device identifier Falseww_name 0x50001fe1500e561c FC World Wide Name Falsesfc3rac2:/#
4. 将磁盘加入磁盘组
column name format a20select name,state,type,total_mb,free_mb,unbalanced from v$asm_diskgroup;select name,path,total_mb,free_mb,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS from v$asm_disk order by 1,2;idle> select name,state,type,total_mb,free_mb,unbalanced from v$asm_diskgroup;NAME STATE TYPE TOTAL_MB FREE_MB UN-------------------- ---------------------- ---------- ---------- ---------- --SFC3DB_ARCH MOUNTED EXTERN 102400 91832 NSFC3DB_DATA MOUNTED EXTERN 512000 63954 Nidle> select name,path,total_mb,free_mb,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS from v$asm_disk order by 1,2;NAME PATH TOTAL_MB FREE_MB MOUNT_STATUS HEADER_STATUS MODE_STATUS-------------------- ------------------------------ ---------- ---------- -------------- ------------------------ --------------SFC3DB_ARCH_0000 /dev/rhdisk6 102400 91832 CACHED MEMBER ONLINESFC3DB_DATA_0000 /dev/rhdisk4 102400 12789 CACHED MEMBER ONLINESFC3DB_DATA_0001 /dev/rhdisk5 102400 12790 CACHED MEMBER ONLINESFC3DB_DATA_0002 /dev/rhdisk7 102400 12789 CACHED MEMBER ONLINESFC3DB_DATA_0003 /dev/rhdisk8 102400 12794 CACHED MEMBER ONLINESFC3DB_DATA_0004 /dev/rhdisk9 102400 12792 CACHED MEMBER ONLINE/dev/rhdisk10 102400 0 CLOSED CANDIDATE ONLINE ---check new disk in ASM/dev/rhdisk3 1024 0 CLOSED FOREIGN ONLINE8 rows selected.
alter diskgroup SFC3DB_DATA add disk '/dev/rhdisk10';alter diskgroup SFC3DB_DATA rebalance power 11;select * from v$asm_operation;select name,total_mb,free_mb,unbalanced from v$asm_diskgroup;select group_number,name,path,total_mb,free_mb from v$asm_disk order by group_number,name;select group_number,name,path,total_mb,free_mb,header_status from v$asm_disk;idle>alter diskgroup SFC3DB_DATA add disk '/dev/rhdisk10'; --add new disk to diskgroupDiskgroup altered.idle> select * from v$asm_operation;GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES------------ --------------- ------------ ---------- ---------- ---------- ---------- ---------- -----------4 REBAL RUN 1 1 405 40176 1620 24idle> select name,total_mb,free_mb,unbalanced from v$asm_diskgroup;NAME TOTAL_MB FREE_MB UN-------------------- ---------- ---------- --SFC3DB_ARCH 102400 91832 NSFC3DB_DATA 614400 166352 Nidle> select group_number,name,path,total_mb,free_mb from v$asm_disk order by group_number;GROUP_NUMBER NAME PATH TOTAL_MB FREE_MB------------ -------------------- ------------------------------ ---------- ----------0 /dev/rhdisk3 1024 01 SFC3DB_ARCH_0000 /dev/rhdisk6 102400 918322 SFC3DB_DATA_0005 /dev/rhdisk10 102400 886512 SFC3DB_DATA_0004 /dev/rhdisk9 102400 155412 SFC3DB_DATA_0002 /dev/rhdisk7 102400 155382 SFC3DB_DATA_0003 /dev/rhdisk8 102400 155442 SFC3DB_DATA_0000 /dev/rhdisk4 102400 155392 SFC3DB_DATA_0001 /dev/rhdisk5 102400 155397 rows selected.idle> alter diskgroup SFC3DB_DATA rebalance power 11; ---rebalance diskgroupDiskgroup altered.idle> select * from v$asm_operation;no rows selectedidle> select group_number,name,path,total_mb,free_mb from v$asm_disk order by group_number;GROUP_NUMBER NAME PATH TOTAL_MB FREE_MB------------ -------------------- ------------------------------ ---------- ----------0 /dev/rhdisk3 1024 01 SFC3DB_ARCH_0000 /dev/rhdisk6 102400 918322 SFC3DB_DATA_0005 /dev/rhdisk10 102400 859362 SFC3DB_DATA_0004 /dev/rhdisk9 102400 160852 SFC3DB_DATA_0002 /dev/rhdisk7 102400 160812 SFC3DB_DATA_0003 /dev/rhdisk8 102400 160872 SFC3DB_DATA_0000 /dev/rhdisk4 102400 160812 SFC3DB_DATA_0001 /dev/rhdisk5 102400 160828 rows selected.idle> / --rebalance okGROUP_NUMBER NAME PATH TOTAL_MB FREE_MB------------ -------------------- ------------------------------ ---------- ----------0 /dev/rhdisk3 1024 01 SFC3DB_ARCH_0000 /dev/rhdisk6 102400 918322 SFC3DB_DATA_0005 /dev/rhdisk10 102400 277252 SFC3DB_DATA_0004 /dev/rhdisk9 102400 277262 SFC3DB_DATA_0002 /dev/rhdisk7 102400 277262 SFC3DB_DATA_0003 /dev/rhdisk8 102400 277252 SFC3DB_DATA_0000 /dev/rhdisk4 102400 277252 SFC3DB_DATA_0001 /dev/rhdisk5 102400 277258 rows selected.idle>
对比HPUX和Solaris，我认为在管理上AIX更便捷简单，最难的是HPUX，特别是HPUX平台的JFS文件系统；Solaris下的ZFS系统相对来说还是比较好用的。虽然三大小机平台已经越来越少了，但是在一些领域（半导体，航司，轨道交通，银行等）它们仍然在默默支撑着核心系统，稳定，高效，昂贵是它们的标签。
-------------历史文章推荐----------------
达梦暴涨，国产数据库的春天到了吗？
ORACLE RAC的一些基本理论知识
传统制造型企业数据库选型之困
利用ASM功能实现Oracle RAC零停机存储迁移
查询rownum伪列引起的sql性能问题分析
这篇关于AIX小机环境如何给ASM添加磁盘的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
