Re: Resizing redo log files

From: Florin David <florind_at_earthlink.net>
Date: Sun, 15 Aug 1999 23:06:29 -0600
Message-ID: <37B79C55.34E3F199@earthlink.net>

As long as you have at least three groups, you create new ones of the size you wish them to be and drop the old ones once they have been archived. Do not forget to edit your init.ora file to reflect the new names of the log files, in case you modify them.
Florin

tpcmohan_at_my-deja.com wrote:

> 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 Mon Aug 16 1999 - 00:06:29 CDT