02 February 2012

Report with backups - created from Grid Control

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).