一次datafile 恢复

最新推荐文章于 2024-07-21 08:15:00 发布

db_bili

最新推荐文章于 2024-07-21 08:15:00 发布

阅读量755

点赞数

CC 4.0 BY-SA版权

文章标签： file database thread archive sql user

本文链接：https://blog.youkuaiyun.com/db_bili/article/details/7019014

本文记录了一次Oracle数据库中两个数据文件出现故障并被标记为RECOVER状态后的恢复过程。通过执行恢复命令，并指定日志文件，成功将数据文件的状态从RECOVER更改为可用状态。

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

环境: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

库运行在archive log 模式。

现象：

应用报错误：ORA-00376: file 5 cannot be read at this time
ORA-01110: data file 5: '/data/admin07.dbf'

检查数据库：

SQL> select * from dba_data_files where online_status IN ('OFFLINE','RECOVER');

FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS

/data/admin04.dbf 6 ADMIN_IDX AVAILABLE 134 RECOVER

/data/admin07.dbf 5 ADMIN_IDX AVAILABLE 143 RECOVER

发现有2个datafile 的状态是RECOVER

于是执行：

SQL> recover datafile 5;
ORA-00279: change 74235172681 generated at 11/27/2011 11:38:22 needed for
thread 1
ORA-00289: suggestion : /data/arch/1_1148_758804239.dbf
ORA-00280: change 74235172681 for thread 1 is in sequence #1148

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
Log applied.
Media recovery complete.

SQL> recover datafile 6;
ORA-00279: change 74235172681 generated at 11/27/2011 11:38:22 needed for
thread 1
ORA-00289: suggestion : /data/arch/1_1148_758804239.dbf
ORA-00280: change 74235172681 for thread 1 is in sequence #1148

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
Log applied.

Media recovery complete.

再查看2个数据文件：

SQL> select file_name,file_id,online_status from dba_data_files where file_id in (5,6);

FILE_NAME                                                                           FILE_ID ONLINE_STATUS
----------------------------------------------------------------------- ------------------ ------------------
/data/admin07.dbf                                                  5 OFFLINE
/dataadmin04.dbf                                             6 OFFLINE