Oracle 11GR2 RAC resource 自啟動設置

一.啟動模式
1. Manually start the diskgroup:
    srvctl start diskgroup -g [-n ""]

or
2. Modify the attribute AUTO_START to "always"
     crsctl modify resource ora..dg -attr AUTO_START=always

remark:
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.

二. 默認狀態
wmrac02$crs_stat -p ora.DATA.dg
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
ACTION_SCRIPT=
AUTO_START=never
CHECK_INTERVAL=300
DESCRIPTION=CRS resource type definition for ASM disk group resource
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_TIMEOUT=900
STOP_TIMEOUT=180
UPTIME_THRESHOLD=1d

wmrac02$crs_stat -p ora.INDX.dg
NAME=ora.INDX.dg
TYPE=ora.diskgroup.type
ACTION_SCRIPT=
AUTO_START=never
CHECK_INTERVAL=300
DESCRIPTION=CRS resource type definition for ASM disk group resource
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_TIMEOUT=900
STOP_TIMEOUT=180
UPTIME_THRESHOLD=1d

三.設置自動啟動
wmrac02$crsctl modify resource ora.DATA.dg -attr AUTO_START=always
wmrac02$crs_stat -p ora.DATA.dg
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
ACTION_SCRIPT=
AUTO_START=always
CHECK_INTERVAL=300
DESCRIPTION=CRS resource type definition for ASM disk group resource
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_TIMEOUT=900
STOP_TIMEOUT=180
UPTIME_THRESHOLD=1d

wmrac02$crsctl modify resource ora.INDX.dg -attr
wmrac02$crs_stat -p ora.INDX.dg
NAME=ora.INDX.dg
TYPE=ora.diskgroup.type
ACTION_SCRIPT=
AUTO_START=always
CHECK_INTERVAL=300
DESCRIPTION=CRS resource type definition for ASM disk group resource
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_TIMEOUT=900
STOP_TIMEOUT=180
UPTIME_THRESHOLD=1d

wmrac02$crs_stat -p ora.ccptdb.db
NAME=ora.ccptdb.db
TYPE=ora.database.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AUTO_START=restore
CHECK_INTERVAL=1
DESCRIPTION=Oracle Database resource
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_USR_ORA_INST_NAME@SERVERNAME(wmrac01)=ccptdb1
GEN_USR_ORA_INST_NAME@SERVERNAME(wmrac02)=ccptdb2
HOSTING_MEMBERS=
PLACEMENT=restricted
RESTART_ATTEMPTS=2
SCRIPT_TIMEOUT=60
START_TIMEOUT=600
STOP_TIMEOUT=600
UPTIME_THRESHOLD=1h
USR_ORA_INST_NAME@SERVERNAME(wmrac01)=ccptdb1
USR_ORA_INST_NAME@SERVERNAME(wmrac02)=ccptdb2

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25198367/viewspace-689457/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25198367/viewspace-689457/