Restart database encountered PRCR-1079, CRS-2640

I encountered the following error when I restarted data of a rac today, prompting that I could not find a disk group resource named FGDG:

[Grid @ srcbdb1 ~] $ Srvctl start database-d dcdb

PRCR-1079: Failed to start resource ora. dcdb. db

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

The disk to be modified does not exist. It was deleted before, and it is not large when you use crsctl-t-v to view the resource group:

[Grid @ srcbdb1 ~] $ Cs
Name Type R/ra f/FT Target State Host
----------------------------------------------------------------------
Ora. DATA. dg ora... up. type 0/5 0/ONLINE srcbdb1
Ora... ER. lsnr ora... er. type 0/5 0/ONLINE srcbdb1
Ora... N1.lsnr ora... er. type 0/5 0/0 ONLINE srcbdb2
Ora... N2.lsnr ora... er. type 0/5 0/0 ONLINE srcbdb1
Ora... N3.lsnr ora... er. type 0/5 0/0 ONLINE srcbdb1
Ora. SFRA. dg ora... up. type 0/5 0/ONLINE srcbdb1
Ora. asm ora. asm. type 0/5 0/ONLINE srcbdb1
Ora. cvu ora. cvu. type 0/5 0/0 ONLINE srcbdb1
Ora. dcdb. db ora... se. type 0/2 OFFLINE
Ora. gsd ora. gsd. type 0/5 0/OFFLINE
Ora... network ora... rk. type 0/5 0/ONLINE srcbdb1
Ora... network ora... rk. type 0/5 0/OFFLINE
Ora. productname ora. productname. type 0/5 0/0 ONLINE srcbdb1
Ora. ons ora. ons. type 0/3 0/ONLINE srcbdb1
Ora... ry. acfs ora... fs. type 0/5 0/ONLINE srcbdb1
Ora. scan1.vip ora... ip. type 0/0 ONLINE srcbdb2
Ora. scan2.vip ora... ip. type 0/0 0/0 ONLINE srcbdb1
Ora. scan3.vip ora... ip. type 0/0 0/0 ONLINE srcbdb1
Ora... SM1.asm application 0/5 0/0 ONLINE srcbdb1
Ora... B1.lsnr application 0/5 0/0 ONLINE srcbdb1
Ora... db1.gsd application 0/5 0/0 OFFLINE
Ora... db1.ons application 0/3 0/0 ONLINE srcbdb1
Ora... db1.vip ora... t1.type 0/0 0/0 ONLINE srcbdb1
Ora... SM2.asm application 0/5 0/0 ONLINE srcbdb2
Ora... B2.lsnr application 0/5 0/0 ONLINE srcbdb2
Ora... db2.gsd application 0/5 0/0 OFFLINE
Ora... db2.ons application 0/3 0/0 ONLINE srcbdb2
Ora... db2.vip ora... t1.type 0/0 0/0 ONLINE srcbdb2

Therefore, it is suspected that the configuration information of the Database resource is not updated after the disk group is deleted. Check the configuration of the database resource and find that:

[Grid @ srcbdb2 ~] $ Crsctl status resource ora. dcdb. db-f
NAME = ora. dcdb. db
TYPE = ora. database. type
STATE = OFFLINE
TARGET = OFFLINE
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 = 30
CLUSTER_DATABASE = true
CREATION_SEED = 327.
DATABASE_TYPE = RAC
DB_UNIQUE_NAME = dcdb
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 =/soft/oracle/admin/dcdb/adump
GEN_START_OPTIONS =
GEN_START_OPTIONS @ SERVERNAME (srcbdb1) = open
GEN_START_OPTIONS @ SERVERNAME (srcbdb2) = open
GEN_USR_ORA_INST_NAME =
GEN_USR_ORA_INST_NAME @ SERVERNAME (srcbdb1) = dcdb1
GEN_USR_ORA_INST_NAME @ SERVERNAME (srcbdb2) = dcdb2
HOSTING_MEMBERS =
ID = ora. dcdb. 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 =/soft/oracle/product/11.2.0.2/dbh
PLACEMENT = restricted
PROFILE_CHANGE_TEMPLATE =
RESTART_ATTEMPTS = 2
ROLE = PRIMARY
SCRIPT_TIMEOUT = 60
SERVER_POOLS = ora. dcdb
SPFILE = + DATA/dcdb/spfiledcdb. ora
START_DEPENDENCIES = hard (ora. DATA. dg,Ora. FGDG. dg) Weak (type: ora. listener. type, global: type: ora. scan_listener.type, uniform: ora. ons, global: ora. gns) pullup (ora. DATA. dg,Ora. FGDG. dg)
START_TIMEOUT = 600
STATE_CHANGE_TEMPLATE =
STOP_DEPENDENCIES = hard (intermediate: ora. asm, shutdown: ora. DATA. dg, shutdown:Ora. FGDG. dg)
STOP_TIMEOUT = 600
TYPE_VERSION = 2.2
UPTIME_THRESHOLD = 1 h
USR_ORA_DB_NAME = dcdb
USR_ORA_DOMAIN =
USR_ORA_ENV =
USR_ORA_FLAGS =
USR_ORA_INST_NAME =
USR_ORA_INST_NAME @ SERVERNAME (srcbdb1) = dcdb1
USR_ORA_INST_NAME @ SERVERNAME (srcbdb2) = dcdb2
USR_ORA_OPEN_MODE = open
USR_ORA_OPI = false
USR_ORA_STOP_MODE = immediate
VERSION = 11.2.0.2.0

The FGDG disk group resources exist in the associated resources for database startup and shutdown, but this does not exist. Therefore, run the following command to modify the asm disk group associated with the database:

[Grid @ srcbdb2 ~] $ Srvctl modify database-d dcdb-a "DATA, SFRA"

1 2 Next Page