ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 11GR2 RAC resource 自啟動設置

Oracle 11GR2 RAC resource 自啟動設置

原创 Linux操作系统 作者:golden_zhou 时间:2011-03-15 08:38:49 0 删除 编辑

一.啟動模式
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<*+ASM2*/home/grid/dba/g_bdump>$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<*+ASM2*/home/grid/dba/g_bdump>$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<*+ASM2*/home/grid/dba/g_bdump>$crsctl modify resource ora.DATA.dg -attr AUTO_START=always
wmrac02<*+ASM2*/home/grid/dba/g_bdump>$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<*+ASM2*/home/grid/dba/g_bdump>$crsctl modify resource ora.INDX.dg -attr
wmrac02<*+ASM2*/home/grid/dba/g_bdump>$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<*+ASM2*/home/grid/dba/g_bdump>$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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-09

  • 博文量
    238
  • 访问量
    301791