Re: LOG_CEHCKPOINT_INTERVAL AND RECOVERY

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 28 Mar 1999 15:20:40 +0100
Message-ID: <922630920.14896.0.nnrp-04.9e984b29@news.demon.co.uk>

Very much so.

There is the possibility of losing a redo log file for some reason and still being able to recover (at least partially) to the previous file.

Also, with very large db_block_buffers and very busy databases, you can have blocks in memory which never get written out by the usual 'DBWR dribble' process and the presence of such blocks can make the application of redo much slower. (In many case, applying 100Mb of redo really means reading through 99Mb to find the 1Mb that really needs to be appled).

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

keith boulton wrote in message <36fe29d8.1159367_at_195.147.246.90>...
>On Sat, 27 Mar 1999 17:38:45 -0000, "Jonathan Lewis"
><jonathan_at_jlcomp.demon.co.uk> wrote:
>
>I had thought about this, but surely this only applies if you are
>copying archived log files to a different machine.
>
Received on Sun Mar 28 1999 - 08:20:40 CST