刪除Linux非rac環境下的ASM例項

我的一臺測試機上執行ASM例項，現在需要測試檔案系統的資料庫，需要刪除ASM例項，下面演示刪除ASM例項的過程：

環境說明：

作業系統：CentOS 5 x86
資料庫：Oracle 10.2.0.1 非RAC環境
ASM例項名：+ASM

參考：metalink node:311350.1

[@more@]

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檔案中的如下行

+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 begun. The daemons should exit soon.

11、清除ASM使用的裝置的檔案頭資訊

ora_test@oracle[/home/oracle]> cd /dev/raw/ ora_test@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 ora_test@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 ora_test@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 ora_test@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--