Search This Blog

2008-10-08

Low level RMAN backup size

All RMAN backup detail are log into RMAN repository database. It is quick and useful to query the database to obtain backup size, and total size

Following query can shown last 14 days' RMAN incremental level 1 and above's backup size:
select db_name, bs_key, count(*), sum(blocks*block_size)/1024/1024 mb
from rc_backup_datafile where bs_key in
(select bs_key from rc_backup_set
where start_time > sysdate -14
and backup_type = 'I')
group by db_name, bs_key;

Following query will shown last 14 days' RMAN level 0 backup
select db_name, bs_key, count(*), sum(blocks*block_size)/1024/1024/1024 gb
from rc_backup_datafile where bs_key in
(select bs_key from rc_backup_set
where start_time > sysdate -14
and backup_type = 'D')
group by db_name, bs_key;

No comments:

Blog Archive