Today I wanted to create a report from Enterprise Manager Grid Control 11g. We have about 40 databases here (mixed, 9i/10g/11g). I would like to have a daily report of the last database backup date.
The view SYSMAN.MGMT$HA_BACKUP provides a very usefull report for backups. But there is a drawback it seems.
For 9i databases most columns are null (start_time, end_time, status, output_bytes_display etc.). So there is no usefull information on these databasebackups for 9i database (9.2.0.8 to be precise).
No comments:
Post a Comment