11gr2 重新创建 diskgroup

SQL> select name,failgroup,path from v$asm_disk;

NAME
--------------------------------------------------------------------------------
FAILGROUP
--------------------------------------------------------------------------------
PATH
--------------------------------------------------------------------------------
DATA_0000
DATA_0000
/dev/rdisk1lv

DATA_0001
DATA_0001
/dev/rdisk2lv

NAME
--------------------------------------------------------------------------------
FAILGROUP
--------------------------------------------------------------------------------
PATH
--------------------------------------------------------------------------------

SQL> alter diskgroup data drop disk '/dev/rdisk1lv' rebalance power 11;
alter diskgroup data drop disk '/dev/rdisk1lv' rebalance power 11
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "/DEV/RDISK1LV" does not exist in diskgroup "DATA"

SQL> drop diskgroup DATA including contents;
drop diskgroup DATA including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15027: active use of diskgroup "DATA" precludes its dismount

spfile参数放在DATA磁盘组中，这是因为如果要用asm磁盘组，必须先建立asm实例,R2而oracle 11gR2版本中，
你安装grid 时，必须先建立asm实例和至少一个磁盘组，来存放spfile参数，默认放在asm磁盘组中，
找到问题原因了，解决方法就比较简单，用pfile启动，删除后，再重新把
spfile创建回磁盘组中。

SQL> show parameter spfile;

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
spfile                               string
+DATA/asm/asmparameterfile/registry.253.798574953
SQL>
SQL> create pfile from spfile;

File created.

SQL>
sgerp:/g01/grid/asm/dbs$ls -l
total 0
-rw-rw----    1 grid     dba            2567 Nov 20 20:24 ab_+ASM.dat
-rw-rw----    1 grid     dba            1544 Nov 20 22:24 hc_+ASM.dat
-rw-r--r--    1 grid     dba             233 Nov 20 22:49 init+ASM.ora
-rw-r--r--    1 grid     dba            2851 May 15 2009  init.ora
-rw-r-----    1 grid     dba            1536 Nov 05 18:22 orapw+ASM
sgerp:/g01/grid/asm/dbs$

SQL> shutdown immediate
SQL> startup pfile=$ORACLE_HOME/dbs/init+ASM.ora
--drop diskgroup DATA including contents;
--drop diskgroup DATA force including contents;
--alter diskgroup DATA dismount force;

SQL> startup pfile=$ORACLE_HOME/dbs/init+ASM.ora
ASM instance started

Total System Global Area  321507328 bytes
Fixed Size                  2221160 bytes
Variable Size             294120344 bytes
ASM Cache                  25165824 bytes
ORA-15110: no diskgroups mounted

SQL>  drop diskgroup DATA force including contents;

Diskgroup dropped.

SQL>
SQL> create spfile='+DATA' from pfile='$ORACLE_HOME/dbs/init+ASM.ora';
create diskgroup DATA external REDUNDANCY disk '/dev/rhdisk2' ATTRIBUTE 'AU_SIZE'='4M';