Automatic Storage Management

Automatic Storage Management

 

To create the partition

# Fdisk –l

# Fdisk  /dev/sdb

 

Changing  the owner ship of the partition

# Chown –R oracle:dba /dev/sdb*

# Chmod -R 775 /dev/sdb*

 

 

Install Grid infrastructure s/w (GRID ASM)

 

Starting the instance and creating the diskgroup

   $export ORACLE_SID=+ASM

    $sqlplus / as sysasm

 

Sql> startup nomount

Sql> select name,path from v$asm_disk;

 

Creating of the diskgroup                                                                        

Sql> create diskgroup dg1 external redundancy disk ‘/dev/sdb1’,’/dev/sdb2’;

Sql> create diskgroup dg1 disk ‘/dev/sdb1’,’/dev/sdb2’;

Sql> create diskgroup dg1 high redundancy disk ‘/dev/sdb1’, ’/dev/sdb2’, ’/dev/sdb3’;

Sql> select name,state from v$asm_diskgroup;

Sql> create diskgroup dg1 normal redundancy

failgroup fg1 disk ‘/dev/sdb1’,’/dev/sdb2’

failgroup fg2 disk ‘/dev/sdb3’,’/dev/sdb4’;

 

Altering the diskgroup

sql> alter diskgroup dg1 mount;

sql>alter diskgroup dg1 dismount;

Sql> alter diskgroup dg1 add disk ‘/dev/sdb3’;

Sql> select name,path from v$asm_disk;

Sql> alter diskgroup dg1 drop disk DG1_0003;

 

Utility to manage the diskgroup

$asmcmd

$asmca

 

views

v$asm_diskgroup

v$asm_volume

v$asm_client

v$asm_disk

v$asm_file