赞
踩
1 使用fdisk对磁盘进行分区,不做文件格式。
2 使用oracleasm createdisk创建ASM磁盘。
oracleasm createdisk DATA8 /dev/sdn1
3 使用oracleasm scandisks命令扫描磁盘,node1, node2 都要做。
4 查看磁盘状态
select a.GROUP_NUMBER,a.name,a.state,a.LABEL,a.PATH,b.NAME from v$asm_disk a,v$asm_diskgroup b where a.GROUP_NUMBER=b.GROUP_NUMBER(+
磁盘组编号 磁盘名称 磁盘状态 别名 磁盘路径 粗盘组名称
0 NORMAL /dev/oracleasm/disks/MGMT
0 NORMAL /dev/oracleasm/disks/DATA8
1 ARCH_0000 NORMAL ARCH /dev/oracleasm/disks/ARCH ARCH
2 DATA_0002 NORMAL OCR3 /dev/oracleasm/disks/OCR3 DATA
2 DATA_0000 NORMAL OCR1 /dev/oracleasm/disks/OCR1 DATA
2 DATA_0001 NORMAL OCR2 /dev/oracleasm/disks/OCR2 DATA
3 OGG_0000 NORMAL OGG /dev/oracleasm/disks/OGG OGG
4 ORADATA1_0002 NORMAL DATA7 /dev/oracleasm/disks/DATA7 ORADATA1
4 ORADATA1_0001 NORMAL DATA2 /dev/oracleasm/disks/DATA2 ORADATA1
4 ORADATA1_0000 NORMAL DATA1 /dev/oracleasm/disks/DATA1 ORADATA1
5 ORADATA2_0001 NORMAL DATA4 /dev/oracleasm/disks/DATA4 ORADATA2
5 ORADATA2_0000 NORMAL DATA3 /dev/oracleasm/disks/DATA3 ORADATA2
6 ORADATA3_0001 NORMAL DATA6 /dev/oracleasm/disks/DATA6 ORADATA3
6 ORADATA3_0000 NORMAL DATA5 /dev/oracleasm/disks/DATA5 ORADATA3
7 REDO_0000 NORMAL REDO /dev/oracleasm/disks/REDO REDO
5 添加磁盘
alter diskgroup oradata2 add disk '/dev/oracleasm/disks/DATA8' name ORADATA2_0002;
6 查看磁盘组状态
select name,state from v$asm_diskgroup;
7 查看重新平衡的状态
select * from v$asm_operation;
8 从新平衡的一些操作:
1 alter diskgroup dg rebalance;
2 alter diskgroup dg rebalance wait;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。