Re: What controls RMAN history size in controlfile?

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 30 Sep 2009 09:39:56 -0700
Message-ID: <bf46380909300939w74936662t7167cb3cadd58ba8_at_mail.gmail.com>

Personally, I think that the terms 'reducing maintenance', 'solo dba' and 'grid control' are seriously at odds with each other. :)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

On Tue, Sep 29, 2009 at 1:31 PM, Rich Jesse <rjoralist_at_society.servebeer.com
> wrote:

> Hey Robert,
>
> > Hmmmm..... are you doing any backups using the keep option?
>
> No, or not on purpose at least. Until last week, I had scheduled my RMAN
> backups via Grid Control (it was a feeble attempt at reducing maintenance
> documentation and training, being a solo DBA). I checked using "LIST
> BACKUP
> SUMMARY" and confirmed from the DB with:
>
> select *
> from v$backup_piece
> where deleted != 'YES'
> order by start_time;
>
> ...and I only get the expected last 1 day+ of backups listed. The query
> sans the WHERE clause brings back 32K rows however.
>
> > Oracle9i RMAN Backup and Recovery (Oracle Press)
>
> That's on my desk, next to the 10g version. :)
>
> Thanks!
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 30 2009 - 11:39:56 CDT