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

删除Oracle 10gR2 RAC节点(原创)

一.关闭rac3节点的数据库实例和ASM实例

[oracle@rac1 ~]$ crs_stat -t -v
Name?????????? Type?????????? R/RA?? F/FT?? Target??? State???? Host?????? ?
----------------------------------------------------------------------
ora....SM1.asm application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac1?????? ?
ora....C1.lsnr application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.gsd?? application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.ons?? application??? 0/3??? 0/0??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.vip?? application??? 0/0??? 0/0??? ONLINE??? ONLINE??? rac1?????? ?
ora....SM2.asm application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac2?????? ?
ora....C2.lsnr application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.gsd?? application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.ons?? application??? 0/3??? 0/0??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.vip?? application??? 0/0??? 0/0??? ONLINE??? ONLINE??? rac2?????? ?
ora....SM3.asm application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac3?????? ?
ora....C3.lsnr application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac3?????? ?
ora.rac3.gsd?? application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac3?????? ?
ora.rac3.ons?? application??? 0/3??? 0/0??? ONLINE??? ONLINE??? rac3?????? ?
ora.rac3.vip?? application??? 0/0??? 0/0??? ONLINE??? ONLINE??? rac3?????? ?
ora.racdb.db?? application??? 0/1??? 0/1??? ONLINE??? ONLINE??? rac1?????? ?
ora....b1.inst application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac1?????? ?
ora....b2.inst application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac2?????? ?
ora....b3.inst application??? 0/5??? 0/0??? ONLINE??? ONLINE??? rac3
[oracle@rac1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac1
Instance racdb2 is running on node rac2
Instance racdb3 is running on node rac3
[oracle@rac1 ~]$ srvctl stop instance -d racdb -i racdb3 -o immediate
[oracle@rac1 ~]$ srvctl status asm -n rac3
ASM instance +ASM3 is running on node rac3.
[oracle@rac1 ~]$ srvctl stop asm -n rac3
二:修改spfile文件的相关参数
[oracle@rac1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 1 19:06:58 2011
Copyright (c) 1982, 2005, Oracle.? All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> show parameter spfile;
NAME????? TYPE???? VALUE
--------- -------? -----------------------