Add a disk to existing Diskgroup in ASM and some DISKGROUP scripts

sqlplus / as sysasm

alter diskgroup DATA add disk '/dev/ora_Data13','/dev/ora_Data14','/dev/ora_Data15','/dev/ora_Data16' rebalance power 9 ;


 Diskgroup altered.
 

Beow query is to check the disk addtion process


   select * from V$asm_operation ;
 
 GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES
 
 ------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
 
            1 REBAL RUN           9          9       3079     299726      10511          28


ALTER DISKGROUP disk_group_1 ADD DISK  '/devices/disk*3',  '/devices/disk*4';


DROP diskgroup

ALTER DISKGROUP disk_group_1 DROP DISK diska2;

-- Resize a specific disk.
ALTER DISKGROUP disk_group_1  RESIZE DISK diska1 SIZE 100G;



-- Resize all disks in a failure group.
ALTER DISKGROUP disk_group_1  RESIZE DISKS IN FAILGROUP failure_group_1 SIZE 100G;



-- Resize all disks in a disk group.
ALTER DISKGROUP disk_group_1  RESIZE ALL SIZE 100G;





-- Create a directory.
ALTER DISKGROUP disk_group_1 ADD DIRECTORY '+disk_group_1/my_dir';

-- Rename a directory.
ALTER DISKGROUP disk_group_1 RENAME DIRECTORY '+disk_group_1/my_dir' TO '+disk_group_1/my_dir_2';

-- Delete a directory and all its contents.
ALTER DISKGROUP disk_group_1 DROP DIRECTORY '+disk_group_1/my_dir_2' FORCE;

-- Drop file using an alias.
ALTER DISKGROUP disk_group_1 DROP FILE '+disk_group_1/my_dir/my_file.dbf';

-- Drop file using a numeric form filename.
ALTER DISKGROUP disk_group_1 DROP FILE '+disk_group_1.342.3';

-- Drop file using a fully qualified filename.
ALTER DISKGROUP disk_group_1 DROP FILE '+disk_group_1/mydb/datafile/my_ts.342.3';





CREATE TABLESPACE my_ts DATAFILE '+disk_group_1' SIZE 100M AUTOEXTEND ON;