Re: Log switch during import

Mark D Powell wrote:

> you will know one reason why. But mostly you do not want multiple
> checkpoints to overlap, that is, you really do not want a new log
> switch and checkpoint to start if the prior checkpoint has not
> finished. Nor do you want to fill all the online redo logs to fill
> before the oldest log has been achieved to disk. Both of these
> problems result in warning error messages being written to the alert
> log.

Right! Forgot to point that out.

Very important stuff! Check for
"Checkpoint not complete"
in your alert log file (alert[SID].log).

If you find any of these, you most certainly want to increase the size of your redo logs, or create more log members.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...