Backup status monitoring
906815Mar 14 2013 — edited Jun 5 2013EM-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,