Verifica Ultimos Backups de Archives Gerados

set pages 200 lines 200
set feedback off
col handle format a75
col tag format a25
col DEVICE_TYPE format a10
col TAMANHO for a10
col INICIO for a20
col FINAL for a20
set timing on
alter session set nls_date_format='dd/mm/yy hh24:mi';
select /*+ rule */ tag
    ,device_type
    ,handle
    ,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) -5    from V$RMAN_BACKUP_JOB_DETAILS    where START_TIME > sysdate-10 and input_type in('ARCHIVELOG') and status = 'COMPLETED')   
and START_TIME > sysdate -30 order by START_TIME;