Re: RMAN "delete archivelog backed up..." command

On Aug 23, 2:50 pm, myl..._at_gmail.com wrote:
> Is there a way to instruct RMAN to delete archived redo logs that have
> been backed up "x" times to disk _and_ have been successfully archived
> at a remote site (this is a Dataguard setup)? We're running Oracle
> 9i.
>
> M

Not that I've found, but I'd gladly be corrected. I think this quote from "Oracle Database 10g RMAN Backup & Recovery" by Hart and Feeman (p. 246)is telling:

"Use of the *not backed up* parameter and use of the *delete input* parameter are somewhat mutually exclusive. The *delete input* parameter will remove the archived redo log regardless of how many times it has been backed up."

My own testing bears this out. If I specify 'not backed up 3 times delete input', the archived logs get deleted the first time they are backed up.

However, as I sit here and read that page a couple of more times, it looks as if the 'until time' option may be able to accomplish the desired result. I think I'll test that .... Received on Fri Aug 24 2007 - 07:47:41 CDT