ASM Commands

ALTER DISKGROUP DATA ADD DISK 
'/dev/mapper/asm10',
'/dev/mapper/asm11',
'/dev/mapper/asm12',
'/dev/mapper/asm13',
'/dev/mapper/asm14',
'/dev/mapper/asm15',
'/dev/mapper/asm16',
'/dev/mapper/asm17'
rebalance power 11;

/db/db050/oracle/DOELO01/cmx_data.df39.dbf


sqlplus / as sysasm

col path for a20
select name,path,total_mb,free_mb from v$asm_disk order by path ;
select name,path,total_mb,free_mb from v$asm_disk order by name ;
select name,path,total_mb,free_mb from v$asm_disk where name is null order by path ;
col path for a20
select name,path,total_mb,free_mb from v$asm_disk order by name ;
SELECT name, trunc(free_mb), trunc(total_mb), trunc(free_mb/total_mb*100) as free_percentage FROM v$asm_diskgroup;

SELECT name, trunc(free_mb/1024) as free_gb, trunc(total_mb/1024) as total_gb, trunc(free_mb/total_mb*100) as percentage FROM v$asm_diskgroup;

col path for a20
select name,path,total_mb,free_mb from v$asm_disk order by name ;

select name,path,total_mb,free_mb from v$asm_disk where name is null order by path;


EXEC DBMS_UTILITY.compile_schema(schema => 'ELODBA02');

asmcmd>lsdg

 select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION


ALTER DISKGROUP DATA ADD DISK 
'/dev/mapper/asm237',
'/dev/mapper/asm238',
'/dev/mapper/asm239',
'/dev/mapper/asm240',
'/dev/mapper/asm241',
'/dev/mapper/asm242',
'/dev/mapper/asm243',
'/dev/mapper/asm244',
'/dev/mapper/asm245',
'/dev/mapper/asm277',
'/dev/mapper/asm278',
'/dev/mapper/asm279',
'/dev/mapper/asm280'
rebalance power 24;

select inst_id,count(1) from gv$asm_Disk where header_Status!='MEMBER' group by inst_id order by 1 ;

alter diskgroup DATA1 drop disk DATA1_0221, DATA1_0222,DATA1_0223,DATA1_0224,DATA1_0225,DATA1_0226,DATA1_0227,DATA1_0228,DATA1_0229,DATA1_0230,DATA1_0231 rebalance power 11;

select group_number, operation, state, est_minutes from v$asm_operation;


ALTER DISKGROUP DATA ADD DISK 
'/dev/mapper/asm370',
'/dev/mapper/asm371',
'/dev/mapper/asm372',
'/dev/mapper/asm373',
'/dev/mapper/asm374',
'/dev/mapper/asm375',
'/dev/mapper/asm376',
'/dev/mapper/asm377',
'/dev/mapper/asm378',
'/dev/mapper/asm379',
'/dev/mapper/asm380',
'/dev/mapper/asm381',
'/dev/mapper/asm382',
'/dev/mapper/asm383',
'/dev/mapper/asm384',
'/dev/mapper/asm385',
'/dev/mapper/asm386',
'/dev/mapper/asm387',
'/dev/mapper/asm388',
'/dev/mapper/asm389'
rebalance power 24;






alter diskgroup DATA1 drop disk 
DATA1_0172,
DATA1_0173,
DATA1_0174,
DATA1_0175,
DATA1_0176,
DATA1_0177,
DATA1_0178,
DATA1_0179,
DATA1_0180,
DATA1_0181,
DATA1_0183,
DATA1_0184,
DATA1_0185,
DATA1_0186,
DATA1_0187
rebalance power 24;


alter diskgroup ARCHIVE drop disk 
ARCHIVE_0008,ARCHIVE_0009
rebalance power 24;