Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> A lost redo log member
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