Requête Oracle pour vérifier l'état des sauvegardes RMAN

alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss';

SET LINESIZE 220
SET PAGESIZE 40

COL input_bytes_display    FOR a10
COL output_bytes_display   FOR a10
COL output_device_type     FOR a15
COL operation               FOR a18
COL input_type              FOR a15
COL status                  FOR a15 
COL name                    FOR a60
COL value                   FOR a75
COL start_time               FOR a20
COL end_time                 FOR a20
COL incremental_level        FOR a10
COL level_back                FOR a15

SELECT DISTINCT 
       i.instance_name,
       r.session_key,
       TO_CHAR(r.start_time, 'DD/MM/YYYY hh24:mi:ss') AS start_time,
       TO_CHAR(r.end_time,   'DD/MM/YYYY hh24:mi:ss') AS end_time, 
       DECODE(d.incremental_level,
              0, 'BACKUP FULL',
              1, 'INCR 1',
              NULL, 'ARCH',
              'OTHER') AS level_back,
       r.input_bytes_display,
       r.output_bytes_display,
       r.output_device_type,
       r.input_type,
       r.status
FROM   v$rman_backup_job_details r,
       v$backup_set_details d,
       v$instance i
WHERE  d.session_key   = r.session_key
  AND  d.session_recid = r.session_recid
  AND  d.incremental_level IN (0, 1)
  AND  r.end_time > SYSDATE - 60
ORDER BY 2;