Difference between revisions of "RMAN"
From dbawiki
(→A collection of useful bits and pieces I used on a regular basis when I was using RMAN) |
(→Script to check what has been backed up) |
||
| Line 1: | Line 1: | ||
| − | == | + | ==Query to check the status of the database backups== |
select s.db_name | select s.db_name | ||
, s.status | , s.status | ||
Revision as of 21:39, 22 November 2011
Query to check the status of the database backups
select s.db_name
, s.status
, max(s.start_time) start_time
, max(round(s.mbytes_processed/1024)) "processed_data(GB)"
, max(round((end_time-start_time)*60*24)) "duration(min)"
, trunc(sysdate)-trunc(s.start_time) days_since_last_backup
from rman.rc_rman_status s
where 1=1
and lower(s.operation) = 'backup'
and lower(s.object_type) ='db full'
and s.start_time =
(
select max(md.start_time)
from rman.rc_rman_status md
where 1=1
and lower(md.operation) = 'backup'
and lower(md.object_type) ='db full'
and md.db_name = s.db_name
)
group by s.db_name
, s.object_type
, s.operation
, s.status
, trunc(sysdate)-trunc(s.start_time)
order by trunc(sysdate)-trunc(s.start_time) desc
