Re: Changing Redolog file Sizes

A copy of this was sent to Mike Mountjoy <michael_at_london.virgin.net> (if that email address didn't require changing) On Tue, 24 Aug 1999 12:06:14 +0100, you wrote:

>If you want to change redo log sizes then the database will have to mounted
>but closed.
>

No, you can add new redo files while the database is up and running of any size and drop the old ones whenever you want (as long as they are not current, just alter system switch logfile to make them not be current and drop them).

you don't need to bring down the instance to change the size of your online redo logs.

>Why not use 'alter database backup control file to trace 'and then use this
>trace
>file as the basis for the redolog create since its got the sql in it (just
>change the parameters),
>rename the current files to something else first.
>
>I can only thing that you are resizing the logfiles to reduce the amount of
>log switching
>go on.
>
>Kenny Gump wrote:
>
>> 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.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 24 1999 - 08:08:16 CDT