Re: Importance of archivelog : searching for good document

Datawarehouse applications come to mind as an example. If the database is changed only during once-nightly loads, then it *may be* adequate to perform backups immediately after the load has been performed, and there is no (real) need for PITR capability.

This is also a use-case where the ability to turn on and turn off archiving without a restart would be useful. You would turn on archiving just before beginning an online backup, and turn it off again once the backup is complete.

Such a configuration would be putting a lot of faith on the users not to modify data during the day (unless you also switch the database to readonly after the data loads are complete), but I can at least imagine environments where this might be desirable.

I have to admit, though -- I am curious as to what exactly has caused Kyle to raise this question. I doubt it came about as the result of any deep-seated doubts about archive logging on *his* part. :-)

On Tue, Mar 10, 2015 at 5:59 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> I have run into two cases where archive logging was not needed. Of course
> neither was Oracle needed, but they used it anyway. Both were classic
> examples of when your only tool is a hammer every problem looks like a
> nail. My initial recommendation in both cases was to rewrite in a
> scripting language or a 3GL.
>
> Sent from my iPad
>
> > On Mar 10, 2015, at 3:43 PM, MacGregor, Ian A. <ian_at_slac.stanford.edu>
> wrote:
> >
> > Who is arguing against archive logging and to what benefit. I would not
> want to be responsible for any type of backup/recovery in this situation.
> I’d insist on archive logging or insure whomever does not want archive
> logging implemented totally responsible for the backups.
> >
> > Ian MacGregor
> > SLAC National Accelerator Center
> >> On Mar 10, 2015, at 10:39 AM, kyle Hailey <kylelf_at_gmail.com> wrote:
> >>
> >>
> >>
> >> Does any one know of a good document or blog that argues strongly for
> archive log?
> >>
> >> Most of the stuff I see says you can use archive log if you want but
> you don't have to and if you don't it just means you have to take cold
> backups and can't do point in time recovery
> >>
> >> The way I look at it is point in time recovery is crucial because you
> will corrupt your database at some point without archive log it's just
> matter of time, a ticking time bomb.
> >>
> >>
> >>
> >> - Kyle
> >
> > †Ûiÿü0ÁúÞzX¬¶Ê+ƒü n– {ú+iÉ^
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l