Query - Checking RMAN Backup Status

Query - Checking RMAN Backup Status

set linesize 150
col INSTANCE for a9
col ELAPSED for a30
 SELECT      (  SELECT   instance_name FROM v$instance)
              || ' '
              || (  SELECT   instance_number FROM v$instance)
                 instance,
            --  TO_CHAR (start_time, 'yyyy-mm-dd hh24:mi') start_time,
       to_date (start_time, 'dd-mm-yyyy hh24:mi:ss') start_time,
              TO_CHAR (output_bytes / 1048576, '999,999,999.9') output_mb,
              TO_CHAR (output_bytes_per_sec / 1048576, '999,999.9') mb_S,
              time_taken_display elapsed,input_type,
            status
     FROM   v$rman_backup_job_details
     where start_time >= sysdate - &Days
 ORDER BY   start_time;