Re: Logical Logs - store on tape, disk or to /dev/null?
Posted in 1998
Topics: Server Administration, Logging & Checkpoints
David Williams wrote: > > In article <6qemtk$b5p$1@news00.btx.dtag.de>, Stephan Stresing <triple- > p.sst@t-online.de> writes > >Hi, > >recently I posted the onconfig of one of our client sites and one > >comment I got was, if we were really not interested in the logical > >logs because LTAPEDEV is set to /dev/null. This made me post this > >message because I want to know how you handle this: are 2 tape devices > >connected to your servers or are you storing the logs to disk? We have > >set this option to /dev/null because our client only has 1 tape device > >(changer) and usually they need it for the regular backup (filesystem > >as well as database). > >At our site we write the logs to disk and back them up every night, so > >if we need them, we could restore them from our normal filesystem back- > >up set. > >Now, it's your turn... :-) How do you handle this kind of "problem"? > > 3 tape drives > > - UNIX full backup > - Informix level 0 archive > - Log tape > > >TIA, > > many regards, > > Stephan. > > -- > David Williams Does Informix still require a terminal to be permanently logged in as "Informix" to carry out the log backup to tape? That's a no-no in our environment for security reasons, so we backup the logs to disk where they get swept up by the Unix file system backup. Dave