Hello All,
As per the Task i have to find out archive generation per day for multiple database for Capacity Management task.
As i have small doubt with below two queries :
1)
select DB_NAME, DB_KEY, to_date(COMPLETION_TIME,'DD.MM.YYYY') as DAT, round(max(blocks*block_size)/1024/1024/1024,2) as GB from RC_BACKUP_REDOLOG group by DB_NAME, DB_KEY, to_date(COMPLETION_TIME,'DD.MM.YYYY');
2)
SELECT TRUNC(completion_time) "Generation Date" ,
round(SUM(blocks*block_size)/1048576,0) "Total for the Day in MB"
FROM v$archived_log
where completion_time between ('01-JAN-14') AND ('06-NOV-14')
GROUP BY TRUNC(completion_time)
ORDER BY TRUNC(completion_time)
/
Both Output seems difference and i want to know archive generation from 1-Jan-2014 to till date , As archived_log blocks and block_size what exactly this means .