RE: Query RMAN Repository

  • From: <krish.hariharan@xxxxxxxxxxxx>
  • To: <yoursraju007@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 2 Mar 2008 01:18:56 -0700

You could try rc_backup_datafile.datafile_blocks with filter on
completion_time (or checkpoint_time)




Krish Hariharan

President/Executive Architect, Quasar Database Technologies, LLC


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 ?

!!! In the confrontation between the stream and the rock, the stream always
wins - not through strength, but through persistence.  -Buddha !!!! 

Other related posts: