Query to find RMAN Backup log from SQL 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;

Fetch  the RECID & SESSION_STAMP value  from above  query & execute below with values  

select output from GV$RMAN_OUTPUT
 where session_recid = 14820
 and session_stamp = 1045161004
 order by recid;