<dominica_at_gmail.com> wrote in message
news:1114389422.618281.210250_at_l41g2000cwc.googlegroups.com...
> 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
>
For this operation there is need to take down the db or put it into
restricted mode. Just add new log files of the size you want. Then alter
the database and switch log files until it is using the new ones. Then drop
the small ones.
Jim
Received on Sun Apr 24 2005 - 21:27:25 CDT
