1、删除磁盘组
C:\Users\Administrator>set
oracle_sid=+asm
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production
on Tue Apr 24 10:42:53 2012
Copyright (c) 1982, 2006, Oracle.All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition
Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining
options
--查看是否有数据库实例正在使用自动存储管理实例+ASM
SQL>select instance_name from
v$asm_client;
该命令列出所有正在运行并使用+ASM实例的数据库实例。如果有正在使用+ASM的实例,则不能删除该+ASM实例。必须先对相应的数据库实例SHUTDOWN,然后从asmcmd进入磁盘所在目录,删掉对应的数据库目录和文件。
SYS@ +asm > select name from
v$asm_diskgroup;--查看磁盘组
NAME
------------------------------------------------------------
DG1
DG2
SYS@ +asm > drop diskgroup dg1 including
contents;--删除磁盘组
Diskgroup dropped.
SYS@ +asm > drop diskgroup dg2 including
contents;--一次只能删除一个磁盘组。
Diskgroup dropped.
SYS@ +asm > shutdown--关闭ASM实例
ORA-15100: invalid or missing diskgroup
name
ASM instance shutdown
SYS@ +asm > exit
Disconnected from Oracle Database 10g
Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining
options
2、从CSS中删除ASM实例信息
C:\Users\Administrator>oradim -delete
-asmsid +asm
Instance deleted.
3、删除ASM相关的参数文件
E:\oracle\product\10.2.0\db_1\database目录下的:SPFILE+ASM.ORA、PWD+ASM.ora、hc_+asm.dat、init.ora
E:\oracle\product\10.2.0\admin目录下的:+ASM
4、删除listener.ora和tnsnames.ora相关的信息