Re: What controls RMAN history size in controlfile?

From: Rich Jesse <>
Date: Tue, 29 Sep 2009 15:31:28 -0500 (CDT)
Message-ID: <>

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. :)


Received on Tue Sep 29 2009 - 15:31:28 CDT

Original text of this message