Oracle ASM操作管理__diskgroup_disk_ASM_failgroup_ORCL_

当前位置: 数据库>oracle

Oracle ASM操作管理

来源: 互联网发布时间：2017-05-27

本文导语: 查看ASM磁盘情况 SQL> select group_number,disk_number,mount_status,header_status,mode_status,state,failgroup,total_mb,free_mb,name,path from v$asm_disk; 查看ASM磁盘组情况SQL> select group_number,block_size,name,allocation_unit_size,state,type,total_mb,free_mb,offline_disks from v$asm_dis...

查看ASM磁盘情况

SQL> select group_number,disk_number,mount_status,header_status,mode_status,state,failgroup,total_mb,free_mb,name,path from v$asm_disk;

查看ASM磁盘组情况
SQL> select group_number,block_size,name,allocation_unit_size,state,type,total_mb,free_mb,offline_disks from v$asm_diskgroup;

创建ASM磁盘

[root@b1 RedHat 5.4-64]#

[root@b1 redhat 5.4-64]#

[root@b1 redhat 5.4-64]#
Device "/dev/sdb" is not marked as an ASM disk
Device "/dev/sdb1" is marked an ASM disk with the label "DISK1"
Device "/dev/sdb2" is marked an ASM disk with the label "DISK2"

[root@b1 redhat 5.4-64]#
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@b1 redhat 5.4-64]#
DISK1
DISK2

删除ASM磁盘

[root@b1 ~]#
Clearing disk header: done

创建ASM磁盘组

a、创建外包冗余磁盘组

create diskgroup dg1 external redundancy disk 'ORCL:disk3','ORCL:disk4';

b、创建普通冗余磁盘组（至少两块磁盘）

create diskgroup dg1 normal redundancy failgroup fg1 disk 'ORCL:disk3' failgroup fg2 disk 'ORCL:disk4';

c、创建高冗余磁盘组（至少三块磁盘）

create diskgroup dg1 high redundancy
failgroup fg1 disk 'ORCL:disk3' name dg1_a
failgroup fg2 disk 'ORCL:disk4' name dg1_b
failgroup fg3 disk 'ORCL:disk5' name dg1_c;

删除ASM磁盘组

drop diskgroup dg1;

drop diskgroup dg1 including contents;

向ASM磁盘组中增加磁盘

a、向高冗余磁盘组中添加磁盘成员

alter diskgroup dg1
add failgroup fg1 disk 'ORCL:diskd1'
add failgroup fg2 disk 'ORCL:diskd2'
add failgroup fg3 disk 'ORCL:diskd3';

b、向外部冗余磁盘组中添加磁盘成员

alter diskgroup dg2 add disk 'ORCL:diske2';

从ASM磁盘组中删除磁盘

alter diskgroup dg1 drop disk diskd1,diskd2,diskd3;

alter diskgroup dg2 drop disk diske2 add disk 'ORCL:DISKE3';

删除故障组（即删除故障组中的所有磁盘）