Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Backup status monitoring

906815Mar 14 2013 — edited Jun 5 2013
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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2013
Added on Mar 14 2013
7 comments
2,670 views