CRS-2640: Required resource 'ora.DG_NETAPP.dg' is missing

看图说话，哈哈

图1

图2

一大早，看到上图，整个人都不好了，哪得这么多问题。做个轻松的dba不行吗。  事情多，说明dba没有尽责。

接到通知，系统用不了，局方是8点30上班，我们是9点15，相差45分钟， 可见这45分钟，局方的人焦急的等待。年底了，运维又出问题。

米米不受影响吗？ 所以接到9个电话，压力扛不住啊

我上去看看了，果然是实例挂了， 还好crs没有挂，权限没有丢。

于是拉起实例。 先恢复再看具体原因。

但是，我看状态还是OFFLINE

于是，拉起状态

$ crs_start ora.unipsms.db
CRS-2640: Required resource 'ora.DG_NETAPP.dg' is missing.
CRS-0222: Resource 'ora.unixxxxx.db' has dependency error.

经过确认DG_NETAPP.dg是干掉了， 但是crs信息没有更新。 (unixxxxxx是代号， 涉及隐私）

$ crsctl status res ora.unixxxxxx.db -f
NAME=ora.unixxxxxx.db
TYPE=ora.database.type
STATE=ONLINE
TARGET=ONLINE
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=2
CARDINALITY_ID=0
CHECK_INTERVAL=1
CHECK_TIMEOUT=600
CLUSTER_DATABASE=true
CREATION_SEED=179
DATABASE_TYPE=RAC
DB_UNIQUE_NAME=unixxxxxx
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)
DEGREE=1
DESCRIPTION=Oracle Database resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_AUDIT_FILE_DEST=/u01/app/oracle/admin/unixxxxxx/adump
GEN_START_OPTIONS=
GEN_START_OPTIONS@SERVERNAME(psmsdb01)=open
GEN_START_OPTIONS@SERVERNAME(psmsdb02)=open
GEN_USR_ORA_INST_NAME=
GEN_USR_ORA_INST_NAME@SERVERNAME(psmsdb01)=unixxxxxx1
GEN_USR_ORA_INST_NAME@SERVERNAME(psmsdb02)=unixxxxxx2
HOSTING_MEMBERS=
ID=ora.unixxxxxx.db
INSTANCE_FAILOVER=0
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=AUTOMATIC
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
ONLINE_RELOCATION_TIMEOUT=0
ORACLE_HOME=/u01/app/oracle/product/11.3.0/dbhome_1
PLACEMENT=restricted
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=2
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_POOLS=ora.unixxxxxx
SPFILE=+DG01R10/unixxxxxx/spfileunixxxxxx.ora
START_DEPENDENCIES=hard(ora.DG01R10.dg,ora.DG02R5.dg,ora.DG02R10REDO01.dg,ora.DG03R10REDO01.dg,ora.DG_NETAPP.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.DG01R10.dg,ora.DG02R5.dg,ora.DG02R10REDO01.dg,ora.DG03R10REDO01.dg,ora.DG_NETAPP.dg)
START_TIMEOUT=600
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DG01R10.dg,shutdown:ora.DG02R5.dg,shutdown:ora.DG02R10REDO01.dg,shutdown:ora.DG03R10REDO01.dg,shutdown:ora.DG_NETAPP.dg)
STOP_TIMEOUT=600

--修改为正确的磁阵信息在crs中

$ srvctl modify database -d unipsms -a "DG01R10,DG02R10REDO01,DG02R5,DG03R10REDO01"
$ 
$

--拉起服务

$ crs_start ora.unipsms.db
Attempting to start `ora.unipsms.db` on member `psmsdb01`
CRS-5017: The resource action "ora.unipsms.db start" encountered the following error: 
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/product/11.3.0/grid/log/psmsdb01/agent/crsd/oraagent_oracle/oraagent_oracle.log".

Start of `ora.unipsms.db` on member `psmsdb01` succeeded.
Attempting to start `ora.unipsms.orcl.svc` on member `psmsdb01`
Start of `ora.unipsms.orcl.svc` on member `psmsdb01` succeeded.

--查看状态

2017.1.6  -----end-------