好费磁盘呀 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
