您好,欢迎访问一九零五行业门户网

重启数据库遇到PRCR-1079,CRS-2640

今天把一个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
其它类似信息

推荐信息