SELECT A.RECID "BACKUP SET",

          A.SET_STAMP,

          DECODE (B.INCREMENTAL_LEVEL,

                  '', DECODE (BACKUP_TYPE, 'L', 'Archivelog', 'Full'),

                  1, 'Incr-1级',

                  0, 'Incr-0级',

                  B.INCREMENTAL_LEVEL)

             "Type LV",

          B.CONTROLFILE_INCLUDED "包含CTL",

          DECODE (A.STATUS,

                  'A', 'AVAILABLE',

                  'D', 'DELETED',

                  'X', 'EXPIRED',

                  'ERROR')

             "STATUS",

          A.DEVICE_TYPE "Device Type",

          A.START_TIME "Start Time",

          A.COMPLETION_TIME "Completion Time",

          A.ELAPSED_SECONDS "Elapsed Seconds",

          --a.BYTES/1024/1024/1024 "大小(G)",

          --a.COMPRESSED,

          A.TAG "Tag",

          A.HANDLE "Path"

     FROM GV$BACKUP_PIECE A, GV$BACKUP_SET B

    WHERE A.SET_STAMP = B.SET_STAMP AND A.DELETED = 'NO' and  a.set_count = b.set_count

 ORDER BY A.COMPLETION_TIME DESC;

 SELECT distinct c.file#,A.SET_STAMP, D.NAME, C.CHECKPOINT_CHANGE#, C.CHECKPOINT_TIME

   FROM V$BACKUP_DATAFILE C, V$BACKUP_PIECE A, V$DATAFILE D

  WHERE A.SET_STAMP = C.SET_STAMP

 AND D.FILE# = C.FILE#

 AND A.DELETED='NO'

 AND c.set_stamp=&set_stamp

 ORDER BY C.FILE#;

 SELECT DISTINCT A.SET_STAMP,

                 D.NAME,

                 C.CHECKPOINT_CHANGE#,

                 C.CHECKPOINT_TIME

   FROM V$BACKUP_DATAFILE C, V$BACKUP_PIECE A, V$CONTROLFILE D

  WHERE A.SET_STAMP = C.SET_STAMP

    AND C.FILE# = 0

    AND A.DELETED = 'NO'

    AND C.SET_STAMP = &SET_STAMP;

 SELECT DISTINCT B.SET_STAMP,

                 B.THREAD#,

                 B.SEQUENCE#,

                 B.FIRST_TIME,

                 B.FIRST_CHANGE#,

                 B.NEXT_TIME,

                 B.NEXT_CHANGE#

   FROM V$BACKUP_REDOLOG B, V$BACKUP_PIECE A

  WHERE A.SET_STAMP = B.SET_STAMP

    AND A.DELETED = 'NO'

    AND B.SET_STAMP = &SET_STAMP

  ORDER BY THREAD#, SEQUENCE#;

 SELECT DISTINCT A.SET_STAMP, B.COMPLETION_TIME, HANDLE

   FROM V$BACKUP_SPFILE B, V$BACKUP_PIECE A

  WHERE A.SET_STAMP = B.SET_STAMP

    AND A.DELETED = 'NO'

    AND B.SET_STAMP = &SET_STAMP;

SELECT NAME,VALUE FROM V$RMAN_CONFIGURATION;

 SELECT * FROM V$RMAN_STATUS

 WHERE START_TIME >= TO_DATE(&START_TIME,'YYYY-MM-DD HH24:MI:SS')

   AND END_TIME   <= TO_DATE(&END_TIME  ,'YYYY-MM-DD HH24:MI:SS')

   AND OPERATION ='BACKUP'

   AND STATUS !='COMPLETED'

   AND STATUS NOT LIKE 'RUNNING%'

 SELECT * FROM V$RMAN_STATUS

 WHERE START_TIME >= TO_DATE(&START_TIME,'YYYY-MM-DD HH24:MI:SS')

   AND END_TIME   <= TO_DATE(&END_TIME  ,'YYYY-MM-DD HH24:MI:SS')

   AND OPERATION ='BACKUP'

   AND STATUS ='COMPLETED'