Re: tbtape -c in background

Dwight Rudolph Jr wrote: > > In article <334DEF28.20DC@west.co.za>, marks@west.co.za says... > > > >Greg Salmon wrote: > >> > >> Mark D. Stock wrote: > >> > > >> > Neil Truby wrote: > >> > > > >> > > I've been asked to set up a background script to automatically run a > >> > > continuous logical log backup when my UNIX server starts. > >> > > >> > This can be done, but is SO dangerous that I'm not even going to > >> > say how. I would only implement this idea if I could ensure an > >> > operator was present 24 hours a day to pull out the tape when the > >> > system crashes. Then of course they might as well do a manual one > >> > if they are sitting there anyway. :-) > Actually the whole log backup process sort of irritates me. We do a full > level 0 backup every night and we're willing to reload that backup (losing a > day's work) if there's a disk crash. So the logical logs aren't worth all > that much to us. > > I realize there are lots of places that must recover every committed > transaction, but I'm sure there are lots, like us, that don't. An option to > NOT do logical logs (like Rdb/VMS has) would be really welcome. There are two: 1) Switch off logging at the database level. This assumes you are running an inteligent application that can detect and deal with this change. 2) Set your logical log backup device to /dev/null. This is picked up as a special device and logs are freed automatically. Help that helps, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+