Re: Question about Redo Logs

On 1 Apr, 14:47, Mtek <m..._at_mtekusa.com> wrote:
> Hi,
>
> I'm posting this question again because after 30 minutes my last post
> did not appear, so hopefully this one will.
>
> How can I resize a redo log?  We have 3 groups and each logs is 50MB.
> However, no matter what, the 'Checkpoint not complete' errors just
> keep coming.
>
> So, we want to resize the logs, but no matter how many log switches we
> force, the status remains 'Active' or 'Current'.
>
> What can we do?
>
> Thanks in advance!
>
> John

As I replied in your other thread: add your new logs before attempting to drop the old ones.

This should help: http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/onlineredo.htm#sthref938

HTH -g Received on Tue Apr 01 2008 - 08:52:10 CDT