正德厚生,臻于至善

How to set auto start resources in 11G RAC

/app/11.2.0/grid/bin/crsctl stat res -t
/app/11.2.0/grid/bin/crsctl modify resource "ora.ARCH.dg" -attr "AUTO_START=always"
/app/11.2.0/grid/bin/crsctl status resource "ora.ARCH.dg" -p
/app/11.2.0/grid/bin/srvctl modify database -d SHPROD -a "DATA,ARCH"

Oracle 11gR2 grid 集群有些资源不会集群自动启动,需要手工启动,比如用srvctl和crs_start 等等,出现这种问题的原因大概是在集群运行时,出现手工停止某些资源的情况。

查看resource 的启动属性
/app/11.2.0/grid/bin/crsctl status resource "ora.ARCH.dg" -p
修改成跟随集群软件自动启动
/app/11.2.0/grid/bin/crsctl modify resource "ora.ARCH.dg" -attr "AUTO_START=always"
/app/11.2.0/grid/bin/crsctl status resource "ora.ARCH.dg" -p

以下是auto_start的解释。
AUTO_START
Indicates whether Oracle Clusterware automatically starts a resource after a cluster server restart. Valid AUTO_START values are:
always: Restarts the resource when the server restarts regardless of the state of the resource when the server stopped.
restore: Restores the resource to the same state that it was in when the server stopped. Oracle Clusterware attempts to restart the resource if the value of TARGET was ONLINE before the server stopped.
never: Oracle Clusterware never restarts the resource regardless of the state of the resource when the server stopped.

赞(0) 打赏
未经允许不得转载:徐万新之路 » How to set auto start resources in 11G RAC

支持快讯、专题、百度收录推送、人机验证、多级分类筛选器,适用于垂直站点、科技博客、个人站,扁平化设计、简洁白色、超多功能配置、会员中心、直达链接、文章图片弹窗、自动缩略图等...

联系我们

觉得文章有用就打赏一下文章作者

非常感谢你的打赏,我们将继续提供更多优质内容,让我们一起创建更加美好的网络世界!

支付宝扫一扫

微信扫一扫

登录

找回密码

注册