Re: Changing Redolog file Sizes

You do not need to do anything with the control files.

Simply create new log group of the appropriate sizes then drop the old log groups.

You will need to query v$log to find out which is the current log group prior to the drop,
but you don't need to do anything with the control files.

Kenny Gump
OCP 7.3 DBA tpcmohan_at_my-deja.com wrote in message <7p1ohq$9pe$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 Fri Aug 13 1999 - 15:12:41 CDT