asm sample commands

  select name, redundancy
     from v$asm_template
     where system = 'Y'
     and group_number = (
         select group_number from v$asm_diskgroup where name = 'DATA'
     )
     order by name;
select group_number, name, type from v$asm_diskgroup;
select GROUP_NUMBER, FILE_NUMBER, TYPE, REDUNDANCY
     from v$asm_file
     where group_number = (
           select group_number from v$asm_diskgroup where name = 'DATA'
     );
 select MOUNT_STATUS,HEADER_STATUS,STATE,REDUNDANCY,FAILGROUP,PATH from v$asm_disk where group_number=2;

select * from v$asm_attribute
 select * from v$asm_file where group_number = 2
select * from v$asm_alias where group_NUMBER=2;
 select * from gv$asm_client;
SELECT name, compatibility, database_compatibility
     FROM v$asm_diskgroup;

########################################33
  CREATE DISKGROUP flex_data FLEX REDUNDANCY DISK my_disk_discovery_path;

 CREATE DISKGROUP normaltoflex NORMAL REDUNDANCY
  DISK '/devices/diskm*'
  ATTRIBUTE 'au_size'='4M',
    'compatible.asm' = '19.0', 
    'compatible.rdbms' = '19.0',
    'compatible.advm' = '19.0';
 
  ALTER DISKGROUP normaltoflex CONVERT REDUNDANCY TO FLEX;
 
 CREATE DISKGROUP data NORMAL REDUNDANCY
  FAILGROUP controller1 DISK
    '/devices/diska1' NAME diska1,
    '/devices/diska2' NAME diska2,
    '/devices/diska3' NAME diska3,
    '/devices/diska4' NAME diska4
  FAILGROUP controller2 DISK
    '/devices/diskb1' NAME diskb1,
    '/devices/diskb2' NAME diskb2,
    '/devices/diskb3' NAME diskb3,
    '/devices/diskb4' NAME diskb4
  ATTRIBUTE 'au_size'='4M',
    'compatible.asm' = '19.0', 
    'compatible.rdbms' = '19.0',
    'compatible.advm' = '19.0';

CREATE DISKGROUP mgmt_dg NORMAL REDUNDANCY
   FAILGROUP fg1 DISK '/devices/diskg1'
   FAILGROUP fg2 DISK '/devices/diskg2'
   QUORUM FAILGROUP fg3 DISK '/devices/diskg3'
   ATTRIBUTE 'compatible.asm' = '12.2.0.0.0';
 
 create diskgroup fgtest normal redundancy
  failgroup filer01 disk 'ORCL:FILER01DISKA', 'ORCL:FILER01DISKB'
  failgroup filer02 disk 'ORCL:FILER02DISKA', 'ORCL:FILER02DISKB'
  attribute 'compatible.asm'='11.1';

ALTER DISKGROUP data CHECK REPAIR;
    ALTER DISKGROUP data
       RESIZE DISK data1
       SIZE 300 G
       REBALANCE POWER 2;

   ALTER DISKGROUP sidDG1
       SET ATTRIBUTE 'compatible.rdbms' = '11.2';