Re: Changing Redolog file Sizes

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

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.
Received on Tue Aug 24 1999 - 06:06:14 CDT