Oracle11gRAC asmlib扩容asm

一、查看磁盘(root用户下所有节点都要执行)

1. 查看主机总线号

ls /sys/class/scsi_host/

2. 重新扫描SCSI总线来添加设备

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

3. 查看磁盘信息，找到新加磁盘的wwid

fdisk -l | grep dev

#查看所有磁盘ID

fdisk -l|grep Disk|grep dev|grep mapper|grep -v VolGroup|awk '{print substr($2,1,length($2)-1)}'|xargs -n1 scsi_id --whitelist

二、设置多路径聚合(root用户下所有节点都要执行)

1. 配置多路径，添加多路径磁盘配置

vi /etc/multipath.conf 

#添加以下内容
#配置文件按照之前的格式，追加至下面就好，只修改wwid、alias

        multipath {
                uid 0
                gid 0
                wwid "360002ac000000000000001f600021b4d"
                alias   DATA61
                mode 0600
        }
        multipath {
                uid 0
                gid 0
                wwid "360002ac000000000000001f700021b4d"
                alias   DATA62
                mode 0600
        }
        multipath {
                uid 0
                gid 0
                wwid "360002ac000000000000001f800021b4d"
                alias   DATA63
                mode 0600
        }
        multipath {
                uid 0
                gid 0
                wwid "360002ac000000000000001f900021b4d"
                alias   DATA64
                mode 0600
        }
        multipath {
                uid 0
                gid 0
                wwid "360002ac000000000000001fa00021b4d"
                alias   DATA65
                mode 0600
        }
        multipath {
                uid 0
                gid 0
                wwid "360002ac000000000000001fb00021b4d"
                alias   DATA66
                mode 0600
        }

2.启动多路径软件

#service multipathd restart  

3.显示当前多路径状态

multipath -ll

三、asmlib绑定(root用户执行)

1. 查看已有asm磁盘

oracleasm listdisks

2. 创建新的磁盘

oracleasm createdisk DATA61 /dev/mapper/DATA61
oracleasm createdisk DATA62 /dev/mapper/DATA62
oracleasm createdisk DATA63 /dev/mapper/DATA63
oracleasm createdisk DATA64 /dev/mapper/DATA64
oracleasm createdisk DATA65 /dev/mapper/DATA65
oracleasm createdisk DATA66 /dev/mapper/DATA66

3. 其他节点扫描已添加磁盘

oracleasm scandisks

4. 参看已有磁盘

oracleasm listdisks

5. 查看磁盘信息

oracleasm querydisk -v -p DATA62

6. 查看磁盘号是否写入/proc/partitons

oracleasm querydisk -d DATA62
cat /proc/partitons

7. 扩容后查看ASM日志

/u01/app/grid/diag/asm/+asm/+ASM1/trace

8.查看磁盘状态

SQL>select name, path, state from  v$asm_disk order by name;

9. 查看平衡状态

SQL>select * from v$asm_operation;

10. 查看磁盘组状态

SQL>select state,name,type,total_mb, free_mb from v$asm_diskgroup_stat;

四、asm扩容(oracle用户下）

admca