2014-06-23-asm2.sql

botang

select  * from v$asm_disk;

select  * from v$asm_diskgroup;

select   d.path, g.name ,g.total_mb, g.free_mb,g.usable_file_mb
from v$asm_disk d , v$asm_diskgroup g
where d.group_number=g.group_number;

select  * from  v$asm_alias   where file_number=268  and group_number=1 ;
select   file_number, count(*)    from v$asm_alias    where group_number=1  group by file_number
  having count(*)  >1;
  
  alter diskgroup data add alias '+data/orcl/datafile/tbs05205_d.dbf' for '+DATA/orcl/datafile/tbs05205_d.268.851028831';
  
  select  * from v$asm_alias;
  
  select  * from v$asm_attribute;
  
  select  * from v$asm_template  where group_number=1;
  
  ALTER DISKGROUP DATA ADD TEMPLATE "MYTEMPLATE1" ATTRIBUTES (HIGH COARSE);
  
  
  ALTER DISKGROUP DATA ADD TEMPLATE "MYTEMPLATE2" ATTRIBUTES (UNPROTECTED COARSE)  ;
  
  
  select  * from v$asm_file;
  select    a.name , f.redundancy
    from v$asm_file  f  ,  v$asm_alias a
    where f.file_number=a.file_number and  f.group_number=1;