V$BACKUP_SPFILE_SUMMARY

select
num_files_backed,        -- NUM_FILES_BACKED NUMBER
num_distinct_files_backed, -- NUM_DISTINCT_FILES_BACKED NUMBER
min_modification_time,   -- MIN_MODIFICATION_TIME DATE
max_modification_time,   -- MAX_MODIFICATION_TIME DATE
input_bytes,             -- INPUT_BYTES NUMBER
sys.dbms_rcvman.num2displaysize -- INPUT_BYTES_DISPLAY VARCHAR2(4000)
  (input_bytes) input_bytes_display 
from
(
select
count (*) num_files_backed,
min (modification_time) min_modification_time,
max (modification_time) max_modification_time,
sum (bytes) input_bytes 
from
v$backup_spfile 
where
(set_stamp,
set_count) in (
select
set_stamp,
set_count 
from
v$backup_set_details)),
(
select
count (*) num_distinct_files_backed 
from
(
select
unique modification_time 
from
v$backup_spfile 
where
(set_stamp,
set_count) in (
select
set_stamp,
set_count 
from
v$backup_set_details)))
home |  up  |  mailbox