11.2.0.3 RAC 里怎么手工添加一个DG资源？

武汉-SSH

升级的时候没有仔细检查，结果，ASM PFILE里只有DATA，没有FRA，所以升级后只有一个ora.DATA.dg的资源。
现在PFILE已修改，FRA DG 已 MOUNT。

不会仅此而已吧？
crsctl add resource ora.FRA.dg -type ora.diskgroup.type

武汉-SSH

答案：
crsctl stat res ora.DATA.dg -p > ora.DATA.dg
vim ora.DATA.dg

cat ora.DATA.dg

NAME=ora.FRA.dg     //修改这里
TYPE=ora.diskgroup.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=never
CHECK_INTERVAL=300
CHECK_TIMEOUT=30
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=CRS resource type definition for ASM disk group resource
ENABLED=1
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=hard(ora.asm) pullup(ora.asm)
START_TIMEOUT=900
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm)
STOP_TIMEOUT=180
TYPE_VERSION=1.2
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
USR_ORA_STOP_MODE=
VERSION=11.2.0.3.0

crsctl add res ora.FRA.dg -type ora.diskgroup.type -file ora.DATA.dg

crsctl start res ora.FRA.dg

crsctl stat res ora.FRA.dg
NAME=ora.FRA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE          , ONLINE
STATE=ONLINE on node01, ONLINE on node02

Maclean Liu(刘相兵

自问自答？  Great Post

武汉-SSH

但是为什么这个地方的  AUTO_START=never  呢？

Maclean Liu(刘相兵

[root@vrh2 ~]# cat /etc/oracle/ocr.loc
ocrconfig_loc=+systemdg
local_only=FALSE

The OCR diskgroup is auto mounted by the ASM instance during startup. The CRSD and ASM
dependency is maintained by OHASD.

ASM has to be up with the diskgroup mounted before any OCR operations can be
performed. There are bugs reported when the diskgroup having OCR was dismounted force
and/or ASM instance was shutdown abort.
When the stack is running, CRSD keeps reading/writing OCR.
OHASD maintains the resource dependency and will bring up ASM with the required
diskgroup mounted before it starts CRSD.

Maclean Liu(刘相兵

NON-OCR/Votedisk

[root@vrh2 ~]# crsctl stat res ora.DATA.dg -p
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=always
CHECK_INTERVAL=300
CHECK_TIMEOUT=30
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=CRS resource type definition for ASM disk group resource
ENABLED=1
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=hard(ora.asm) pullup(ora.asm)
START_TIMEOUT=900
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm)
STOP_TIMEOUT=180
TYPE_VERSION=1.2
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
USR_ORA_STOP_MODE=
VERSION=11.2.0.3.0

武汉-SSH

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.