Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3

Information in this document applies to any platform.

"Checked for relevance on 05-Feb-2008"

Goal:

How to drop the ASM instance installed in a seperate Oracle Home for both RAC and non-RAC installations.

解除安裝rac安裝或非rac安裝中的asm例項。

Solution:

The outline of the steps involved are :

a) Backup all the ASM client database files stored on the diskgroups.

備份磁碟組上的檔案。

b) Dropping all the diskgroups.

刪除磁碟組。

c) Removing ASM resource from CRS (* RAC specific)

從CRS移除asm資源。

d) Removing ASM disk signature (In case of asmlib)

移除asm磁碟簽名。

e) Remove the ASM pfile/spfile.

移除asm pfile/spfile。

f) Removing ASM entry in the file oratab

移除oratab中的asm入口。

g) Wipe out the disks header using dd

使用dd清楚磁碟頭。

Following are the steps to be followed:

1) Log into the ASM instance and do 'select * from v$asm_client;'

2) For each instance listed above, stop the respective databases.

3) Backup all the datafiles, logfiles, controlfiles, archive logs, etc. that are currently using ASM storage, to tape or to filesystem (using RMAN). This needs to be done for every database (ASM client) using ASM.

** NOTE: Please make sure you have the data secure before continuing to the next step.

4) Find all the diskgroups: 'select * from v$asm_diskgroup'

5) For each diskgroup listed above:

' drop diskgroup including contents'

6) Shutdown all(RAC nodes) ASM instances.

7) On RAC install verify that all asm instances are stopped

$ORA_CRS_HOME/bin/crst_stat |more

8) For single instance install run the following script.:

$ORACLE_HOME/bin/localconfig delete

* This cleans up the CSSD configuration.

9)Invoke OUI, and now de-install the ASM Oracle home.

10) For RAC install, remove the asm related resource.

srvctl remove asm -n

crs_stat |more

11) If using asmlib (on Linux only), then

a. oracleasm listdisks

b. oracleasm deletedisks (do this for every disk listed above)

c. oracleasm listdisks (to verify they have been deleted)

d. on other RAC nodes: oracleasm listdisks (to verify they have been deleted too)

e. On all nodes(RAC) :

As root run:

# /etc/init.d/oracleasm stop

# /etc/init.d/oracleasm disable

12) delete the ASM pfile or spfile

13) in the file oratab, remove the line relative to the ASM instance

14) clean out the disks headers using the dd command:

for example: dd if=/dev/zero f=/dev/ bs=1024k count=50

我在安裝oracle rac，配置asm例項，建立磁碟組後掛載狀態有錯誤！

必須解除安裝asm例項，我的步驟如下：

1、停止ASM例項

srvctl stop asm -n dbp

srvctl stop asm -n dbs

2、移除ASM例項（從ocr.loc中）

srvctl remove asm -n dbp

srvctl remove asm -n dbs

3、刪除/etc/oratab檔案下的相關條目

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12272958/viewspace-710318/，如需轉載，請註明出處，否則將追究法律責任。

上一篇： vipca報錯 Error 0

下一篇： (轉)RAC srvctl 命令報 libpthread.so.0 cannot open shared object file解決辦法

請登入後發表評論登入

全部評論

(轉)Oracle rac環境下清除asm例項

最新文章

相關文章