My Oracle Support Banner

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

Last updated on AUGUST 10, 2018

Applies to:

Enterprise Manager for Oracle Database - Version to [Release 10.2]
Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


The following message is reported by the enterprise manager alerts :

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;


To view full details, 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 a vibrant support community of peers and Oracle experts.