Re: What controls RMAN history size in controlfile?

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
  • Date: Tue, 29 Sep 2009 20:26:19 +0100

On Tue, Sep 29, 2009 at 7:57 PM, Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx
> wrote:

> Hey Brandon,

> Aside from RMAN performance, there's a lot of disk wasted on this.  At the
> controlfiles current size of 50MB each (PROD is only 4MB) and with a
> maximum
> of ~200 copies required for a minimum 1 day RMAN retention period with
> autobackup, I'm needing 10GB in my FRA just for controlfile backups (which
> don't appear to be compressed).  At this point, I have no idea how big the
> controlfile is going to get, which is a bit scary.
> No more than 20,000 blocks (likely 156mb) there's a hard limit. :( Do you
actually *need* a controlfile autobackup every 15 minutes though?

Niall Litchfield
Oracle DBA

Other related posts: