Verifica Archivos Gerados no Ultimo Backup Full RMAN

set lines 200 pagesize 80
col TAG for a20
col DEVICE for a8
col CAMINHO for a65
col INICIO for a15
col FINAL for a17
col TAMANHO_TOTAL for a15
col TAMANHO for a10
set feedback off
set timing on
alter session set nls_date_format='dd/mm/yy hh24:mi';
select     /*+ rule */ tag
    ,device_type as DEVICE
    ,handle as CAMINHO
    ,START_TIME as INICIO
    ,COMPLETION_TIME as FINAL
    ,SIZE_BYTES_DISPLAY as TAMANHO
from v$backup_piece_details
where session_recid = (select max(session_recid) from V$RMAN_BACKUP_JOB_DETAILS where START_TIME > sysdate-10 and input_type in('DB FULL', 'DB INCR') and status = 'COMPLETED')
and START_TIME > sysdate -30
order by START_TIME;
select     /*+ rule */  TO_CHAR(sum(bytes)/1024/1024,'9G999G999D9')  as TAMANHO_TOTAL
from v$backup_piece_details
where session_recid = (select max(session_recid) from V\$RMAN_BACKUP_JOB_DETAILS where START_TIME > sysdate-10 and input_type in('DB FULL', 'DB INCR') and    status = 'COMPLETED')
and    START_TIME > sysdate -30;