2014-06-25-asm.sql

botang

select  * from v$asm_disk;

select  * from v$asm_diskgroup;

select  * from v$asm_template  where group_number=3;

alter diskgroup  mygroup add template mytemplate3 attributes (mirror coarse);

alter diskgroup  mygroup add template mytemplate4 attributes (Unprotected coarse);


drop diskgroup mygroup;

alter diskgroup  fra add template mytemplate4 attributes (high coarse);

drop diskgroup mygroup;

alter diskgroup  fra add template mytemplate4 attributes ( Unprotected fine);

select  * from v$asm_disk;

select  failgroup, name from v$asm_disk;