增加ASM磁盘

查看新创建的磁盘
select path,os_mb,mount_status,header_status,mode_status,state
from v$asm_disk
where header_status<>‘MEMBER’;

外部冗余增加磁盘

select group_number, name,state,type,allocation_unit_size/(1024*1024)
,total_mb,free_mb,usable_file_mb from v$asm_diskgroup;

select path,total_mb,free_mb,state,failgroup,failgroup_type
from v$asm_disk
where group_number = 1

select * from gv$asm_estimate;

explain work
set statement_id = ‘add disk to data’
for alter diskgroup data
add disk ‘/dev/oracleasm/disks/ASM019’;

select * from gv$asm_estimate;

alter diskgroup data
add disk ‘/dev/oracleasm/disks/ASM019’;


查看增加的磁盘


给高冗余增加磁盘

select group_number, name,state,type,allocation_unit_size/(1024*1024)
,total_mb,free_mb,usable_file_mb from v$asm_diskgroup
where group_number = 3;

select path,total_mb,free_mb,state,failgroup,failgroup_type
from v$asm_disk
where group_number = 3

alter DISKGROUP grao add
FAILGROUP fg4 DISK ‘/dev/oracleasm/disks/ASM022’,
‘/dev/oracleasm/disks/ASM023’;


查看新增加的磁盘


给仲裁磁盘组增加磁盘

select group_number, name,state,type,allocation_unit_size/(1024*1024)
,total_mb,free_mb,usable_file_mb from v$asm_diskgroup
where group_number = 6;

select path,total_mb,free_mb,state,failgroup,failgroup_type
from v$asm_disk
where group_number = 6

ALTER DISKGROUP zhongc ADD
regular failgroup fg1 disk ‘/dev/oracleasm/disks/ASM020’
regular failgroup fg2 disk ‘/dev/oracleasm/disks/ASM024’
quorum failgroup fgq disk ‘/dev/oracleasm/disks/ASM005’
rebalance power 5 nowait;


查看增加的磁盘