SELECT
ctime "Date",
Decode(
backup_type, 'L', 'Archive Log', 'D',
'Full', 'Incremental'
) backup_type,
bsize "Size GB"
FROM
(
SELECT
Trunc(bp.completion_time) ctime,
backup_type,
Round( SUM(bp.bytes / 1024 / 1024 /1024 ), 2 ) bsize
FROM
v$backup_set bs,
v$backup_piece bp
WHERE
bs.set_stamp = bp.set_stamp
AND bs.set_count = bp.set_count
AND bp.status = 'A'
GROUP BY
Trunc(bp.completion_time),
backup_type
)
ORDER BY 1, 2;
Date BACKUP_TYPE Size GB
-------- ----------- ----------
13/04/21 Full 103,16
14/04/21 Full 103,19
15/04/21 Full 103,4
17/04/21 Archive Log 1,5
17/04/21 Full 124,78
18/04/21 Archive Log 1,49
18/04/21 Full 124,85
19/04/21 Archive Log 6,84
19/04/21 Full 125,07