救命,ora1113如何解决

psb_天涯浪子

rt

lxd_sh

ORA-01113: file name needs media recovery
Cause: An attempt was made to open a datafile that is in need of media recovery.

Action: First apply media recovery to the datafile identified in the message, then retry the operation.

看oracle错误信息
你的数据文件可能坏了，你要做数据库的恢复

swz_19981018

到WWW.ORADB.NET看看，

swz_19981018

到WWW.ORADB.NET看看，

OL.O

用联机恢复就可以解决
1.先mount数据库
startup mount
2.脱机那些坏的数据文件
alter database datafiel 'filename' offline;
3.打开数据库
alter database open;
4.恢复数据文件
recover datafile 'datafile',.....
5.联机被脱机的数据文件
alter database datafile 'filename' online;
        <完>;