ORACLE 11g R2 Rac向已有ASM组增加磁盘操作
配置要求说明:将/dev/sdb2 一个800G的区加入到ASM现有的DATA组
1、现有asm 磁盘和磁盘组查看
# oracleasm listdisks DISK1
SQL> select name from v$asm_diskgroup; NAME ------------------------------ DATA
su - grid
$ asmcmd
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 1228807 246184 0 246184 0 Y DATA/
2、创建ASM磁盘
# oracleasm createdisk DISK2 /dev/sdb2
Writing disk header: done
Instantiating disk: done
# oracleasm listdisks
DISK1
DISK2
在其他节点执行
# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "DISK2"
# oracleasm listdisks
DISK1
DISK2
# ll /dev/oracleasm/disks/
total 0
brw-rw---- 1 grid asmadmin 8, 17 Nov 1 17:09 DISK1
brw-rw---- 1 grid asmadmin 8, 18 Dec 23 17:06 DISK2
在rac1节点上执行
[root@rac1 mapper]# su - grid
[oracle@rac1 ~]$ export ORACLE_SID=+ASM1
[oracle@rac1 ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 23 17:14:55 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select name,path from v$asm_disk_stat;
NAME
------------------------------
PATH
--------------------------------------------------------------------------------
DISK1
ORCL:DISK1
SQL>alter diskgroup DATA add disk 'ORCL:DISK2' name DISK2;
SQL> conn /as sysasm
Connected.
SQL> alter diskgroup DATA add disk 'ORCL:DISK2' name DISK2;
Diskgroup altered.
3、验证:
SQL> select name,path from v$asm_disk_stat;
NAME
------------------------------
PATH
--------------------------------------------------------------------------------
DISK1
ORCL:DISK1
DISK2
ORCL:DISK2
$asmcmd
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 1945597 962966 0 962966 0 Y DATA/
DATA组空间大小已增加。
将磁盘增加到ASM组完成
原文链接:ORACLE 11g R2 Rac向已有ASM组增加磁盘操作,转载请注明来源!