Borrando un Disk Group
ASMCMD> dropdg -r DATA
ORA-15039: diskgroup not dropped
ORA-15027: active use of diskgroup "DATA" precludes its dismount (DBD ERROR: OCIStmtExecute)
ASMCMD> exit
SQL> drop diskgroup DATA;
drop diskgroup DATA
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15053: diskgroup "DATA" contains existing files
SQL> select * from v$asm_client;
no rows selected
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/asm/asmparameterfile/registry.253.810662323
*Tengo que cambiar de lugar el SPFILE que esta en el ASM
SQL> create pfile='$ORACLE_HOME/dbs/pfileASM.ora' FROM spfile;
SQL> shutdown immediate
SQL> startup from pfile='$ORACLE_HOME/dbs/pfileASM.ora';
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> drop diskgroup DATA including contents;
Diskgroup dropped.
drop diskgroup DATA including contents;
SQL> alter diskgroup DATA dismount force;
Diskgroup altered.
