Lokeshaggarwal's DBA

Live the life you love. Love the life you live

Adding datafile in ASM


SQL> select name from v$tablespace;

NAME
——————————
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP

SQL> select name from v$datafile;

NAME
——————————————————————————–
+DATA1/nonasmtoasm/datafile/system.259.721108803
+DATA1/nonasmtoasm/datafile/undotbs1.261.721108865
+DATA1/nonasmtoasm/datafile/sysaux.260.721108841
+DATA1/nonasmtoasm/datafile/users.262.721108873

You have to define diskgroup name while adding datafile

SQL> select name from v$asm_diskgroup;

NAME
——————————
DATA1
DATA

Above we are having two asm diskgorup

SQL> alter tablespace users add datafile ‘+data1’ size 5M;

Tablespace altered.

SQL> select name from v$datafile;

NAME
——————————————————————————–
+DATA1/nonasmtoasm/datafile/system.259.721108803
+DATA1/nonasmtoasm/datafile/undotbs1.261.721108865
+DATA1/nonasmtoasm/datafile/sysaux.260.721108841
+DATA1/nonasmtoasm/datafile/users.262.721108873
+DATA1/nonasmtoasm/datafile/users.269.721187971

SQL>

Advertisements

June 9, 2010 - Posted by | ASM

2 Comments »

  1. GOOD ONE

    Comment by SHSHANK GARG | February 27, 2012 | Reply

  2. thanks, it really helped me in fixing a critical issue

    Comment by rajendra | May 28, 2012 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: