RE: Are logs any use in a no logging database?
This may be true for OnArchive (I'v) never used it. Yet I beleive ontape
will not allow the dbspace back up. I was talking a WHOLE config restore
and I belive that was the orginal question. I know it will work, just did
one yesterday (In testing) on 7.12. Back-up dropped the dummy DB, then
restored and my Dummy DB (with DATA!!!!) returned.
I never backup the LOGs to tape. I have log outside of log DB. Just answer
NO to the backup and restore questions concening the logs.
-------------------------------------------------------------------------
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 Thu, 23 May 1996, Jon C Vemo wrote:
} 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.
} >
}
}
}
}