Query to Fetch RMAN Backup detail from query.

select
 SESSION_KEY, SESSION_RECID, SESSION_STAMP,INPUT_TYPE, STATUS,
 to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
 to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,
 round(elapsed_seconds/3600,2)           hrs,
 TIME_TAKEN_DISPLAY,
 round(INPUT_BYTES/1024/1024/1024,2) as INPUT_SIZE_GB,
 round(OUTPUT_BYTES/1024/1024/1024,2) as OUTPUT_SIZE_GB,
 round(OUTPUT_BYTES_PER_SEC/1024/1024,2) as OUTPUT_RATE_PER_SEC
 from V$RMAN_BACKUP_JOB_DETAILS
 order by start_time desc;