Enterprise Manager

EM-GC 11.1 on Linux
Database 11.2 on Solaris

Hello,

It might be a long shot, but I hope somebody could suggest a solution:

I have created "Backups status" rule in EM GC 11.1 as based on UDM - user defined metrics (in repository).

(User-Defined String Metric All Objects (Metric ID;Key) Critical )

Backup status STRING

MATCH
FAILED

The UDM are created for EM repository and quering the

mgmt$ha_backup

as

select DATABASE_NAME, status from mgmt$ha_backup where status='FAILED';

---------------------------------------------------------------------

There is one particular database we receive email notifications every day that the backup has FAILED.

In the reality the backup status - in EM is COMPLETED

in repository:

SQL> select DATABASE_NAME, status from mgmt$ha_backup where status='FAILED';

no rows selected
------

(It looks to me that at some point of time during the backup, somehow the status in repository is FAILED and this is used for notification.)



I'd appreciate any suggestions on this matter.

Thx,