Re: Archive logs

From the way the question is phrased I think Joel could possibly think that a checkpoint only occurs when there is a log file switch. It is possible that checkpoints are already occuring more frequently than that. Log switches once per hour not a bad rate to be switching at. You could lose the ability to revcover if lose all of your current redo log files, which should be very unlikley if you are mirroring them. Check out LOG_CHECKPOINT_INTERVAL and following the links in the "See Also" section for other parameters. This will allow you to increase your checkpoint interval which will decrease instance recovery time if you have an instance failure. It will also ensure those changes stored in the current redo log files get out to the data files. However, I think your better off with less checkpointing and just ensuring you never lose your online redo log files.

http://www.oradoc.com/ora817/server.817/a76961/ch189.htm#55753

• Ethan Post

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message news:3B323887.4C787091_at_attws.com...
> Joel wrote:
>
> > Our checkpoints/logfiles are changing about every hour during peak
 times. Any
> > way we can recover that hour if something blows up?
>
> Depending on what blows up ... No.
>
> Change your checkpoint interview.
>
> Daniel A. Morgan
>
Received on Fri Jun 22 2001 - 01:27:45 CDT