RMAN backup details, Display last 5 days
Following query can be used to get rman backup job details for last 5 days.
1 2 3 4 5 6 7 8 9 10 |
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; |