Re: Resizing redo log files

Mohan

There is no need to recreate the control file. Just add more logs of the size you want, drop the old ones except the current one (just try and drop them all, the current one will fail), issue an ALTER SYSTEM SWITCH LOGFILE command to start using the new ones, then drop the remaining old log file.

HTH. Pete

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.

--
Regards

Pete

Received on Fri Aug 13 1999 - 14:56:52 CDT