Re: backup and archive

Larry Weissman wrote: > > > > > > > >Area: comp.databases.informix > >From: curtis@pencom.com (Curtis Preston) > >Date: 6 Feb 1997 06:35:24 GMT > >Reply-To: curtis@pencom.com > > > > > >In article <32F219CB.7446@transre.com>, From "Juan R. Guzman" > ><jguzman@transre.com>, the following was written: > >> > >>> Curtis Preston writes: > >>> > >> I know that OFFICIALLY Informix does not support it, but have you > >> ever thought of sending your archive logs to disk? It solves all the > >>> problems that you're having. I've been doing it for years with > >> hundreds of production 24x7 Informix databases. I have also > > recovered many of them, and there is no problem sending the archive > >>> logs to disk. > >> > >>> I even have a script that stops and restarts the logs, moving and > >>> compressing the old files, every day. It also automatically starts > >>> the archive logs upon bootup. Interested? It really doesn't take up > > >> that much disk. > > > I would really appreciate some tips on using the logs to disk technique > or if possible some example scripts, we maintain a lot of informix > DB's and your resoning sounds good to me. > > ___ > * UniQWK v4.2 * The Windows Mail Reader > > '[1;35;40m-=> Delphi Internet Jet v3.012 - (C) PBE In OnLine 7.12 on an IBM RS/6000 under AIX 3 I always produce rather small logical log files on disk drive via the events communicated to the alarmprogram It works quite nice, even in an environment where 300 Mb of logfiles are produced every day (or more if we ALTER INDEX TO CLUSTER on heavily used tables) There are some things to be taken care of in your scripts such as preventing more than one ontape program to run archiving logs as far as I remember If you need more information please contact me via Email Gert van Eck DBA Nederland BV gvaneck@worldaccess.nl