创建ASM磁盘组

好费磁盘呀

select path,os_mb,mount_status,header_status,mode_status,state
from v$asm_disk;


删除TEST,查看

PROVISIONED：表示没有增加过磁盘组
FORMER：表示是磁盘组的一部分，但是已经被删除

创建外部冗余，需要一块磁盘
create diskgroup yikuai EXTERNAL REDUNDANCY
DISK ‘/dev/oracleasm/disks/ASM006’;

查看创建的磁盘组
select group_number, name,state,type,allocation_unit_size/(1024*1024)
,total_mb,free_mb,usable_file_mb from v$asm_diskgroup;

在增加几块新磁盘，在进行测试
select path,os_mb,mount_status,header_status,mode_status,state
from v$asm_disk
where header_status<>‘MEMBER’;

创建正常冗余，需要两块磁盘
create DISKGROUP zc NORMAL REDUNDANCY
DISK ‘/dev/oracleasm/disks/ASM007’
ATTRIBUTE ‘au_size’=‘4M’;
创建失败，是因为只使用了一块磁盘

创建成功

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

select path,os_mb,header_status,total_mb,free_mb,label,failgroup
from v$asm_disk
where group_number = 4

创建高冗余，需要6块磁盘
磁盘不够用了，继续加磁盘

create DISKGROUP grao high REDUNDANCY
FAILGROUP fg1 DISK ‘/dev/oracleasm/disks/ASM009’,’/dev/oracleasm/disks/ASM010’
FAILGROUP fg2 DISK ‘/dev/oracleasm/disks/ASM011’,’/dev/oracleasm/disks/ASM012’
FAILGROUP fg3 DISK ‘/dev/oracleasm/disks/ASM013’,’/dev/oracleasm/disks/ASM014’
ATTRIBUTE ‘au_size’=‘16M’,
‘compatible.asm’=‘12.1’,
‘compatible.rdbms’=‘11.2’;

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

select path,os_mb,header_status,total_mb,free_mb,label,failgroup
from v$asm_disk
where group_number = 5

查看兼容性
select group_number,name,compatibility,database_compatibility
from v$asm_diskgroup;

创建仲裁盘，用三块磁盘
select path,os_mb,mount_status,header_status,mode_status,state
from v$asm_disk
where header_status<>‘MEMBER’;

报错了，没指定

CREATE DISKGROUP zhongc NORMAL REDUNDANCY
FAILGROUP fg1 disk ‘/dev/oracleasm/disks/ASM015’
FAILGROUP fg2 disk ‘/dev/oracleasm/disks/ASM016’
QUORUM FAILGROUP fgq DISK ‘/dev/oracleasm/disks/ASM018’
ATTRIBUTE ‘compatible.asm’=‘12.1’,
‘compatible.rdbms’=‘12.1’;

select group_number,name,type,compatibility,database_compatibility
from v$asm_diskgroup;

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