Query RMAN Repository

From: Raj Mareddi <yoursraju007_at_gmail.com>
Date: Sat, 1 Mar 2008 08:04:29 -0500
Message-ID: <7f411f4e0803010504t38dd6fb7l2c22a3cdf5dc3746@mail.gmail.com>

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 !!!!


http://www.freelists.org/webpage/oracle-l Received on Sat Mar 01 2008 - 07:04:29 CST

Original text of this message