You could try rc_backup_datafile.datafile_blocks with filter on completion_time (or checkpoint_time) Regards, -Krish Krish Hariharan President/Executive Architect, Quasar Database Technologies, LLC http://www.linkedin.com/in/quasardb _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Raj Mareddi Sent: Saturday, March 01, 2008 6:04 AM To: oracle-l Subject: Query RMAN Repository I am trying to find out file size, name as of date/ sequence number. For example, I want to know what the datafile sizes last month were (Assume that RMAN backup is taken everyday). I found the following tables interesting but they are not documented. rc_datafile , offr Any ideas ? Thanks. -- !!! In the confrontation between the stream and the rock, the stream always wins - not through strength, but through persistence. -Buddha !!!!