ASM opeartions !

--1) we have 3 asm diskgroup : DATA,RECO ,REDO **GRP1 is DATA , GRP2 is REDO , GRP3 is RECO

select group_number,name,state from v$asm_diskgroup;

--2) To see the total disk group size / free size
select name, group_number, state, to_char(total_mb,'99,999,999') "TOTAL_MB",
to_char(free_mb,'99,999,999') "FREE_MB" from v$asm_diskgroup;

--3) How many disks in a diskgroup :

select * from v$asm_disk order by group_number --DATA has 20 disk , REDO has 4 disks , RECO has 20 disks

select group_number,name,path,DISK_NUMBER,OS_mb,total_mb,free_mb,state  from v$asm_disk order by group_number;


--4) To see any error on ASM :
select group_number, operation, state, error_code from v$asm_operation;

--5) To see FRA
select * from v$recovery_file_dest;

select * from v$flash_recovery_area_usage;


--6) To resize ASM DISK


 ALTER DISKGROUP 'DISKGROUP_NAME'  RESIZE DISK 'Name of DISK' SIZE 200G; //disk name got from v$asm_disk

For example ,

 SQL> ALTER DISKGROUP DATA  RESIZE DISK HDD_E0_S09_376018964P1 SIZE 200G;

--ALTER DISKGROUP DATA resize all;


####ASM Add Disk


--ALTER DISKGROUP DATA add disk '/dev/oracleasm/disks/DISK5' name DISK5;

select name,path from v$asm_disk;


DROP : ALTER DISKGROUP DATA drop disk '/dev/oracleasm/disks/DISK5'

UNDROP : ALTER DISKGROUP DATA undrop disks;

RESIZE : ALTER DISKGROUP DATA resize DISK%5 FILE_DISKB1;