oracle新增磁盘,oracle asm添加磁盘扩容

1.存储上面挂载lun

2.操作系统上面执行如下操作(不需重启操作系统)：

echo "- - -" > /sys/class/scsi_host/host0/scan

echo "- - -  > /sys/class/scsi_host/host1/scan

..........

一步操作完成：

echo "- - -  > /sys/class/scsi_host/host**/scan

3.编辑 /etc/multipath.conf

添加：

multipath {

wwid                  360002ac000000000000000dd00012d32

alias                 mpath1

}

multipath {

wwid                  360002ac0000000000000004000012d47

alias                 mpath2

}

重启multipath 服务或者reload

4.格式化磁盘：

fdisk /dev/mapper/mpath1

fdisk /dev/mapper/mpath1

partprobe /dev/mapper/mpath1

partprobe /dev/mapper/mpath2

5.asmlib绑定，或是使用其它的方式：

/etc/init.d/oracleasm createdisk ASMDISK1 /dev/mapper/mpath1p1

Marking disk "ASMDISK1" as an ASM disk:                   [  OK  ]

/etc/init.d/oracleasm createdisk ASMDISK2 /dev/mapper/mpath2p1

Marking disk "ASMDISK2" as an ASM disk:                   [  OK  ]

6.确认：

/etc/init.d/oracleasm scandisks

/etc/init.d/oracleasm listdisks

ASMDISK1

ASMDISK2

如果是rac，需要在其它的节点上执行scandisks即可：

partprobe /dev/mapper/mpath1

partprobe /dev/mapper/mpath2

/etc/init.d/oracleasm scandisks

Scanning the system for Oracle ASMLib disks:               [  OK  ]

/etc/init.d/oracleasm listdisks

ASMDISK1

ASMDISK2

6.使用asmca添加磁盘：

7.查看diskgroup数据平衡进度：

SQL> select * from v$asm_operation;

GROUP_NUMBER OPERA STAT      POWER     ACTUAL       SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE

------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------

1 REBAL RUN         1        1       30849    2067087      7140           285

2 REBAL WAIT      1