Re: Adding/dropping RedoLog groups in ver 7.1.6.2

"Vincent Ventrone" <vav_at_brandeis.edu> wrote in message news:9tufvn$ks4$1_at_new-news.cc.brandeis.edu...
>
> > I have a delicate problem, I want to add new Redo Log groups, do a
> > "alter system switch logfile" and then drop the old groups (without
> > restarting the instance)
> >
> > I have done this several times in Oracle 8i, but not in an old version
> > like this, 7.1.6.2
>
> It's the same procedure -- I have done it in ver. 7, 8 & 8i. The only
> caveat is, of course, that you cannot drop the current redo log group --
but
> that applies to any version. I usually wait until the DB is quiescent
> before doing it...
>
>

FYI: there's no need to wait. Just issue alter system switch logfile
when the logfile you need to drop is current.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address