ITPub博客

首页 > Linux操作系统 > Linux操作系统 > (转)Oracle rac环境下清除asm实例

(转)Oracle rac环境下清除asm实例

原创 Linux操作系统 作者:痞子_DBA 时间:2012-05-23 22:47:46 0 删除 编辑

上一篇 / 下一篇  2011-11-06 08:14:21 / 个人分类:Oracle RAC

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 <- look for ASM resources and make sure the target=offline
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 <- Peform. for all nodes of a RAC cluster
crs_stat |more <- make sure no asm resources exists
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/26823568/viewspace-730761/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-03-26

  • 博文量
    31
  • 访问量
    59287