Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Adding/dropping RedoLog groups in ver 7.1.6.2

Re: Adding/dropping RedoLog groups in ver 7.1.6.2

From: Vincent Ventrone <vav_at_brandeis.edu>
Date: Mon, 26 Nov 2001 17:35:11 -0500
Message-ID: <9tufvn$ks4$1@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... Received on Mon Nov 26 2001 - 16:35:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US