Scripts-Queries

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;