RE: Query RMAN Repository
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)
President/Executive Architect, Quasar Database Technologies, LLC
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Raj Mareddi
Sent: Saturday, March 01, 2008 6:04 AM
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 !!!!
http://www.freelists.org/webpage/oracle-l Received on Sun Mar 02 2008 - 02:18:56 CST