Analise de Backups - RMAN - Oracle

select operation,object_type,status,output_device_type,
to_char(end_time,'DD-MM-RRRR HH24:MI:SS'),
round(MBYTES_PROCESSED/1024,2)
from
v$rman_status
where
operation <> 'CATALOG'
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time;