请问ORA-01113: file 1 needs media recovery ,ORA-01110: data file 1: 'D:\BACKUPDB\SYSTEM01.DBF' 是什么错误,怎么解决?

[lcz022]

请问ORA-01113: file 1 needs media recovery ,ORA-01110: data file 1: 'D:\BACKUPDB\SYSTEM01.DBF' 是什么错误,怎么解决?
谢谢!

[LGQDUCKY]

ORA-01110 datafile name: str

Cause: This message reports the filename involved with other messages.
Action: See the associated messages for a description of the problem.

Copyright (C) 1995, Oracle Corporation

[xbm2008]

ORA-01113: file string needs media recovery
Cause: An attempt was made to online or open a database with a file that is in need of media recovery.
Action: First apply media recovery to the file.

用下面语句试试：
recover datafile 'D:\BACKUPDB\SYSTEM01.DBF' ;

[LGQDUCKY]

系统表空间的数据文件损坏了，如果没有归档日志文件可能就难恢复了

[qiansl]

只有重建表空间了。

[lcz022]

哈哈，自己解决了。
http://www.dbonline.cn/source/oracle/20031214/resume%20database%20example.html
有解决方案的。

SQL>connect sys/password as sysdba
SQL>alter system switch logfile;
SQL>commit;
SQL>archive log list
数据库日志模式 存档模式
自动存档 启用
存档终点 d:\BACKUPDB\archive
最早的概要信息日志序列 3
下一个存档日志序列 5
当前日志序列 5
shutdown abort关闭例程，模拟数据文件丢失
SQL> shutdown abort
ORACLE 例程已经关闭。
Mount数据库
SQL> startup mount
数据库装载完毕
SQL>recover datafile 'D:\BACKUPDB\SYSTEM01.DBF';

就ok了。