Oracle Automatic Storage Management (ASM)
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Purpose  
Dependencies
GV_$ASM_ALIAS GV_$ASM_DISKGROUP GV_$ASM_FILE
GV_$ASM_CLIENT GV_$ASM_DISKGROUP_STAT GV_$ASM_OPERATION
GV_$ASM_DISK GV_$ASM_DISK_STAT GV_$ASM_TEMPLATE
 
ASMCMD Commands
   
 
   
 
   
 
 
CREATE DISKGROUP
   
 
   
   
 
 
ALTER DISKGROUP
ADD ALTER DISKGROUP <disk_group_name> ADD <path_name, path_name, ...>;
[root@mlibp1n1 mapper]# ls -la /dev/oracleasm/disks/POD2_PRD_DG1*
brw-rw---- 1 oracle dba 253, 34 Dec 12 23:10 /dev/oracleasm/disks/POD2_PRD_DG1_01
brw-rw---- 1 oracle dba 253, 61 Dec 12 23:10 /dev/oracleasm/disks/POD2_PRD_DG1_02
brw-rw---- 1 oracle dba 253, 59 Dec 12 23:10 /dev/oracleasm/disks/POD2_PRD_DG1_03
brw-rw---- 1 oracle dba 253, 57 Dec 12 23:10 /dev/oracleasm/disks/POD2_PRD_DG1_04
brw-rw---- 1 oracle dba 253, 54 Dec 12 23:10 /dev/oracleasm/disks/POD2_PRD_DG1_05
brw-rw---- 1 oracle dba 253, 52 Dec 12 23:10 /dev/oracleasm/disks/POD2_PRD_DG1_06
brw-rw---- 1 oracle dba 253, 65 Jan 29 03:52 /dev/oracleasm/disks/POD2_PRD_DG1_07
brw-rw---- 1 oracle dba 253, 64 Jan 29 03:52
/dev/oracleasm/disks/POD2_PRD_DG1_08

A second  validation method is:
Login as oracle and source the ASM environment using oraenv
Login to sqlplus as sysasm and run the query to check the status of the newly added disks.


conn / as sysasm

SQL> SELECT name, path, header_status
   2 FROM v$asm_disk
   3 WHERE header_status = 'PROVISIONED';

NAME                           PATH                           HEADER_STATUS
------------------------------ ------------------------------ -----------------
                               ORCL:POD2_PRD_DG1_08           PROVISIONED
                               ORCL:POD2_PRD_DG1_07           PROVISIONED


A third  validation method is:

/usr/sbin/oracleasm-discover 'ORCL:*'

Output:

Discovered disk: ORCL:POD2_PRD_DG1_07 [268429957 blocks (137436137984 bytes), maxio 512]
Discovered disk: ORCL:POD2_PRD_DG1_08 [268429957 blocks (137436137984 bytes), maxio 512]


If RAC ensure that you can see disk on all nodes. you may have to run the following as root

/usr/sbin/oracleasm scandisks /dev/mapper/ pod2-prd-dg1-07p1
/usr/sbin/oracleasm scandisks /dev/mapper/ pod2-prd-dg1-08p1


Now add the disks to diskgroup

SQL> select name, total_mb, free_mb from v$asm_diskgroup;

NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
DG1                                786414      47918
DG2                                327640     136228
DG3                                 65504      24260
DG4                                262112     256888

SQL> ALTER DISKGROUP DG1 ADD DISK 'ORCL:POD2_PRD_DG1_07','ORCL:POD2_PRD_DG1_08';
Diskgroup altered.

SQL> SELECT name, total_mb, free_mb FROM v$asm_diskgroup;

NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
DG1                               1048552     310050
DG2                                327640     136228
DG3                                 65504      24260
DG4                                262112     256888
 
DROP DISKGROUP
   
 
   
 
   
   
 
Add a disk to a diskgroup
   
   

Related Topics
AMDU
KFED
RAC

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved