Oracle 检查自上一次成功全量备份及之后备份状态检查的SQL

自己整理了一个检查自上一次成功全量备份及之后备份状态检查的SQL，如有什么建议，欢迎评论区告知。

SELECT DISTINCT
       R.STAMP,
       R.OBJECT_TYPE,
       DECODE (B.INCREMENTAL_LEVEL,
               '', DECODE (B.BACKUP_TYPE, 'L', 'Arch', 'Full'),
               1, 'Incr-1',
               0, 'Incr-0',
               B.INCREMENTAL_LEVEL)                        "Type_LV",
       DECODE (A.STATUS,
               'A', 'AVAILABLE',
               'D', 'DELETED',
               'X', 'EXPIRED',
               'ERROR')                                    "BackSet_Status",
       A.DEVICE_TYPE                                       "Device_Type",
       R.STATUS                                            "RMAN_Status",
       TO_CHAR (R.START_TIME, 'YYYY/MM/DD HH24:MI:SS')     "Start_Time",
       TO_CHAR (R.END_TIME, 'YYYY/MM/DD HH24:MI:SS')       "End_Time",
       ROUND (R.INPUT_BYTES / 1024 / 1024 / 1024, 2)       "Input_GB",
       ROUND (R.OUTPUT_BYTES / 1024 / 1024 / 1024, 2)      "Output_GB",
       ROUND ((R.END_TIME - R.START_TIME) * 24 * 60, 2)    "Run_Mins"
  FROM V$RMAN_STATUS  R,
       GV$BACKUP_SET  B,
       GV$BACKUP_PIECE A,
       (SELECT MAX (R1.START_TIME)     LAST_FULLBACK_TIME
          FROM V$RMAN_STATUS R1, GV$BACKUP_SET B1, GV$BACKUP_PIECE A1
         WHERE     A1.RMAN_STATUS_STAMP = R1.STAMP
               AND A1.RMAN_STATUS_RECID = R1.RECID
               AND A1.SET_STAMP = B1.SET_STAMP
               AND B1.BACKUP_TYPE IN ('D', 'I')
               AND R1.STATUS IN ('COMPLETED', 'COMPLETED WITH WARNINGS')
               AND (   ( R1.OBJECT_TYPE = 'DB INCR' AND B1.INCREMENTAL_LEVEL = 0)
                    OR ( R1.OBJECT_TYPE = 'DB FULL' AND B1.INCREMENTAL_LEVEL IS NULL))
               AND R1.OPERATION = 'BACKUP'
               AND R1.OBJECT_TYPE IN ('DB INCR', 'DB FULL')
               AND R1.START_TIME >= SYSDATE - 8) T
 WHERE     A.RMAN_STATUS_STAMP = R.STAMP
       AND A.RMAN_STATUS_RECID = R.RECID
       AND A.SET_STAMP = B.SET_STAMP
       AND R.START_TIME >= T.LAST_FULLBACK_TIME
       AND R.OPERATION = 'BACKUP'
       AND R.OBJECT_TYPE IN ('DB INCR', 'DB FULL')
ORDER BY "Start_Time";