ORA-01113: file 5 needs media recovery ORA-01110: data file 5

本文介绍了在Oracle数据库中遇到ORA-01113(文件5需要介质恢复)和ORA-01110(数据文件5)错误的解决方法,探讨了可能的原因和修复步骤,帮助读者理解如何处理这类数据库故障。
摘要由CSDN通过智能技术生成
Last login: Sun Feb  9 14:06:37 2014 from 192.168.7.165
[oracle@oracle103 ~]$ env |grep ORA
ORACLE_SID=zghfin
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/11.2.0/db_1
[oracle@oracle103 ~]$ sqlplus /'as sysdba'


SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 9 14:09:08 2014


Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to an idle instance.


SQL> startup mount
ORACLE instance started.


Total System Global Area 2.0310E+10 bytes
Fixed Size                  2212976 bytes
Variable Size            1.9596E+10 bytes
Database Buffers          536870912 bytes
Redo Buffers              175132672 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/oradata/TUOIS_DAT01.dbf'




SQL> recover datafile 5;
ORA-00279: change 888701791 generated at 01/30/2014 14:01:14 needed for thread
1
ORA-00289: suggestion : /oradata/arch/1_75365_821021837.arc
ORA-00280: change 888701791 for thread 1 is in sequence #75365




Specify log: {=suggested | filename | AUTO | CANCEL}


ORA-00279: change 888715427 generated at 01/30/2014 14:01:47 needed for thread
1
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值