oracle rac的磁盘组添加磁盘扩容

asm添加磁盘

1：创建共享磁盘组
2:查看新的磁盘
fdisk -l
显示是/dev/sdi  8G

2：绑定设备
需要添加的为/dev/sdc,/dev/sdd 时,将脚本修改为 for i in c d 即可。这些sdi;

for i in i;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\",PROGRAM==\"/sbin/scsi_id -g -u /dev/\$name\", RESULT==\"`/sbin/scsi_id -g -u --device=/dev/sd$i`\", NAME=\"asm-disk$i\",OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\""  
done;

3：添加到rules

cd /etc/udev/rules.d

vi 99-oracle-asmdevices.rules

KERNEL=="sd*", BUS=="scsi",PROGRAM=="/sbin/scsi_id -g -u /dev/$name", RESULT=="1ATA_VBOX_HARDDISK_VB52c42b9d-57498589", NAME="asm-diski", OWNER="grid",GROUP="asmadmin", MODE="0660"

4：重启udev
[root@rac1 rules.d]# /sbin/start_udev
正在启动 udev：[确定]

5：查看新绑定的
[root@rac1 rules.d]#  ls -ltr /dev/asmi
brw-rw----. 1 grid asmadmin 8, 128 3月   1 15:59 /dev/asm-diski

6：查看asm磁盘组
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 1 16:06:29 2018
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 instance_name from v$instance;


INSTANCE_NAME
--------------------------------
+ASM2


SQL> set pagesize 1000 linesize 500
SQL> select GROUP_NUMBER,NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup;


GROUP_NUMBER NAME                                                           TOTAL_MB    FREE_MB
------------ ------------------------------------------------------------ ---------- ----------
           1 DATADG                                                            11264      10956




7：asmca添加磁盘asm-diski到datadg磁盘组

SQL> alter diskgroup datadg add disk '/dev/asm-diski';
Diskgroup altered.

8：核对可用空间

SQL> select GROUP_NUMBER,NAME,TOTAL_MB,FREE_MB from v$asm_diskgroup;


GROUP_NUMBER NAME                                                           TOTAL_MB    FREE_MB
------------ ------------------------------------------------------------ ---------- ----------
           1 DATADG                                                            19456      19146

添加成功。