exadata establish dependency

exadata alert_xx.log:

ERROR: failed to establish dependency between database edw and diskgroup resource ora.DATA_DM01.dg
ERROR: failed to establish dependency between database edw and diskgroup resource ora.RECO_DM01.dg

Fri Aug 03 16:44:05 2012
NOTE: dependency between database edw1 and diskgroup resource ora.RECO_DM01.dg is established

-- MOS:
ERROR: failed to establish dependency between database <database name> and diskgroup resource ora.<diskgroup name>.dg [ID 1474954.1]

In this Document

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Goal

Alert logfile of the database shows the error as follows:-

ERROR: failed to establish dependency between database <database name> and diskgroup resource ora.<diskgroup name>.dg

Example:

ERROR: failed to establish dependency between database ERPREP and diskgroup resource ora.DATA.dg

Fix

This error is harmless.
Documented in Bug 8304720
Abstract: ERROR: FAILED TO ESTABLISH DEPENDENCY BETWEEN DB & DISKGROUP
This is an internal BUG.

The db-dg dependency will be created later on if the diskgroup is used by the db again; the dependency can also be created manually through cmdline tool.

Automatically it will resolve itself later on when the db tries to use the diskgroup. Or we can manually establish the dependancy through any command line utility.

For establishing dependencies between database and diskgroups, please use DB home owner running srvctl from DB home with

$ srvctl modify database -d <db_name> -a "<diskgroup_list>"

For example:
$ srvctl modify database -d db112 -a "DATA,FRA"

References

@ BUG:8304720 - SIHA: ERROR: FAILED TO ESTABLISH DEPENDENCY BETWEEN DB & DISKGROUP

srvctl status database -d xxx
srvctl modify database -d xxx -a "DATA_DM01,RECO_DM01"

-----
select name, state from v$asm_diskgroup;

NAME STATE
---------- --------
DATA_DM01 MOUNTED
DBFS_DG MOUNTED
RECO_DM01 MOUNTED

本文出自 “mr.DATABASE” 博客,谢绝转载!

Database error: [Table 'ac_search_cache' is marked as crashed and should be repaired]

SELECT * FROM ac_search_cache WHERE hash = 'c28d4c8fb0bc7ff7441e2be905eda093bc0a653b' LIMIT 1;