Re: Redo log files

Since Archived Redo Log Files are used to restore a database to a point in time...What I did, was the following: 1st backup day: Take a full online backup of database and save archived redo log files since last full online backup. 2nd backup day: Take full online backup of database and save archived redo log files since last full online backup. 3rd backup day: Take full online backup of database and save archived redo log files since last full online backup. Now I can remove (or rewrite over tape)the archived redo logs of the first saved archived redo logs (along with the backed up datafiles, ect). You cannot restore from a media disaster using archived log files alone, you will need to restore from your last full online backup and then apply any archived redo log files since the backup. I personally keep 3 backups worth of archived redo logs.

Good Luck,
Satar

In article <3619921B.7176B3E9_at_deere.com>,   "John P. Higgins" <jh33378_at_deere.com> wrote:
> We like to retain our backups 42 days. That means we nust also retain the
backups
> of the archived logs for 42 days.
>
> The 42 days makes sure we have a backup of the previous month end as well as
> providing defense in depth.
>
> restes_at_my-dejanews.com wrote:
>
> > Hi,
> > I'm trying to determine from newsgroups and oracle books how far back oracle
> > redo log files need to be kept.
> >
> > Would anyone know if I need to keep libraries of redo logs to restore the
> > database to it's present status? Or is it OK to keep the redo log files that
> > belong to each backup instance and not even worry about redo logs, say, from
2
> > weeks ago?
> >
> > Thanks for all of your help.
> >
> > Russ
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 06 1998 - 11:54:57 CDT