Re: What controls RMAN history size in controlfile?
Date: Wed, 30 Sep 2009 09:39:56 -0700
Personally, I think that the terms 'reducing maintenance', 'solo dba' and 'grid control' are seriously at odds with each other. :)
On Tue, Sep 29, 2009 at 1:31 PM, Rich Jesse <rjoralist_at_society.servebeer.com
> 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
> 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. :)