谁快来告诉我？

chao_ping

try:
alter database open resetlogs;
Since u are in noarchivelog mode, and u cleared the current logfile, it is impossible to do complete recovery.
Maybe u should try in the beginning:
startup mount
recover database
and input the current online log file as the archived logfile.

runnet

if you don't have valid cold backup.try recreate control file.
1.connect internal
2.startup mount
3.alter database backup controlfile to trace
in your user_dump_dest directory,to find the trace file,then modify it according to your situation.save as newctl.sql.
4 backup your old control file;
5.@newctl.sql.
6 recover database;
7.alter database open.
maybe it can help you.

lhg

我没有看明白 recover database  命令，请详细好吗？
  thank you !

lhg

SQL> recover database;
ORA-00279: change 6438700 generated at 11/14/2001 11:45:22 needed for thread 1
ORA-00289: suggestion : F:\ORACLE\ORA81\RDBMS\ARC00051.001
ORA-00280: change 6438700 for thread 1 is in sequence #51


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
   
     我应如何写 recover database command ?

chao_ping

就是这样写的。
用online 日志文件代替archivelo文件本来就是只能试验看是不是的。
但是log文件已经被你clear掉了，哪里还有啊？你又不是归档模式的。

试试看吧。