Re: Oldest Archive Log needed

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

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