Resize redo log without making DB in restricted mode

Hi All,

I have a question.

I need to resize my redo log file (right now it is 3 groups ( group A, B,C) in 5 Megbyte redo log size, ridiculous small, I did not set it up. I inherit this db).

I know it is a better practice to
do shutdown DB and then
startup restrict and do all the maintenance work.

I know how to add another 3 group with bigger size and then drop back all the originally 3 groups, A, B,C.

I plan to make the new redo 100Meg or even 150 Meg.

Is it really bad style not to bring down the database to do this mainteance?

This is a development machine with NO ARCHIVE LOG on. I plan to do it at night time, where , not much transaction going on in the DB.

Just curious? What other people do ... on development machine.

On the production, I definitely would do the startup restrict mode to do the mainteance work.

Thanks,

Dominica Received on Sun Apr 24 2005 - 19:37:02 CDT