Re: Resize redo logs

DNP wrote:
>
> 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

As long as the database is 'archive log current'd before the change things will be fine...

In any event, I never said I was a fan of the approach I posted - the original poster just wanted to know if there was a way other then dropping and adding...

:-)

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse