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

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

昨天，小弟不慎将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

然后添加logfile

sql> alter database add logfile member 'oracle/ora8i/redo04.log' to group 1;

ERROR at line 1:

ORA-00301: error in adding log file 'oracle/ora8i/redo04.log' - file cannot be created

ORA-27040: skgfrcre: create error, unable to create file

SVR4 Error: 2: No such file or directory

之后尝试：

SQL> alter database open resetlogs;

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/ora8i/system01.dbf'

然后又使用：

sql>recover database until cancel ;

ORA-00279: change 614990494 generated at 01/02/2003 14:23:11 needed for thread 1

ORA-00289: suggestion : /u1/oracle/app/oracle/product/8.1.7/dbs/arch1_37711.dbf

ORA-00280: change 614990494 for thread 1 is in sequence #37711

Specify log: {=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/ora8i/system01.dbf'

ORA-01112: media recovery not started

再startup 仍不行。

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

急，急