[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 --------- ------- ----------------------- spfile string +DATA/racdb/spfileracdb.ora
SQL> select name,value from v$spparameter where sid='racdb3';
NAME VALUE -------------------- -------------------- thread 3 instance_number 3 undo_tablespace UNDOTBS3
SQL> alter system reset thread scope=spfile sid='racdb3'; System altered.
SQL> alter system reset instance_number scope=spfile sid='racdb3'; System altered.
SQL> alter system reset undo_tablespace scope=spfile sid='racdb3'; System altered.
SQL> alter system reset service_names scope=spfile sid='racdb3'; alter system reset service_names scope=spfile sid='racdb3' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE
SQL> alter system reset local_listener scope=spfile sid='racdb3'; alter system reset local_listener scope=spfile sid='racdb3' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE
SQL> select sid,name,value from v$spparameter where name='cluster_database_instances';
SID NAME VALUE ---------- ---------------------------------------- -------------------- * cluster_database_instances 2
[oracle@rac1 ~]$ srvctl status database -d racdb Instance racdb1 is running on node rac1 Instance racdb2 is running on node rac2 Instance racdb3 is not running on node rac3 [oracle@rac1 ~]$ srvctl remove instance -d racdb -i racdb3 Remove instance racdb3 from the database racdb? (y/[n]) y
[oracle@rac1 ~]$ srvctl status asm -n rac3 ASM instance +ASM3 is not running on node rac3. [oracle@rac1 ~]$ srvctl remove asm -n rac3
[root@rac3 ~]# cd /u01/app/oracle/product/10.2.0/crs_1/install [root@rac3 install]# ./rootdelete.sh CRS-0210: Could not find resource 'ora.rac3.LISTENER_RAC3.lsnr'. Shutting down Oracle Cluster Ready Services (CRS): Stopping resources. Successfully stopped CRS resources Stopping CSSD. Shutting down CSS daemon. Shutdown request successfully issued. Shutdown has begun. The daemons should exit soon. Checking to see if Oracle CRS stack is down...
Checking to see if Oracle CRS stack is down... Oracle CRS stack is not running. Oracle CRS stack is down now. Removing script for Oracle Cluster Ready services Updating ocr file for downgrade Cleaning up SCR settings in '/etc/oracle/scls_scr'
备注:在清除rac节点前,需要利用netca来删除监听,否则会报错如下! CRS resources for listeners are still configured. You must remove the CRS listener resources before deconfiging CRS stack. Use NETCA to remove them. 1
七:在节点1上更新OCR信息
[root@rac1 ~]# cd /u01/app/oracle/product/10.2.0/crs_1/install [root@rac1 install]# ./rootdeletenode.sh rac3,3 CRS-0210: Could not find resource 'ora.rac3.LISTENER_RAC3.lsnr'. CRS-0210: Could not find resource 'ora.rac3.ons'. CRS-0210: Could not find resource 'ora.rac3.vip'. CRS-0210: Could not find resource 'ora.rac3.gsd'. CRS-0210: Could not find resource ora.rac3.vip. CRS nodeapps are deleted successfully clscfg: EXISTING configuration version 3 detected. clscfg: version 3 is 10G Release 2. Successfully deleted 14 values from OCR. Key SYSTEM.css.interfaces.noderac3 marked for deletion is not there. Ignoring. Successfully deleted 5 keys from OCR. Node deletion operation successful. 'rac3,3' deleted successfully