Re: Resizing redo log files

The best way to resize redo logs is to create another log group with the new log size, then remove the previous group. Once a redo log group has been created, you can't resize them.

You don't need to do anything with the control file.

Regards

Kev.D
tpcmohan_at_my-deja.com wrote in message <7p1rei$c06$1_at_nnrp1.deja.com>...
>Hello,
>I got to change Redolog file sizes ,i think the only soulution for that
>is recreating controlfile(to my knowledge) when i recreate controlfile
>when i go with resetlogs all the contents of the existing current log
>will be lost,so shall i have to take backup(offline or online) after
>creating controlfile because if i have to apply the lostfile contents
>for recovery in the future..what do i do or other way is i can switch
>logs before creating logs
>....am i right....Basically i am looking for the procedure for resizing
>the redologs on production box
>thanx
>mohan
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sat Aug 14 1999 - 05:39:27 CDT