今天把一个rac的数据重启时遇到了如下错误,提示找不到一个叫fgdg的磁盘组资源:[grid@srcbdb1 ~]$ srvctl start database -d dc
今天把一个rac的数据重启时遇到了如下错误,提示找不到一个叫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.
改磁盘组的确不存在,之前删除掉了,,而且使用crsctl -t -v查看资源组时的确没有看大:
[grid@srcbdb1 ~]$ cs
name type r/ra f/ft target state host
----------------------------------------------------------------------
ora.data.dg ora....up.type 0/5 0/ online online srcbdb1
ora....er.lsnr ora....er.type 0/5 0/ online online srcbdb1
ora....n1.lsnr ora....er.type 0/5 0/0 online online srcbdb2
ora....n2.lsnr ora....er.type 0/5 0/0 online online srcbdb1
ora....n3.lsnr ora....er.type 0/5 0/0 online online srcbdb1
ora.sfra.dg ora....up.type 0/5 0/ online online srcbdb1
ora.asm ora.asm.type 0/5 0/ online online srcbdb1
ora.cvu ora.cvu.type 0/5 0/0 online online srcbdb1
ora.dcdb.db ora....se.type 0/2 0/1 offline offline
ora.gsd ora.gsd.type 0/5 0/ offline offline
ora....network ora....rk.type 0/5 0/ online online srcbdb1
ora....network ora....rk.type 0/5 0/ offline offline
ora.oc4j ora.oc4j.type 0/5 0/0 online online srcbdb1
ora.ons ora.ons.type 0/3 0/ online online srcbdb1
ora....ry.acfs ora....fs.type 0/5 0/ online online srcbdb1
ora.scan1.vip ora....ip.type 0/0 0/0 online online srcbdb2
ora.scan2.vip ora....ip.type 0/0 0/0 online online srcbdb1
ora.scan3.vip ora....ip.type 0/0 0/0 online online srcbdb1
ora....sm1.asm application 0/5 0/0 online online srcbdb1
ora....b1.lsnr application 0/5 0/0 online online srcbdb1
ora....db1.gsd application 0/5 0/0 offline offline
ora....db1.ons application 0/3 0/0 online online srcbdb1
ora....db1.vip ora....t1.type 0/0 0/0 online online srcbdb1
ora....sm2.asm application 0/5 0/0 online online srcbdb2
ora....b2.lsnr application 0/5 0/0 online online srcbdb2
ora....db2.gsd application 0/5 0/0 offline offline
ora....db2.ons application 0/3 0/0 online online srcbdb2
ora....db2.vip ora....t1.type 0/0 0/0 online online srcbdb2
因此怀疑是之前删除该磁盘组后,database资源的配置信息没有被更新,查看一下database资源的配置发现:
[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=1h
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
在database的启动和停止的关联资源中的确有fgdg磁盘组资源,而这是不存在的,于是使用如下命令修改database关联的asm磁盘组
[grid@srcbdb2 ~]$ srvctl modify database -d dcdb -a data,sfra
