Re: Oldest Archive Log needed

On Dec 28, 5:22 pm, zipRobe..._at_gmail.com wrote:
> 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.

And why on earth would you want to use any alternative to rman? RMAN *is* the method for managing backup and restore of the database.

Do you look for an alternative to creating/using indexes to optimize query performance?

Do you look for an alternative to using a battery and electric motor to start your car?

RMAN brings so much automation and intelligence to the process that it is a total waste of time to try to roll your own. If you are looking to do the work that would be necessary to come up with a viable alternative to rman, then you have *waaay* too much time on your hands and your shop is already overstaffed on DBA's. Received on Sat Dec 29 2007 - 09:51:42 CST