Re: What controls RMAN history size in controlfile?
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 29 Sep 2009 20:26:19 +0100
Message-ID: <7765c8970909291226o3ec87d0t96662f3fc0ff632c_at_mail.gmail.com>
On Tue, Sep 29, 2009 at 7:57 PM, Rich Jesse <rjoralist_at_society.servebeer.com
> wrote:
Date: Tue, 29 Sep 2009 20:26:19 +0100
Message-ID: <7765c8970909291226o3ec87d0t96662f3fc0ff632c_at_mail.gmail.com>
On Tue, Sep 29, 2009 at 7:57 PM, Rich Jesse <rjoralist_at_society.servebeer.com
> 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 http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 29 2009 - 14:26:19 CDT