ORACLE10G求救！！！在线。

cnny

启动ORACLE10G时报错，如下，请教各位如何恢复：

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/oradata/gclx01/system01.dbf'


SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

guest_client

哥们，提示你要用一个controlfile，可以用以前备份过的或是一个好的，或是你用resetlogs所以选项重建一个。

cnny

SQL> alter database recover datafile 1
  2  ;
alter database recover datafile 1
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

下面是加了using backup controlfile后的效果。
SQL> recover datefile 1 using backup controlfile;
ORA-00905: missing keyword

SQL> recover datafile 1 using backup controlfile until cancel;
ORA-00274: illegal recovery option USING

numenhuang

sql>recover database using backup controlfile until cancel

sql>alter database open resetlogs

如果是正式环境，先做好现有文件的备份。

[ 本帖最后由 numenhuang 于 2007-9-10 12:36 编辑 ]