Re: Importance of archivelog : searching for good document

From: David Barbour <david.barbour1_at_gmail.com>
Date: Tue, 10 Mar 2015 15:48:01 -0500
Message-ID: <CAFH+ifeAgP7dE-usXj-E5jZ_mh2yfFVr8BjQ18UzixyiB_sqgQ_at_mail.gmail.com>

I wouldn't care who was responsible for the backup, I'd make sure that somebody else was responsible for the ensuing chaos after the restore. As well as developing the plan to recreate lost work.

On Tue, 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
>
>

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

Received on Tue Mar 10 2015 - 21:48:01 CET