Re: Logical log backup - Why!?

Eric R. Gavin <Eric_Gavin@maf.org> wrote in article <664vq3$ipd$1@arctic.discover.net>... > I understand that the logical logs must be backed up consistently in order > to be freed, but why would I need to back them up otherwise? > > If I did a Level 0 backup once per week and then a Level 1 every other > weekday wouldn't that be sufficient? > > We're not a mission-critical, 24hour - 7 day/week organization. If we lost > a day's worth of data it wouldn't be a big deal. > > Are there any reasons to do Level 0, Level 1 AND preserve our Logical Log > backups? Right now I'm thinking of setting a continuous backup and > redirecting the Logical Log Tape Device to NUL. > > Would anybody counsel against this? And why? It really depends on your needs. If the risk of losing a day's worth of data is acceptable, then setting the log tape device (LTAPEDEV) to /dev/null is a reasonable option. If you do this, you don't even need to run the continuous backup -- the engine seems to know that /dev/null means the backup would only be thrown away and therefore frees each log as soon as it is no longer needed for rolling back open transactions. -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com