RE: Query RMAN Repository

From: <>
Date: Sun, 2 Mar 2008 01:18:56 -0700
Message-ID: <001201c87c3e$11e58450$6501a8c0@BHAIRAVIPC01>

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: [] 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 !!!!

-- Received on Sun Mar 02 2008 - 02:18:56 CST

Original text of this message