正德厚生,臻于至善

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
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

联系我们

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

支付宝扫一扫打赏

微信扫一扫打赏