DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, March 8, 2017

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

No comments: