Re: LOG_CEHCKPOINT_INTERVAL AND RECOVERY

On Sat, 27 Mar 1999 17:38:45 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>It's probably the usual fuzzy-history syndrome,
>in this case failure to discriminate between log
>file switches and checkpoints.
>
>Log switches every N minutes makes sense if
>you want to cater for no more than N minutes of
>data loss when the machine is destroyed.

Sorry for the tone of my previous response, I wasn't in a good mood at the time.

I had thought about this, but surely this only applies if you are copying archived log files to a different machine.

I tend to work with small to medium sized databases, (because I like the dba/database designer/devloper combined role) where hardware cost is not an issue, so if the consequences of loss of a few hours data were significant, I would try to build my application to write to two databases on different machines. Received on Sun Mar 28 1999 - 07:35:12 CST