今天把一个rac的数据重启时遇到了如下错误,提示找不到一个叫FGDG的磁盘组资源:
[grid@srcbdb1 ~]$ srvctl start database -d dcdb
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资源的配置发现:
在database的启动和停止的关联资源中的确有FGDG磁盘组资源,而这是不存在的,于是使用如下命令修改database关联的asm磁盘组
[grid@srcbdb2 ~]$ srvctl modify database -d dcdb -a "DATA,SFRA"