刪除Linux非rac環(huán)境下的ASM實(shí)例

環(huán)境說(shuō)明：

操作系統(tǒng)：CentOS 5 x86
數(shù)據(jù)庫(kù)：Oracle 10.2.0.1 非RAC環(huán)境
ASM實(shí)例名：+ASM

參考：metalink node:311350.1

1、檢查ASM實(shí)例進(jìn)程

www.linuxidc.com@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、設(shè)置ASM實(shí)例名

www.linuxidc.com@Oracle[/home/oracle]> export ORACLE_SID=+ASM 

3、檢查是否有實(shí)例在使用ASM

www.linuxidc.com@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
 

如果有實(shí)例在使用ASM，需要首先停止這些相關(guān)的實(shí)例，并備份相關(guān)的datafile、controlfile等

4、檢查ASM實(shí)例上的diskgroup

idle> select name from v$asm_diskgroup;

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

5、刪除檢查到ASM實(shí)例上的diskgroup

idle> drop diskgroup data including contents;

Diskgroup dropped. 

6、關(guān)閉ASM實(shí)例

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實(shí)例信息

www.linuxidc.com@Oracle[/home/oracle]> oradism -delete -asmsid +ASM 

8、刪除ASM實(shí)例相關(guān)的spfile、pfile等文件

www.linuxidc.com@Oracle[/home/oracle]> cd $ORACLE_HOME/dbs
www.linuxidc.com@Oracle[/oracle/app/10.1/dbs]> rm -f *+ASM*
www.linuxidc.com@Oracle[/oracle/app/10.1/dbs]> cd $ORACLE_BASE/admin
www.linuxidc.com@Oracle[/oracle/admin]> rm -rf +ASM 

9、刪除/etc/oratab文件中的ASM實(shí)例相關(guān)行

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

其實(shí)刪除Oracle 實(shí)例同樣要查出該文件的內(nèi)容

+ASM:/Oracle/app/10.1:Y 

10、用root用戶刪除cssd服務(wù)

www.linuxidc.com@root[/Oracle/app/10.1/bin]> ./localconfig delete
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon. 

11、清除ASM使用的設(shè)備的文件頭信息

www.linuxidc.com@Oracle[/home/oracle]> cd /dev/raw/
www.linuxidc.com@Oracle[/dev/raw]> ls -l *
crw------- 1 Oracle oinstall 162, 1 Jan 21 08:45 raw1
crw------- 1 Oracle oinstall 162, 2 Jan 21 08:45 raw2
crw------- 1 Oracle oinstall 162, 3 Jan 21 08:45 raw3
www.linuxidc.com@Oracle[/dev/raw]> dd if=/dev/zero of=/dev/raw/raw1 bs=1024 count=10
10+0 records in
10+0 records out
10240 bytes (10 kB) copied, 0.00396028 seconds, 2.6 MB/s
www.linuxidc.com@Oracle[/dev/raw]> dd if=/dev/zero of=/dev/raw/raw2 bs=1024 count=10
10+0 records in
10+0 records out
10240 bytes (10 kB) copied, 0.00485093 seconds, 2.1 MB/s
www.linuxidc.com@Oracle[/dev/raw]> dd if=/dev/zero of=/dev/raw/raw3 bs=1024 count=10
10+0 records in
10+0 records out
10240 bytes (10 kB) copied, 0.00532261 seconds, 1.9 MB/s 

--end--

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]