Re: What controls RMAN history size in controlfile?

From: Niall Litchfield <>
Date: Tue, 29 Sep 2009 20:26:19 +0100
Message-ID: <>

On Tue, Sep 29, 2009 at 7:57 PM, Rich Jesse <
> 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

Received on Tue Sep 29 2009 - 14:26:19 CDT

Original text of this message