How to Create an Oracle ADVM volume in an ASM Disk Group

 

Creating ASM ADVM Volume

Using SQLPLUS

SQL> alter diskgroup DG_TEST add volume vol1 size 2G;
Diskgroup altered.

SQL> SELECT DG.NAME,VO.VOLUME_NAME,VO.SIZE_MB,VO.VOLUME_NUMBER,VO.REDUNDANCY,VO.STATE,VO.VOLUME_DEVICE FROM V$ASM_DISKGROUP DG, V$ASM_VOLUME VO WHERE DG.GROUP_NUMBER=VO.GROUP_NUMBER;
NAME       VOLUME_NAM    SIZE_MB VOLUME_NUMBER REDUND STATE    VOLUME_DEVICE
---------- ---------- ---------- ------------- ------ -------- ------------------------------
DG_TEST    VOL1             2048             1 UNPROT ENABLED  /dev/asm/vol1-69

Using ASMCMD:->

ASMCMD> volcreate -G DG_TEST -s 10G vol2

ASMCMD> volinfo -G DG_TEST vol2
Diskgroup Name: DG_TEST
         Volume Name: VOL2
         Volume Device: /dev/asm/vol2-69
         State: ENABLED
         Size (MB): 10240
         Resize Unit (MB): 64
         Redundancy: UNPROT
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage:
         Mountpath: