RE: Are logs any use in a no logging database?

I hate to rain on the parade, but this is not entirely correct. IF you use OnArchive to perform your backups, or you want to be able to perform a selective (dbspace) restore from ontape, you DO need to have had your logical logs backed up. To restore a dbspace from ontape (in the 7.x realm), you need to have the logical log backups to apply during restore. The same holds true for OnArchive. Logical logs are needed if you ever have to perform a restore. ------------------------------ Jon C. Vemo jvemo@cyberspace.com Bothell, WA U.S.A. ---------- From: Cheryl Kendricks[SMTP:cherylk@prod1.jcdc.doleta.gov] Sent: Wednesday, May 22, 1996 6:40 PM To: Spetc@aol.com Cc: informix-list@rmy.emory.edu; eric@sstcs.com Subject: Re: Are logs any use in a no logging database? 1. No! 2. Writes always occur to the log for certain commands (moslty all update/alters/creates). It will write to the log, yet if your log is point to /dev/null (that's like never never land) no real write occurs only disk access. Yet the eninge does count it as an write!!!! It does in otherwords access /dev/null. If I'm wrong! the expert's will pipe it in right. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Wed, 22 May 1996 Spetc@aol.com wrote: > We do not use logging on our database. > > 1. We perform level 0,1 archives, but we don't backup the logs, do we really > need to? > > 2. What are the logs used for in a no logging database? For example, if I > update every row in a table with 10 million rows with a single update > statement and I interrupted it half way through would the first 5 million > updates be rolled back? Would it use the logs for this purpose? > > Thanks in advance. >