Re: Re-sizing Redo Log Files in 8.0.5

Hi,

    I guess I would use

        ALTER DATABASE BACKUP CONTROLFILE TO TRACE;     Update redolog size in the text controfile. remove the redologs and controlfiles.

    Then recreate them.
    More or less the same procedure as renaming a DB, but without renaming it ;-)

    I' m interested in any other solutions. So, if you received any...

Hope this helps.
Renauld Chapellier

s. hunter wrote:

> Hi,
>
> I wanted to resize my redo logs in an active database. I actually
> managed it but I cannot believe that there isn't an easier way to do
> this.
>
> I have 2 redo log groups containing two members each, size 10M. I
> wanted the same redo logs, but re-sized to 200M. Here is how I did it:
>
> (SVRMGRL)
> >shutdown
> >startup restrict; (etc.etc)
>
> See which group is current (e.g. group 1 is current)
> >select * from v$log;
>
> Now, if I tried to do alter database drop group 2, I got oracle errors
> ORA-01567 and ORA-00312, stating that there couldn't be fewer than 2
> redo logs in thread 1. (?)
>
> So instead, I had to create a third group:
> >alter database add logfile group 3 'log3a.rdo' size 1M;
>
> Then I could drop Group 2
> >Alter database drop logfile group 2;
>
> Remove the original redo log files at the OS level
> >!rm log1a.rdo
> >!rm log1b.rdo
>
> And then recreate those log files with their new size
> >Alter database add logfile group 2 ('log2a.rdo','log2b.rdo') size 200M;
>
> Then do the same with group 1, after switching logs:
> >Alter system switch logfile;
>
> etc.
>
> Finally, remove the "temporary" 3rd group:
> >Alter database drop logfile group 3;
>
> So is this the only way to do this? Is the need to create another
> redolog group peculiar to my database? Why isn't there an "Alter
> database logfile group 1 resize 200M;"
>
> I'd appreciate peoples ideas and apologise for the length of this post!
>
> Sarah
Received on Wed Dec 08 1999 - 09:34:24 CST