RMAN Overall Progress

Datafile Size


SELECT d.FILE#,D.NAME "Datafile",D.BYTES/1024/1024/1024 "GBs",
       T.NAME "Tablespace"
FROM   v$datafile D
       JOIN V$TABLESPACE T ON d.ts#=T.TS#
       ORDER BY bytes DESC

==================================================
To check RMAN Progress

select recid
     , output_device_type
     , dbsize_mbytes
     , input_bytes/1024/1024/1024 input_GBs
     , output_bytes/1024/1024/1024 output_GBs
     , (output_bytes/input_bytes*100) compression
     , (mbytes_processed/dbsize_mbytes*100) "complete%"
     , to_char(start_time + (sysdate-start_time)/(mbytes_processed/dbsize_mbytes),'DD-MON-YYYY HH24:MI:SS') est_complete
  from v$rman_status rs
     , (select sum(bytes)/1024/1024 dbsize_mbytes from v$datafile) 
 where status='RUNNING'
   and output_device_type is not null