Re: Oldest Archive Log needed

On Dec 28, 4:09 pm, zipRobe..._at_gmail.com wrote:
> I have an oracle 10g database in archivelog mode.  It runs for a few
> days generating archive log files and I do a hot backup, a few more
> days go by and I do another backup.
>
> Assuming the last two backups are good and I only need the last one
> how do I determine the oldest archive log to keep so I can delete the
> old ones not needed for the most recent backup.
>
> Thanks.

You use RMAN to backup the database and the archivelogs and stop worrying about which ones to keep.

David Fitzjarrell Received on Fri Dec 28 2007 - 16:30:04 CST