CRS-2640: Required resource ‘ora.DEMO.dg’ is missing

What Happened ?

After creating diskgroup DEMO for testing, I have created few tablespaces under this diskgroup and later dropped both the tablespaces and diskgroup. During the next reboot the database wasn’t started by cluster.

Issue Troubleshooting:

[root@VM1 ~]# crsctl start resource ora.test.db
CRS-2640: Required resource ‘ora.DEMO.dg’ is missing.
CRS-4000: Command Start failed, or completed with errors.

$ srvctl start database -d TEST
PRCR-1079 : Failed to start resource ora.test.db
CRS-2640: Required resource ‘ora.DEMO.dg’ is missing.

Check the resource start or shutdown dependency 

[root@VM1 ~]# crsctl status resource ora.test.db -p |grep ora.DEMO.dg
START_DEPENDENCIES=hard(ora.DATA.dg,ora.DATA2.dg,ora.DEMO.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,uniform:ora.eons) pullup(ora.DATA.dg,ora.DATA2.dg)
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.DATA2.dg,shutdown:ora.DEMO.dg)

Solution:

Remove the dependency of the diskgroup DEMO for the database

[root@VM1 ~]# srvctl modify database -d TEST -a “DATA,DATA2”

Diskgroup was already dropped manually, but try removing it using srvctl

[root@VM1 ~]# srvctl disable diskgroup -g DEMO
PRCR-1001 : Resource ora.DEMO.dg does not exist

[root@VM1 ~]# srvctl remove diskgroup -g DEMO -f
PRCR-1001 : Resource ora.DEMO.dg does not exist

Validate:

[root@VM1 ~]# crsctl status resource ora.test.db -p |grep ora.DEMO.dg

[root@VM1 ~]# srvctl start database -d TEST

[root@VM1 ~]# srvctl status database -d TEST

Instance TEST1 is running on node vm1
Instance TEST2 is running on node vm2

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s