ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01124: cannot recover data file 1 - file is in use or recovery

ORA-01124: cannot recover data file 1 - file is in use or recovery

原创 Linux操作系统 作者:woshiyiziyu 时间:2010-10-29 20:18:50 0 删除 编辑
在敲入recover database using backup controlfile后网络掉线了
SQL> recover database using backup controlfile;
ORA-00279: change 5951163881 generated at 10/23/2010 22:00:27 needed for thread
1
ORA-00289: suggestion : /eb_db/oraarch/1_36545_680724176.dbf
ORA-00280: change 5951163881 for thread 1 is in sequence #36545


Specify log: {=suggested | filename | AUTO | CANCEL}
auto
之后掉线,重新连接,再次敲入的时候报错:
oracle@linux-backup:~> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Oct 29 19:52:05 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: '/data/eb_db/oracle/oradata/ebai/system01.dbf'

我能否取消之前做的recover database using backup controlfile或者在哪我能看到这条语句的执行日志呢?

[ 本帖最后由 woshiyiziyu 于 2010-10-30 12:48 编辑 ]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15434882/viewspace-734663/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-07-21

  • 博文量
    37
  • 访问量
    111047