Steps to add the disk to existing diskgroups

Steps:

Connect as sqlplus / as sysasm;


TO CHECK DISKGROUP NAME:

select group_number,name from v$asm_diskgroup;


GROUP_NUMBER NAME
———— ——————————
  1 DATA

show parameter asm_diskstring;


alter system set asm_diskstring=’ORCL:*’;


SELECT MOUNT_STATUS,HEADER_STATUS,STATE,TOTAL_MB,
FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;


MOUNT_S HEADER_STATUS STATE  TOTAL_MB FREE_MB NAME PATH         LABEL
CACHED MEMBER         NORMAL  12284   9950    DISK1  ORCL:DISK1 DISK1

ADD DISK TO EXISTING DISK GROUP:

alter diskgroup DATA add disk ‘ORCL:DISK2’;


TO CHECK REBALANCE OPERATION:


Select operation, state, est_work, est_minutes from v$asm_operation;



REBALANCE OPERATION:


OPERA STAT   EST_WORK EST_MINUTES

—– —- ———- ———–
REBAL RUN      1969 0


REBALANCE OPERATION COMPLETED:

no rows selected

set lines 270 pages 10000

col diskgroup for a10
col DISKNAME for a30
select dg.NAME diskgroup, dg.TYPE, dg.VOTING_FILES,ds.NAME diskname, ds.TOTAL_MB, ds.FREE_MB, dg.USABLE_FILE_MB from V$ASM_DISKGROUP dg, V$asm_disk_stat ds where dg.GROUP_NUMBER =ds.GROUP_NUMBER order by diskgroup, diskname;


DISKGROUP  TYPE   V DISKNAME TOTAL_MB   FREE_MB USABLE_FILE_MB

DATA   EXTERN    Y DISK1 12284       9956    18535
DATA   EXTERN    Y DISK2 10550       8579    18535



TO CHECK DISK GROUP USED AND FREE SPACE:


select group_number, name, total_mb, free_mb, type from v$asm_diskgroup where name=’DATA’; 


GROUP_NUMBER NAME  TOTAL_MB  FREE_MB   TYPE
 1           DATA  22834    18535    EXTERN

  • March 8, 2017 | 16 views
  • Comments