RMAN Backup Listing

col status heading 'Status' for a10
col input_type heading 'Type' for a9
col output_bytes_display heading 'Size' for a10
col time_taken_display heading 'Time|Taken' for a10
col output_bytes_per_sec_display heading 'Output|Rate|Per Sec' for a10
col input_bytes_display heading 'Input|Size' for a10

set line 300 pagesize 200 echo off termout on
set verify off feedback off

SELECT
substr(db_name,1,5) "DB",
status,
input_type,
TO_CHAR(start_time,'mm/dd/yy hh:mi:ss am') "Start Time",
TO_CHAR(end_time,'mm/dd/yy hh:mi:ss am') "End Time",
output_bytes_display,
time_taken_display,
output_bytes_per_sec_display,
input_bytes_display
FROM
rcat.rc_rman_backup_job_details
where db_name in ('ORCL')
--and start_time > (sysdate-100)
--and input_type <> 'ARCHIVELOG'
ORDER BY
db_name,
start_time;