List RMAN backups size
SQL script for calculating the total size of RMAN backups col TYPE for a20 Heading "Backup Type" col completion_time Heading "Completion Time" col MB for 99999999999 Heading "Size (MB)" col BCPTIME for 99999999999 Heading "Backup Time (minutes)" SELECT TO_CHAR (completion_time, 'YYYY-MON-DD') completion_time , TYPE , ROUND (SUM (bytes) / 1048576) MB , ROUND (SUM (elapsed_seconds) / 60) BCPTIME FROM (SELECT CASE WHEN s.backup_type = 'L' THEN 'Archive Log' -- WHEN s.controlfile_included = 'YES' THEN 'Control File' WHEN s.backup_type = 'D' THEN 'Full (Level ' || NVL (s.incremental_level, 0) || ')' ...