Re: Oldest Archive Log needed

From: <>
Date: Fri, 28 Dec 2007 15:22:24 -0800 (PST)
Message-ID: <>

On Dec 28, 5:30 pm, "" <> wrote:
> 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

Thank you for your reply, while RMAN can do the management of the work I would like to know what is the oldest archive log necessary to keep for the most current backup so I can use an alternative besides RMAN. Received on Fri Dec 28 2007 - 17:22:24 CST

Original text of this message