ADDING DISKS TO DISKGROUP - add as sysasm USER

ADDING DISKS TO DISKGROUP - add as sysasm USER

SQL> select * from v$asm_operation  ;

GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------
           1 REBAL RUN           1          1       2378     195064       1665         115

1)select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,TOTAL_MB,FREE_MB,NAME,FAILGROUP,PATH from v$asm_disk order by 6;

set linesize 200
col path for a45
select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,TOTAL_MB,FREE_MB,NAME,FAILGROUP,PATH from v$asm_disk order by 6;


2) login as / as sysasm
select INSTANCE_NAME from v$instance;

3) Check for CANDIDATE disk

COL NAME  FOR A20
COL PATH  FOR A55
set linesize 300

select  group_number,name, state, name, path, header_status,MODE_STATUS from v$asm_disk where header_status='CANDIDATE';
select  group_number,name, state, name, path, header_status from v$asm_disk where header_status='CANDIDATE' and path like 'data01_asm%';
select group_number, state, name, path, header_status from v$asm_disk
select  group_number,name, state, name, path, header_status from v$asm_disk where group_number=1; 

4) !ls -ltr /dev/hai/ASM/hdd_disk_0015_L1A0

5) Add the disk

alter diskgroup DATA01 add disk '/dev/hai/ASM/hdd_disk_0015_L1A0' rebalance power 3;
alter diskgroup DATA01 add disk '/dev/hai/ASM/ods_asm_vol_66' rebalance power 3;

6) Check the space in ASM disk group

select GROUP_NUMBER,NAME,TOTAL_MB,FREE_MB,OFFLINE_DISKS from  V$ASM_DISKGROUP;

GROUP_NUMBER NAME                             TOTAL_MB    FREE_MB OFFLINE_DISKS
------------ ------------------------------ ---------- ---------- -------------
           1 DATA01                            3632389     101057             0
       

7)select * from v$asm_operation;