This discussion is archived
6 Replies Latest reply: Mar 18, 2013 4:30 PM by div RSS

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

990636 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points