阿里云-云小站(无限量代金券发放中)
【腾讯云】云服务器、云数据库、COS、CDN、短信等热卖云产品特惠抢购

Oracle 11g RAC删除节点相关事项

176次阅读
没有评论

共计 3015 个字符,预计需要花费 8 分钟才能阅读完成。

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

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

dbca -silent -deleteInstance -nodeList rac03 -gdbName racdb -instanceName racdb3 -sysDBAUserName sys -sysDBAPassword Oracle

– 查看数据库运行情况

set lines 150
col instance for a30
select t.inst_id,t.thread#,t.status,t.instance from gv$thread t;

ALTER DATABASE DISABLE THREAD 3

— 停止监听

srvctl disable listener -l listener -n rac03

srvctl stop listener -l listener -n rac03
– 更新查看列表

[oracle@rac03 ~]$ cd $ORACLE_HOME/oui/bin

[oracle@rac03 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/u02/app/oracle/product/11.2.0/db_home “CLUSTER_NODES={rac03}” -local
Starting Oracle Universal Installer…

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

– 移除数据库实例节点

./deinstall -local

…………………………

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

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

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

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

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

– 查看状态 olsnodes -s -t

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

/u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force

………………
CRS-2673: Attempting to stop ‘ora.cssd’ on ‘rac03’
CRS-2677: Stop of ‘ora.cssd’ on ‘rac03’ succeeded
CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘rac03’
CRS-2677: Stop of ‘ora.gipcd’ on ‘rac03’ succeeded
CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘rac03’
CRS-2677: Stop of ‘ora.gpnpd’ on ‘rac03’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘rac03’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully deconfigured Oracle clusterware stack on this node

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

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

– 更新删除节点目录信息

/u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid “CLUSTER_NODES={rac03}” CRS=TRUE -local

– 卸载集群

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

- 更新 inventory  RAC01/02 执行

/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 执行

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

Performing post-checks for node removal

Checking CRS integrity…

Clusterware version consistency passed
The Oracle Clusterware is healthy on node “rac02”
The Oracle Clusterware is healthy on node “rac01”

CRS integrity check passed
Result:
Node removal check passed

Post-check for node removal was successful.

更多 Oracle 相关信息见 Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

本文永久更新链接地址 :http://www.linuxidc.com/Linux/2017-06/144688.htm

正文完
星哥玩云-微信公众号
post-qrcode
 0
星锅
版权声明:本站原创文章,由 星锅 于2022-01-22发表,共计3015字。
转载说明:除特殊说明外本站文章皆由CC-4.0协议发布,转载请注明出处。
【腾讯云】推广者专属福利,新客户无门槛领取总价值高达2860元代金券,每种代金券限量500张,先到先得。
阿里云-最新活动爆款每日限量供应
评论(没有评论)
验证码
【腾讯云】云服务器、云数据库、COS、CDN、短信等云产品特惠热卖中