Oracle11g 单实例+ASM磁盘组扩容

 一、给服务器增加一块硬盘（VMware方式添加）

二、查看磁盘ID并将磁盘分为四个分区(假设Sdo为新增加一块盘)

[root@node1 ~]#  /sbin/scsi_id -g -u /dev/sdo --CentOs6

三、在/etc/multipath.conf多路径配置文件中增加磁盘ID，配置别名

multipath {

wwid 36000c299c77f05847b9535abe59d505b

alias DATA5

path_grouping_policy multibus

path_selector "round-robin 0"

failback manual

rr_weight priorities

no_path_retry 5

}

四、重启多路径服务,激活多路径，重新加载多路径

1. [root@node1 ]# service multipathd restart
2. [root@node1 ]# multipath -F
3. [root@node1 ]# multipath -v2
4. [root@node1 ]# multipath -v3
5. [root@node1 ]# multipath -ll
6. [root@node1 ]# lsblk

五、使用Oracleasmlib创建共享磁盘

oracleasm createdisk ORA_DATA8 /dev/mapper/DATA5p1

oracleasm createdisk ORA_DATA9 /dev/mapper/DATA5p2

oracleasm createdisk ORA_DATA10 /dev/mapper/DATA5p3

oracleasm createdisk ORA_DATA11 /dev/mapper/DATA5p4

oracleasm scandisks --扫描磁盘,扫描出新增加的磁盘

oracleasm listdisks --列出已存在的磁盘

六、为新增加的磁盘添加磁盘权限和所有者,并添加到/etc/rc.local中

ll /dev/oracleasm/disks/ORA_DATA*

chown grid:dba /dev/oracleasm/disks/ORA_DATA8;chmod 660 /dev/oracleasm/disks/ORA_DATA8

chown grid:dba /dev/oracleasm/disks/ORA_DATA9;chmod 660 /dev/oracleasm/disks/ORA_DATA9

chown grid:dba /dev/oracleasm/disks/ORA_DATA10;chmod 660 /dev/oracleasm/disks/ORA_DATA10

chown grid:dba /dev/oracleasm/disks/ORA_DATA11;chmod 660 /dev/oracleasm/disks/ORA_DATA11

七、给数据库增加存储（SQL语句方式添加或图形化界面添加）

1. 修改磁盘组平衡度参数,参数值越大,存储平衡速度越快

alter diskgroup DATA rebalance power 10;

 2、修改磁盘组读取磁盘路径参数

alter system set asm_diskstring='/dev/oracleasm/disks/*' scope=spfile;

 3、使用SQL语句方式增加存储

  SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/ORA_DATA8' rebalance power 10;

  Diskgroup altered.

  SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/ORA_DATA9' rebalance power 10;

  Diskgroup altered.

  SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/ORA_DATA10' rebalance power 10;

  Diskgroup altered.

  SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/ORA_DATA11' rebalance power 10;

  Diskgroup altered.

4、查看试图,观察磁盘组存储平衡速度

SQL> select * from v$asm_operation ;

5、添加表空间数据文件,观察数据库是否有异常或报错无法添加