If I run my transaction logger to a virtual tape file in Linux, is
there any reason to ftp this file along with the file-save virtual tape
files?

If not, what would be a good strategy of ftp-ing txlog files offsite?

Herb
Pathfinders Software
http://www.pfinders.com

Herb,

Long time...

You remember the old backup philosophy: Weekly full backup, nightly
incrementals, constant TX Logging.

When you restore, restore the full, restore the most recent incremental,
restore the tx log for that day.

For your offsite storage, I would think you'd want to keep a copy of
whatever was required to restore the system at any given instant. So you'd
send off the Weekly and nightly incrementals, but keep the tx logs local.
That way YOU can get them back to last night's state, THEY can update
themselves up to the minute.

Mark Brown


<herbr (AT) pfinders (DOT) com> wrote

So, what would the sequence of events be with file-save and txlogging?

stop logger
do file-save
start logger

What about updates during the file-save?

Don't stop logging during the filesave. The worst thing that happens is a
record shows up twice, once in the save and again in the TXlogger.

Filesave is only a snapshot of how the data looked at that moment. If they
are saving on a live system, they've got to expect that time won't stand
still for them and there may be something either lost or duplicated. In
this case, duplicated is not bad, as the worst case scenario only results in
a record being updated with the same data.

If, for some reason, you want to use the same device for your filesave as
you are for your txlog, simply stop logging to tape but continue to buffer
tx changes. There's a TXLog menu that will show you how.


Mark

<herbr (AT) pfinders (DOT) com> wrote

Does this make sense:

STOPLOG (K
FILE-SAVE
SET-DEVICE n
STARTLOG (E

This should keep the logger queue-ing all the time, right?

Sort of.

The (K option on stoplog will "release the queue back to overflow". I'm not
certain that's always a good thing.

Also, the (E option on the startlog will log all transactions from all files
regardless of the DL in the FDI.

Other than that, it looks ok.

Mark


<herbr (AT) pfinders (DOT) com> wrote