Re: Resize redo logs

As long as you switch archive logs when dropping and recreating them, you'll don't need to use the resetlogs, so you don't need to backup. You will simply have offline redologs not all the same size.

Regards,

Sybrand Bakker

DNP <High.Flight_at_btinternet.com> wrote in message news:38DF349F.2B6A_at_btinternet.com...
> 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