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;
Recent Comments