Message "NUMBER OF MISSING MEDIA FILES IS XX" is Reported By OEM (Doc ID 790261.1)

Last updated on DECEMBER 06, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.3 to 10.2.0.4 [Release 10.2]
Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 20-Jan-2012***


Symptoms

The following message is reported by the enterprise manager alerts :
'NUMBER OF MISSING MEDIA FILES IS XX'

This is according to the OEM metric (Missing Media File Count) .
This metric represents the count of missing media files.

This is a database-level metric. For cluster databases, this metric is monitored at the cluster database target level and not by member instances.

Evaluated and Collected every 15 minutes .

The following query is used to collect the metric information :

SELECT count(file#)
FROM   v$datafile_header
WHERE  recover='YES' OR error is not null;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms