一、查看磁盘(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