Re: LOG_CEHCKPOINT_INTERVAL AND RECOVERY

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 27 Mar 1999 17:38:45 -0000
Message-ID: <922556429.12046.2.nnrp-04.9e984b29@news.demon.co.uk>

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.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

keith boulton wrote in message <36fcd9a0.11932768_at_195.147.246.90>...
>>Lets say you didn't checkpoint frequently, say you have 500meg logs. As
we were
>>putting the 499'th meg of stuff in the redo log file the system crashed.
To
>>startup, we have to read and apply 499meg of log.
>>
>>
>Whenever I've asked the question about checkpointing people always
>seem to parrot some response about a checkpoint every 20 minutes - do
>you know the origin of this figure?
Received on Sat Mar 27 1999 - 11:38:45 CST