Re: A lost redo log member

Hi,

I think you just have the syntax slightly incorrect;

Try,
alter database drop logfile member 'full path and filename';

alter database add logfile member 'full path and filename' to group x; where x is the group number - you can get this from select * from v$logfile;

Once the member has been added, the status will still be invalid until the log is actually used.
If you want you can use;
alter system switch logfile;
to force a log switch to confirm things are OK. You may need to do a few log switches to make the invalid group/member the current log group.

Hope this helps
Mick

S. wrote:

> 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 - 22:20:09 CDT