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

最新推荐文章于 2023-10-12 13:42:01 发布

转载最新推荐文章于 2023-10-12 13:42:01 发布 · 2.3k 阅读

文章标签：

#数据库

这篇博客介绍了遇到Oracle数据库错误代码ORA-01124时的解决方案，该错误通常发生在尝试恢复数据文件而文件仍处于使用状态时。文章可能包含排查步骤和修复策略。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在敲入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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15434882/viewspace-734663/