日期:2014-05-16  浏览次数:20598 次

删除Linux非rac环境下的ASM实例

环境说明:

操作系统:CentOS 5 x86
数据库:Oracle 10.2.0.1 非RAC环境
ASM实例名:+ASM

参考:metalink node:311350.1


1、检查ASM实例进程

ora_test@oracle[/home/oracle]> ps -ef|grep asm|grep -v grep
oracle 4263 1 0 Jan20 ? 00:00:02 asm_pmon_+ASM
oracle 4265 1 0 Jan20 ? 00:00:00 asm_psp0_+ASM
oracle 4267 1 0 Jan20 ? 00:00:00 asm_mman_+ASM
oracle 4269 1 0 Jan20 ? 00:00:00 asm_dbw0_+ASM
oracle 4271 1 0 Jan20 ? 00:00:00 asm_lgwr_+ASM
oracle 4273 1 0 Jan20 ? 00:00:00 asm_ckpt_+ASM
oracle 4275 1 0 Jan20 ? 00:00:00 asm_smon_+ASM
oracle 4277 1 0 Jan20 ? 00:00:00 asm_rbal_+ASM
oracle 4279 1 0 Jan20 ? 00:00:06 asm_gmon_+ASM

2、设置ASM实例名

ora_test@oracle[/home/oracle]> export ORACLE_SID=+ASM

3、检查是否有实例在使用ASM

ora_test@oracle[/home/oracle]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 21 08:44:03 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

idle> select instance_name from v$asm_client;

no rows selected

如果有实例在使用ASM,需要首先停止这些相关的实例,并备份相关的datafile、controlfile等

4、检查ASM实例上的diskgroup

idle> select name from v$asm_diskgroup;

NAME
------------------------------
DATA

5、删除检查到ASM实例上的diskgroup

idle> drop diskgroup data including contents;

Diskgroup dropped.

6、关闭ASM实例

idle> shutdown
ORA-15100: invalid or missing diskgroup name


ASM instance shutdown
idle> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

7、从css中删除ASM实例信息

ora_test@oracle[/home/oracle]> oradism -delete -asmsid +ASM

8、删除ASM实例相关的spfile、pfile等文件

ora_test@oracle[/home/oracle]> cd $ORACLE_HOME/dbs
ora_test@oracle[/oracle/app/10.1/dbs]> rm -f *+ASM*
ora_test@oracle[/oracle/app/10.1/dbs]> cd $ORACLE_BASE/admin
ora_test@oracle[/oracle/admin]> rm -rf +ASM

9、删除/etc/oratab文件中的ASM实例相关行

删除/etc/oratab文件中的如下行

其实删除oracle 实例同样要查出该文件的内容

+ASM:/oracle/app/10.1:Y

10、用root用户删除cssd服务

ora_test@root[/oracle/app/10.1/bin]> ./localconfig delete
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has