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

最新推荐文章于 2023-03-02 15:54:22 发布

csc1198962

最新推荐文章于 2023-03-02 15:54:22 发布

阅读量2.2k

点赞数

文章标签：数据库

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

摘要由CSDN通过智能技术生成

在敲入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