文盲筱烨

好读书爱运动的IT技术爱好者

  • 博客访问: 617364
  • 博文数量: 140
  • 用 户 组: 普通用户
  • 注册时间: 2014-02-15 19:01
  • 认证徽章:
个人简介

邮箱:longzhimeng99@sina.com 微博:文盲筱烨 Q Q:807756533 齐鲁IT联盟Q群:178581875 相关博客:http://blog.sina.com.cn/longzhimeng99 微信公众号:wenmangxiaoye

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类

全部博文(140)

文章存档

2017年(66)

2016年(20)

2015年(28)

2014年(26)

微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

分类: Oracle

RAC delete node 

操作前建议检查相关信息,如集群状态、数据库运行情况等,最好最一个备份。

########移除数据库########
--通过DBCA方式删除节点(此处举例rac03),请在rac01/02运行,如不说明,默认情况下rac03运行

点击(此处)折叠或打开

  1. dbca -silent -deleteInstance -nodeList rac03 -gdbName racdb -instanceName racdb3 -sysDBAUserName sys -sysDBAPassword oracle


--查看数据库运行情况,

点击(此处)折叠或打开

  1. --查看数据库运行情况
  2. set lines 150
  3. col instance for a30
  4. select t.inst_id,t.thread#,t.status,t.instance from gv$thread t;

  5. ALTER DATABASE DISABLE THREAD 3

---停止监听

点击(此处)折叠或打开

  1. srvctl disable listener -l listener -n rac03
  2. srvctl stop listener -l listener -n rac03
--更新查看列表

点击(此处)折叠或打开

  1. [oracle@rac03 ~]$ cd $ORACLE_HOME/oui/bin
  2. [oracle@rac03 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/u02/app/oracle/product/11.2.0/db_home "CLUSTER_NODES={rac03}" -local
  3. Starting Oracle Universal Installer...

  4. Checking swap space: must be greater than 500 MB. Actual 4769 MB Passed
  5. The inventory pointer is located at /etc/oraInst.loc
  6. The inventory is located at /u01/app/oraInventory
  7. 'UpdateNodeList' was successful.
  8. [oracle@rac03 bin]$

--移除数据库实例节点

点击(此处)折叠或打开

  1. ./deinstall -local
  2. …………………………

  3. Cleaning the config for CCR
  4. As CCR is not configured, so skipping the cleaning of CCR configuration
  5. CCR clean is finished
  6. Successfully detached Oracle home '/u02/app/oracle/product/11.2.0/db_home' from the central inventory on the local node.
  7. Successfully deleted directory '/u02/app/oracle/product/11.2.0/db_home' on the local node.
  8. Oracle Universal Installer cleanup was successful.

  9. Oracle deinstall tool successfully cleaned up temporary directories.
  10. #######################################################################


  11. ############# ORACLE DEINSTALL & DECONFIG TOOL END #############
--更新其他的节点的inventory  RAC01/02执行

点击(此处)折叠或打开

  1. ./runInstaller -updateNodeList ORACLE_HOME=/u02/app/oracle/product/11.2.0/db_home "CLUSTER_NODES={rac1,rac2}"


###########移除 grid#################

--查看状态 olsnodes -s -t

--移除节点grid资源配置  root用户

点击(此处)折叠或打开

  1. /u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force
  2. ………………
  3. CRS-2673: Attempting to stop 'ora.cssd' on 'rac03'
  4. CRS-2677: Stop of 'ora.cssd' on 'rac03' succeeded
  5. CRS-2673: Attempting to stop 'ora.gipcd' on 'rac03'
  6. CRS-2677: Stop of 'ora.gipcd' on 'rac03' succeeded
  7. CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac03'
  8. CRS-2677: Stop of 'ora.gpnpd' on 'rac03' succeeded
  9. CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac03' has completed
  10. CRS-4133: Oracle High Availability Services has been stopped.
  11. Successfully deconfigured Oracle clusterware stack on this node

--删除grid节点  RAC01/02执行   root用户

点击(此处)折叠或打开

  1. /u01/app/11.2.0/grid/bin/crsctl delete node -n rac03

--更新删除节点目录信息

点击(此处)折叠或打开

  1. /u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid "CLUSTER_NODES={rac03}" CRS=TRUE -local

--卸载集群

点击(此处)折叠或打开

  1. /u01/app/11.2.0/grid/deinstall/deinstall –local

-更新inventory  RAC01/02执行

点击(此处)折叠或打开

  1. /u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid "CLUSTER_NODES={rac01,rac02}" CRS=TRUE


--验证节点是否删除成功   RAC01/02执行

点击(此处)折叠或打开

  1. [grid@rac02 ~]$ cluvfy stage -post nodedel -n rac03 -verbose

  2. Performing post-checks for node removal

  3. Checking CRS integrity...

  4. Clusterware version consistency passed
  5. The Oracle Clusterware is healthy on node "rac02"
  6. The Oracle Clusterware is healthy on node "rac01"

  7. CRS integrity check passed
  8. Result:
  9. Node removal check passed

  10. Post-check for node removal was successful.









阅读(580) | 评论(0) | 转发(1) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册