/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.
最新评论
这个牛
放下欲望,男人从来不醉,充分且必要
勇气、责任、自信、创新,为天下先!
软件即数据,软件即服务,软件即管理,软件就是对人类各种社会活动的仿真和记录。软件很重要,但软件不可能凌驾于业务之上,尤其不可能高人一等。