Backup History

RMAN backup details, Display last 5 days

Following query can be used to get rman backup job details for last 5 days.

set lines 220
col output_bytes_display for a30
col time_taken_display for a30
select session_key,input_type,status,
	   to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,
       to_char(end_time,'yyyy-mm-dd hh24:mi') end_time,
       output_bytes_display,       time_taken_display
from v$rman_backup_job_details
where END_TIME > sysdate-5
order by session_key asc;