6 Replies Latest reply: Mar 18, 2013 6:30 PM by div RSS

    How to monitor all the RMAN  jobs using single script in recovery catalog?

    990636
      I am using rman recovery catalog,All the databases are registered to catalog database,Is there any script to monitor all the registered databases in recovery catalog.

      i have script which shows only the last time success jobs from recovery catalog

      select name, full, inc, log, ctl
      from
      rman.rc_database d,
      (select db_id, to_char(max(START_TIME),'MM/DD/YYYY:HH24:MI:SS') full
      from rman.rc_backup_set s
      where s.backup_type in ('D')
      and controlfile_included = 'NONE'
      group by db_id) f,
      (select db_id, to_char(max(START_TIME),'MM/DD/YYYY:HH24:MI:SS') inc
      from rman.rc_backup_set s
      where s.backup_type in ('I')
      group by db_id) i,
      (select db_id, to_char(max(START_TIME),'MM/DD/YYYY:HH24:MI:SS') log
      from rman.rc_backup_set s
      where s.backup_type in ('L')
      group by db_id) l,
      (select db_key, to_char(max(completion_TIME),'MM/DD/YYYY:HH24:MI:SS') ctl
      from rman.rc_backup_controlfile s
      group by db_key) c
      where f.db_id(+) = d.dbid
      and i.db_id(+) = d.dbid
      and l.db_id(+) = d.dbid
      and c.db_key(+) = d.db_key
      order by 1;

      Edited by: 987633 on Feb 12, 2013 9:03 AM