Last 7 Days Archivelog Backup Information

Script for Last 7 Days Archivelog  Backup Information

select trunc(COMPLETION_TIME) for_date,min(SEQUENCE#) start_number,max(SEQUENCE#) end_number,MAX(SEQUENCE#)-MIN(SEQUENCE#),lpad(count(1),5) TOTAL, round(sum((block_size*blocks)/1024/1024/1024),2) “SIZE(GB)”
from v$ARCHIVED_LOG
where trunc(COMPLETION_TIME)<= trunc(sysdate) and COMPLETION_TIME >= (sysdate)-7
group by trunc(COMPLETION_TIME)
order by for_date;