Re: Question about Redo Logs

On Apr 1, 8:52 am, gazzag <gar..._at_jamms.org> wrote:
> 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/online...
>
> HTH
>
> -g

In that case, why even re-size the old ones? Why not just create new groups, drop the old ones, and be done with it? Received on Tue Apr 01 2008 - 09:14:34 CDT