10g或11gr1RAC剔除节点



10g和11gr1从集群中删除不能启动的节点
  3节点rac lc2n1、lc2n2、lc2n3（lc2n3 宕机）
 
  查看集群状态
  crs_stat -t -v
  1.查看网络public和private，删除lc2n3
  $CRS_HOME/bin/oifcfg getif
  $ $CRS_HOME/bin/oifcfg delif -node lc2n3
  2.移除ons通知服务
  找到使用的远程端口
   cat $CRS_HOME/opmn/conf/ons.config
  localport=6113
  remoteport=6200
  loglevel=3
  useocr=on
  显示远程端口为6200
  移除
  $CRS_HOME/bin/racgons remove_config lc2n3:6200
 
  3.移走其他资源（实例、asm、listener、nodeapps）
oracle@lc2n1 ~]$ crsstat |grep OFFLINE
ora.LC2DB1.LC2DB13.inst                  ONLINE     OFFLINE             
ora.LC2DB1.LC2DB1_SRV1.LC2DB13.srv       ONLINE     OFFLINE             
ora.lc2n3.ASM3.asm                       ONLINE     OFFLINE             
ora.lc2n3.LISTENER_LC2N3.lsnr            ONLINE     OFFLINE             
ora.lc2n3.gsd                            ONLINE     OFFLINE             
ora.lc2n3.ons                            ONLINE     OFFLINE  
在移走之前先对ocr做备份
[root@lc2n1 ~]# cd $CRS_HOME/cdata/lc2
[root@lc2n1 lc2]# $CRS_HOME/bin/ocrconfig -export ocr_before_node_removal.exp
[root@lc2n1 lc2]# ls -l ocr_before_node_removal.exp
-rw-r--r-- 1 root root 151946 Nov 15 15:24 ocr_before_node_removal.exp
使用srvctl命令删除node3的实例。
[oracle@lc2n1 ~]$ . oraenv
ORACLE_SID = [oracle] ? LC2DB1
[oracle@lc2n1 ~]$ $ORACLE_HOME/bin/srvctl remove instance -d LC2DB1 -i LC2DB13
Remove instance LC2DB13 from the database LC2DB1? (y/[n]) y
移走asm资源
[oracle@lc2n1 ~]$ . oraenv
ORACLE_SID = [oracle] ? +ASM1
[oracle@lc2n1 ~]$ $ORACLE_HOME/bin/srvctl remove asm -n lc2n3
移走listener
10.2
[oracle@lc2n1 lc2]$ $CRS_HOME/bin/crs_unregister ora.lc2n3.LISTENER_LC2N3.lsnr
11.1
[oracle@lc2n1 ~]$ . oraenv
ORACLE_SID = [oracle] ? +ASM1
[oracle@lc2n1 lc2]$ $ORACLE_HOME/bin/srvctl remove listener -n lc2n3
as root user
[root@lc2n1 oracle]# $CRS_HOME/bin/srvctl stop nodeapps -n lc2n3
[root@lc2n1 oracle]# crsstat |grep OFFLINE
ora.lc2n3.LISTENER_LC2N3.lsnr            OFFLINE    OFFLINE             
ora.lc2n3.gsd                            OFFLINE    OFFLINE             
ora.lc2n3.ons                            OFFLINE    OFFLINE             
ora.lc2n3.vip                            OFFLINE    OFFLINE
[root@lc2n1 oracle]#  $CRS_HOME/bin/srvctl remove nodeapps -n lc2n3
Please confirm that you intend to remove the node-level applications on node lc2n3 (y/[n]) y

$crs_stat -t
此时检查资源已经没有节点3的了 
4 运行rootdeletenode.sh
[oracle@lc2n1 ~]$ $CRS_HOME//bin/olsnodes -n
lc2n1   1
lc2n2   2
lc2n3   3

[root@lc2n1 ~]# cd $CRS_HOME/install
[root@lc2n1 install]# ./rootdeletenode.sh lc2n3,3
CRS-0210: Could not find resource 'ora.lc2n3.ons'.
CRS-0210: Could not find resource 'ora.lc2n3.vip'.
CRS-0210: Could not find resource 'ora.lc2n3.gsd'.
CRS-0210: Could not find resource ora.lc2n3.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.nodelc2n3 marked for deletion is not there. Ignoring.
Successfully deleted 5 keys from OCR.
Node deletion operation successful.
'lc2n3,3' deleted successfully
[root@lc2n1 install]# $CRS_HOME/bin/olsnodes -n
lc2n1   1
lc2n2   2

5 更新目录

[oracle@lc2n1 install]$ $CRS_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/10.2.0/crs "CLUSTER_NODES={lc2n1,lc2n2}" CRS=TRUE 
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
'UpdateNodeList' was successful.

[oracle@lc2n1 install]$ $CRS_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/10.2.0/asm "CLUSTER_NODES={lc2n1,lc2n2}"
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
'UpdateNodeList' was successful.
[oracle@lc2n1 install]$ $CRS_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 "CLUSTER_NODES={lc2n1,lc2n2}"
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
'UpdateNodeList' was successful.