單例項刪除ASM例項

需要刪除一個asm例項,發現網上有一篇轉載過,本人已測試

[oracle@ligle-db ~]$ ps -ef | grep asm
oracle 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_+ASM
oracle 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; --&gt刪除磁碟組

Diskgroup dropped.

SQL> shutdown --&gt關閉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

轉載於:

http://www.cnblogs.com/huangjingzhou/articles/2190521.html