asm 添加磁盘

[code][oracle@node1 ~]$ export ORACLE_SID=+ASM1
[oracle@node1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Apr 10 03:32:16 2013

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select name,state from v$asm_diskgroup;

NAME STATE
------------------------------ -----------
DATA MOUNTED
NEW_DG MOUNTED

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

NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DATA_0000 50816 0

SQL> col path for a30;
SQL> select name,path from v$asm_disk;

NAME PATH
------------------------------ ------------------------------
/dev/raw/raw8
/dev/raw/raw10
/dev/raw/raw9
/dev/raw/raw2
/dev/raw/raw1
/dev/raw/raw4
NEW_DG_0000 /dev/raw/raw7
DATA_0000 /dev/raw/raw3


8 rows selected.


SQL> alter diskgroup DATA add disk '/dev/raw/raw4';
Diskgroup altered.

SQL> select name,path from v$asm_disk;

NAME PATH
------------------------------ ------------------------------
/dev/raw/raw8
/dev/raw/raw10
/dev/raw/raw9
/dev/raw/raw2
/dev/raw/raw1
NEW_DG_0000 /dev/raw/raw7
DATA_0000 /dev/raw/raw3
DATA_0001 /dev/raw/raw4

SQL> alter diskgroup DATA drop disk 'DATA_0001' rebalance power 11;

Diskgroup altered.


SQL> show parameter asm

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DATA, NEW_DG
asm_diskstring string
asm_power_limit integer 1

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

NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
244 0
191 0
191 0
AWEN_0000 244 218
NEW_DG_0000 244 151
AWEN_0001 244 218
DATA_0001 51199 47642
DATA_0000 50816 47287

8 rows selected.[/code]