Failed To Establish Dependency Between Database And Diskgroup

Today the following error message appears in a database that I manage.

Thread 1 advanced to log sequence 92492 (LGWR switch)
  Current log# 2 seq# 92492 mem# 0: +CHAO_PROD_DG/chao/onlinelog/group_2.257.788801409
Archived Log entry 181490 added for thread 1 sequence 92491 ID 0x2928345 dest 1:
Thu May 28 18:19:46 2015
ERROR: failed to establish dependency between database chao and diskgroup resource ora.CHAO_PROD_ARCCHAO1_DG.dg
Thu May 28 18:19:47 2015
SUCCESS: diskgroup CHAO_PROD_ARCCHAO2_DG was mounted
ERROR: failed to establish dependency between database chao and diskgroup resource ora.CHAO_PROD_ARCCHAO2_DG.dg
Thu May 28 18:22:04 2015
Auto-tuning: Starting background process GTX1
Starting background process GTX1

This is the Bug 8.304720 “ERROR: FAILED TO ESTABLISH DEPENDENCY BETWEEN DB & diskGroup” This error is harmless. Automatically it will resolve itself later on when the db tries to use the diskgroup.

The solution is to create dependency from srvctl, for example

srvctl modify database -d CHAO -a “CHAO_PROD_ARCCHAO1_DG,CHAO_PROD_ARCCHAO2_DG”

HTH – Antonio NAVARRO

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