直接修改lun的大小,证明可行!
以下是我在11G RAC系统做的一个在存储中修改lun的大小来提升asm磁盘组的容量.
1,停止所有rac系统相关节点后,在存储里修改lun大小。
2,重启各节点或者安装sg3_utils扫描也可以重新识别扩容的磁盘;
[root@oadb02 ~]# fdisk -l
磁盘 /dev/sda:599.9 GB, 599932844032 字节,1171743836 个扇区
Units = 扇区 of 1 * 512 = 512 bytes
扇区大小(逻辑/物理):512 字节 / 512 字节
I/O 大小(最小/最佳):512 字节 / 512 字节
磁盘标签类型:dos
磁盘标识符:0x000d969c
设备 Boot Start End Blocks Id System
/dev/sda1 * 2048 1026047 512000 83 Linux
/dev/sda2 1026048 172998655 85986304 8e Linux LVM
磁盘 /dev/sdb:1073 MB, 1073741824 字节,2097152 个扇区
Units = 扇区 of 1 * 512 = 512 bytes
扇区大小(逻辑/物理):512 字节 / 512 字节
I/O 大小(最小/最佳):65536 字节 / 65536 字节
。。。。。
磁盘 /dev/mapper/mpathf:1159.6 GB, 1159641169920 字节,2264924160 个扇区
Units = 扇区 of 1 * 512 = 512 bytes
扇区大小(逻辑/物理):512 字节 / 512 字节
I/O 大小(最小/最佳):65536 字节 / 65536 字节
磁盘 /dev/mapper/mpathd:1159.6 GB, 1159641169920 字节,2264924160 个扇区
Units = 扇区 of 1 * 512 = 512 bytes
扇区大小(逻辑/物理):512 字节 / 512 字节
I/O 大小(最小/最佳):65536 字节 / 65536 字节
[grid@oadb01 ~]$sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 15 16:19:48 2019
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,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DATA 552960 482893
OCR 3072 2146
比较遗憾asm磁盘组没有认出来扩容的磁盘。
3,在线修改asm磁盘组
SQL> select group_number,type,state,type,total_mb,free_mb from v$asm_diskgroup_stat;
GROUP_NUMBER TYPE STATE TYPE TOTAL_MB FREE_MB
------------ ------ ----------- ------ ---------- ----------
1 EXTERN MOUNTED EXTERN 552960 482888
2 NORMAL MOUNTED NORMAL 3072 2146
SQL> select GROUP_NUMBER,path,NAME,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE from v$asm_disk_stat where NAME is not null;
GROUP_NUMBER PATH NAME MOUNT_S HEADER_STATU MODE_ST STATE
------------ --------------------------------------------- ------------------------------ ------- ------------ ------- --------
1 /dev/asm-disk5 DATA_001 CACHED MEMBER ONLINE NORMAL
2 /dev/asm-disk4 OCR_0002 CACHED MEMBER ONLINE NORMAL
2 /dev/asm-disk3 OCR_0001 CACHED MEMBER ONLINE NORMAL
1 /dev/asm-disk6 DATA_002 CACHED MEMBER ONLINE NORMAL
1 /dev/asm-disk7 DATA_003 CACHED MEMBER ONLINE NORMAL
2 /dev/asm-disk2 OCR_0000 CACHED MEMBER ONLINE NORMAL
-----SQL> ALTER DISKGROUP RESIZE DISK M REBALANCE POWER <1-11>;----
SQL> ALTER DISKGROUP DATA RESIZE DISK DATA_001 SIZE 1080G REBALANCE POWER 11;
Diskgroup altered.
SQL> ALTER DISKGROUP DATA RESIZE DISK DATA_002 SIZE 1080G REBALANCE POWER 11
Diskgroup altered.
SQL> ALTER DISKGROUP DATA RESIZE DISK DATA_003 SIZE 1080G REBALANCE POWER 11
Diskgroup altered.
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DATA 3317760 3247688
OCR 3072 2146
[root@oadb01 ~]# /u01/app/11.2.0/grid/bin/crsctl stop/start cluster -all
[grid@oadb01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE oadb01
ora....ER.lsnr ora....er.type ONLINE ONLINE oadb01
ora....N1.lsnr ora....er.type ONLINE ONLINE oadb02
ora.OCR.dg ora....up.type ONLINE ONLINE oadb01
ora.asm ora.asm.type ONLINE ONLINE oadb01
ora.cvu ora.cvu.type ONLINE ONLINE oadb01
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora.muscdb.db ora....se.type ONLINE ONLINE oadb02
ora....network ora....rk.type ONLINE ONLINE oadb01
ora....SM1.asm application ONLINE ONLINE oadb01
ora....01.lsnr application ONLINE ONLINE oadb01
ora.oadb01.gsd application OFFLINE OFFLINE
ora.oadb01.ons application ONLINE ONLINE oadb01
ora.oadb01.vip ora....t1.type ONLINE ONLINE oadb01
ora....SM2.asm application ONLINE ONLINE oadb02
ora....02.lsnr application ONLINE ONLINE oadb02
ora.oadb02.gsd application OFFLINE OFFLINE
ora.oadb02.ons application ONLINE ONLINE oadb02
ora.oadb02.vip ora....t1.type ONLINE ONLINE oadb02
ora.oc4j ora.oc4j.type ONLINE ONLINE oadb01
ora.ons ora.ons.type ONLINE ONLINE oadb01
ora.scan1.vip ora....ip.type ONLINE ONLINE oadb02
----业务测试正常!