oracle asm单实例删除,单实例删除ASM实例

看下系统里面关于ASM的进程：

[oracle@ligle-db ~]$ps -ef | grep asmoracle    4138     1 0 03:45 ?        00:00:00 asm_pmon_+ASM

oracle    4140     1 0 03:45 ?        00:00:00 asm_psp0_+ASM

oracle    4142     1 0 03:45 ?        00:00:00 asm_mman_+ASM

oracle    4144     1 0 03:45 ?        00:00:00 asm_dbw0_+ASM

oracle    4146     1 0 03:45 ?        00:00:00 asm_lgwr_+ASM

oracle    4148     1 0 03:45 ?        00:00:00 asm_ckpt_+ASM

oracle    4150     1 0 03:45 ?        00:00:00 asm_smon_+ASM

oracle    4152     1 0 03:45 ?        00:00:00 asm_rbal_+ASM

oracle    4154     1 0 03:45 ?        00:00:01 asm_gmon_+ASMoracle    5309 4028 0 04:09 pts/0    00:00:00 grep asm

设置ORACLE_SID为ASM实例名，且进入ASM实例

[oracle@ligle-db ~]$export ORACLE_SID=+ASM

[oracle@ligle-db ~]$sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 29 04:10:17 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

检查ASM实例上的磁盘组(DISKGROUP)

SQL>select name from v$asm_diskgroup;

NAME

------------------------------

LIGLE_ARCH1

SQL>drop diskgroup ligle_arch1 including contents;       -->删除磁盘组

Diskgroup dropped.

SQL> shutdown     -->关闭ASM实例

ASM diskgroups dismounted

ASM instance shutdown

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

从CSS中删除ASM实例信息

[oracle@ligle-db ~]$oradism -delete -asmsid +ASM

删除ASM相关的参数文件(pfile/spfile)

[oracle@ligle-db ~]$cd $ORACLE_HOME/dbs

[oracle@ligle-db dbs]$ls

ab_+ASM.dat hc_+ASM.dat initdw.ora init.ora lk+ASM orapw+ASM spfile+ASM.ora

[oracle@ligle-db dbs]$rm -rf *+ASM*

[oracle@ligle-db dbs]$cd $ORACLE_BASE/admin

[oracle@ligle-db admin]$ls

+ASM

[oracle@ligle-db admin]$rm -rf *

删除/etc/oratab中关于ASM自动启动的信息

[oracle@ligle-db admin]$vi /etc/oratab

#

# This file is used by ORACLE utilities. It is created by root.sh

# and updated by the Database Configuration Assistant when creating

# a database.

# A colon, ':', is used as the field terminator. A new line terminates

# the entry. Lines beginning with a pound sign, '#', are comments.

#

# Entries are of the form:

#   $ORACLE_SID:$ORACLE_HOME::

#

# The first and second fields are the system identifier and home

# directory of the database respectively. The third filed indicates

# to the dbstart utility that the database should , "Y", or should not,

# "N", be brought up at system boot time.

#

# Multiple entries with the same $ORACLE_SID are not allowed.

#

#

+ASM:/u01/app/oracle/product/10.2.0/db_1:N

至此，基本ASM就删除干净了，可以再重新来一遍了

转载于：http://www.cnblogs.com/huangjingzhou/articles/2190521.html