Adding ASM disk / sample scenarios


export ORACLE_HOME=/oraclegrid/11.2.0/grid
export ORACLE_SID=+ASM1
sqlplus / as sysasm
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> alter diskgroup DATA add disk '/dev/rhdisk12';
SELECT name, header_status,total_mb/1024 "GB TOTAL DISK SIZE",free_mb/1024 "GB FREE", path FROM V$ASM_DISK;
sssss
select name,total_mb/1024 "Total_size (GB)",free_mb/1024 "free_size (GB)" from v$asm_diskgroup
qqqqqq
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT      POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
           1 REBAL RUN           5          5     109053     502849       6779
         58

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: