oracle redo01. log,redo01.log文件被删除之后

文件被删除之后"/>

oracle redo01. log,redo01.log文件被删除之后

，哎，一失足，成千古恨那，

各位大哥帮帮看看怎么办。

昨天，小弟不慎将redo*.log删除，

oracle即无法startup，

之后用"startup mount" 启动起来，

查看logfile

sql> select group#,member from v$logfile;

GROUP#

----------

MEMBER

--------------------------------------------------------------------------------

1

/oracle/ora8i/redo01.log

2

/oracle/ora8i/redo02.log

3

/oracle/ora8i/redo03.log

sql>

首先想drop 掉原来的logfile

sql> alter database drop logfile member '/oracle/ora8i/redo01.log';

提示错误：

ERROR at line 1:

ORA-00361: cannot remove last log member /oracle/ora8i/redo01.log for group 1