RE: Logical Logs to Disk?
What is this onbar I've been hearing about? I run Informix 7.1 across
multiple Digital Unix servers.
abel_johnson@doh.state.fl.us
______________________________ Reply Separator
_________________________________
Subject: Re: Logical Logs to Disk?
Author: Sean Kelsey [SMTP:chilliinc@hotmail.com] at EXCHDOH
Date: 1/14/99 6:08 AM
I have been watching this discussion with great interest as I have recently
been in a discussion with my clients over the pro's and cons of disk/tape
log archiving. ( I've also avoided getting involved until now - I could't
help myself ! )
To me its 6 of one and half a dozen of the other ! ( sorry, english
manerisms coming out ). Curtis wrote a lengthy, detailed description of his
dilema, tailoring it around his prefered method of using disks for the
archving.
Personally, I have room for both ( what a cop out !! ) but prefer tape
(decisions, decisions) using onbar rather than ontape. I have to admit that
if I were stuck with just using ontape, I would write myself a series of
scripts and perform disk archiving then archive the disk logs to tape of an
evening. Using onbar can also archive multiple instances to the same tape
device - eliminating the argument of using a single tape device per
instance.
I think the phrase with the words 'cat' & 'skin' immediately springs to mind
here !
In any archiving strategy, the importance has got to be on the security of
the data - not necessarily the speed in which it can be recovered. ( The
ideal would obviously be to get the best of both ). If you follow the
argument through that Curtis was putting forward, why do you not archive the
full database to disk as well ?? Why use tape at all ?? Yes, the logical
logs are important but they aren't worth diddley if the database can't be
recovered ??
Simply, whatever your chosen method of archiving, you MUST ensure that you
can recover the database given all failure circumstances. If you can do
this, then regardless of what method you choose, you've succeeded !!
Personally, I prefer tape ( cleaning on a regular basis !! )
Sean