Re: Oldest Archive Log needed

From: <>
Date: Fri, 28 Dec 2007 14:30:04 -0800 (PST)
Message-ID: <>

On Dec 28, 4:09 pm, 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

Original text of this message