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
Action: See the associated messages for a description of the problem. Copyright (C) 1995, Oracle Corporation
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' ;
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了。