Re-sizing Redo Log Files in 8.0.5

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 - 07:54:32 CST