Re: Resize redo log without making DB in restricted mode

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> a écrit dans le message de news:KcqdnUMGd-v9yPHfRVn-tA_at_comcast.com...
|
| <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
|
|

I think you mean there is NO need to take down the ...

Regards
Michel Cadot Received on Sun Apr 24 2005 - 23:23:34 CDT