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 -> A lost redo log member

A lost redo log member

From: S. <786myaden_at_worldnet.att.net>
Date: Sun, 24 May 1998 19:32:10 -0400
Message-ID: <6kaact$ps9@bgtnsc03.worldnet.att.net>


I accidently removed a redo log member on a test instance (7.3.3) at the operating system level while the instance was up. The group had two members so there was no problem. But now, alter database drop logfile 'removed log member'; complains that there is no such file.
select * from V$LOGFILE; shows the removed log member with invalid status.
alter database add logfile 'exactly same name as log member'; complains that the logfile already exists.

How do I remove the reference to the logfile that was removed and recreate a new one with the same name?

Thanks very much for any input. Received on Sun May 24 1998 - 18:32:10 CDT

Original text of this message

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