Re: Resize redo logs

Surely something's missing here - the ARCHIVELOG / NOARCHIVELOG debate.

If this installation is running in ARCHIVELOG mode then surely a full database backup is required after you RESETLOGS. Now depending on database size / disk space / offline storage space etc. this could have a much larger impact on operations than just creating and dropping log file groups.

Any comments?

David P.

Connor McDonald wrote:
>
> r406 wrote:
> >
> > Hi,
> > I'm running Oracle 8i. I have 2 redo log groups (1 & 2), 2
> > members each. Each member (.log file) is 500k, I want to
> > increase them to 5m each. Since members in a group must be the
> > same size, is there any easier way to do this other than create
> > a group 3 & 4, drop groups 1 & 2, recreate 1 & 2, then drop 3 &
> > 4? Thanks.
> >
> > -r
> >
> > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> > The fastest and easiest way to search and participate in Usenet - Free!
>
> You can build a new create controlfile command and then open the
> database with a RESETLOGS (after a clean shutdown).
>
> You can decide whether that is less or more effort that just dropping
> the old ones and adding new ones...
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
Received on Mon Mar 27 2000 - 00:00:00 CST