RMAN Catalog Backup Report

WITH bkp AS ( SELECT db_name, input_type, max(end_time) end_time FROM rman.rc_rman_backup_job_details WHERE end_time > sysdate - 1 GROUP BY input_type, db_name) SELECT b.db_name database, b.input_type, b.status, to_char(b.start_time,'DD-MON-YYYY HH24:MI') start_time, to_char(b.end_time,'DD-MON-YYYY HH24:MI') end_time, b.time_taken_display time_taken, b.output_device_type output_device, b.output_bytes_display bkp_size, b.output_bytes_per_sec_display "BKP_RATE/s" FROM rman.rc_rman_backup_job_details b, bkp a WHERE b.db_name = a.db_name and b.input_type = a.input_type and b.end_time = a.end_time ORDER BY b.input_type desc, b.db_name