AIX Oracle ASM扩容
原创
1. 客户一套基于AIX系统的Oracle数据库的ASM空间不足，需要进行扩容，目前ASM磁盘组容量如下：
bash-4.4$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 460800 111798 0 111798 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 1146880 609882 0 609882 0 N FRA/
MOUNTED NORMAL N 512 4096 1048576 15360 14434 5120 4657 0 Y OCR/2. 查看ASM磁盘的路径
SQL> select path from v$asm_disk;
PATH
--------------------------------------------------------------------------------
/dev/rhdiskpower3
/dev/rhdiskpower4
/dev/rhdiskpower5
/dev/rhdiskpower1
/dev/rhdiskpower23. 查看存储映射到服务器的磁盘
# ls -l /dev/hdiskp*
brw-rw---- 1 root system 43, 0 Dec 21 2018 /dev/hdiskpower0
brw-rw---- 1 root system 43, 1 Sep 05 2018 /dev/hdiskpower1
brw-rw---- 1 root system 43, 2 Sep 05 2018 /dev/hdiskpower2
brw-rw---- 1 root system 43, 3 Sep 05 2018 /dev/hdiskpower3
brw-rw---- 1 root system 43, 4 Sep 05 2018 /dev/hdiskpower4
brw-rw---- 1 root system 43, 5 Sep 05 2018 /dev/hdiskpower5
brw-rw---- 1 root system 43, 6 Jun 18 20:07 /dev/hdiskpower6
brw-rw---- 1 root system 43, 7 Jul 02 21:44 /dev/hdiskpower7
brw-rw---- 1 root system 43, 8 Jul 02 22:40 /dev/hdiskpower8 <<<<<<<4. 给映射过来的磁盘创建名为data2的设备，具体需要创建的设备名称参考以前data组的磁盘名称
mknod data2 c 43 85. 对设备进行授权
# chown -R grid:asmadmin /dev/rhdiskpower8
# chmod -R 775 /dev/rhdiskpower8
#
# chown -R grid:asmadmin /dev/data2
# chmod -R 775 /dev/data26. 查看标记磁盘的状态
SQL> select header_status,path from v$asm_disk;
HEADER_STATU PATH
------------ --------------------------------------------------
MEMBER /dev/rhdiskpower3
MEMBER /dev/rhdiskpower4
MEMBER /dev/rhdiskpower5
CANDIDATE /dev/rhdiskpower8
MEMBER /dev/rhdiskpower1
MEMBER /dev/rhdiskpower2
6 rows selected.7. 给data磁盘添加新增的磁盘
SQL> alter diskgroup DATA add disk '/dev/rhdiskpower8';
alter diskgroup DATA add disk '/dev/rhdiskpower8'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15075: disk(s) are not visible cluster-wide8. 根据ORA-15075的错误提示，检查了两个节点上的磁盘挂载情况、权限、属组都完全正常。因为是操作系统是AIX，查看《Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for AIX》手册，手册上描述如下：
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, FAStT, or non-MPIO-capable disks | reserve_lock | no |
ESS, EMC, HDS, CLARiiON, or MPIO-capabledisks | reserve_policy | no_reserve |
To determine whether the attribute has the correct value, enter a command similar to the following on all cluster nodes for each disk device that you want to use: # /usr/sbin/lsattr -E -l hdiskn If the required attribute is not set to the correct value on any node, then enter a command similar to one of the following on that node:
- SSA and FAStT devices # /usr/sbin/chdev -l hdiskn -a reserve_lock=no
- ESS, EMC, HDS, CLARiiON, and MPIO-capable devices # /usr/sbin/chdev -l hdiskn -a reserve_policy=no_reserve
9. 对比以前ASM磁盘的属性和新增ASM磁盘的属性
# lsattr -E -l hdiskpower8
PR_key_value none Reserve Key. True
clr_q yes Clear Queue (RS/6000) True
location Location True
lun_id 0x8000000000000 LUN ID False
lun_reset_spt yes FC Forced Open LUN True
max_coalesce 0x100000 Maximum coalesce size True
max_retries 5 Maximum Retries True
max_transfer 0x100000 Maximum transfer size True
pvid none Physical volume identifier False
pvid_takeover yes Takeover PVIDs from hdisks True
q_err no Use QERR bit True
q_type simple Queue TYPE False
queue_depth 32 Queue DEPTH True
reassign_to 120 REASSIGN time out value True
reserve_policy single_path <<<<< Reserve Policy used to reserve device on open. True
reset_delay 0 Reset Delay True
rw_timeout 30 READ/WRITE time out True
scsi_id 0x10900 SCSI ID False
start_timeout 60 START unit time out True
ww_name 0x50001442d02e1801 World Wide Name False
# lsattr -E -l hdiskpower3
PR_key_value none Reserve Key. True
clr_q yes Clear Queue (RS/6000) True
location Location True
lun_id 0x3000000000000 LUN ID False
lun_reset_spt yes FC Forced Open LUN True
max_coalesce 0x100000 Maximum coalesce size True
max_retries 5 Maximum Retries True
max_transfer 0x100000 Maximum transfer size True
pvid none Physical volume identifier False
pvid_takeover yes Takeover PVIDs from hdisks True
q_err no Use QERR bit True
q_type simple Queue TYPE False
queue_depth 32 Queue DEPTH True
reassign_to 120 REASSIGN time out value True
reserve_policy no_reserve <<<<<< Reserve Policy used to reserve device on open. True
reset_delay 0 Reset Delay True
rw_timeout 30 READ/WRITE time out True
scsi_id 0x10900 SCSI ID False
start_timeout 60 START unit time out True
ww_name 0x50001442d02e1801 World Wide Name False10. 修改reserve_policy
bash-4.4# /usr/sbin/chdev -l hdiskpower8 -a reserve_policy=no_reserve
hdiskpower8 changed11. 再次向DATA磁盘组添加磁盘
SQL> alter diskgroup DATA add disk '/dev/rhdiskpower8';
Diskgroup altered.12. 检查磁盘组容量
bash-4.4$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN Y 512 4096 1048576 921600 572592 0 572592 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 1146880 608464 0 608464 0 N FRA/
MOUNTED NORMAL N 512 4096 1048576 15360 14434 5120 4657 0 Y OCR/原创声明：本文系作者授权腾讯云开发者社区发表，未经许可，不得转载。
如有侵权，请联系 cloudcommunity@tencent.com 删除。
原创声明：本文系作者授权腾讯云开发者社区发表，未经许可，不得转载。
如有侵权，请联系 cloudcommunity@tencent.com 删除。
评论
登录后参与评论
推荐阅读
目录