如果您目前拥有一个冷备份但是缺少了其中的一个数据文件但你目前存在所有的归档如果您要恢复数据文件可以参考以下的示例
[oracle@jumper eygle]$ sqlplus / as sysdba
SQL*Plus: Release Production on Sun Aug ::
Copyright (c) Oracle Corporation All rights reserved
Connected to an idle instance
SQL> startup mount
ORACLE instance started
Total System Global Area bytes
Fixed Size bytes
Variable Size bytes
Database Buffers bytes
Redo Buffers bytes
Database mounted
SQL> alter database open;
alter database open
*
ERROR at line :
ORA: cannot identify/lock data file see DBWR trace file
ORA: data file : /opt/oracle/oradata/eygle/eygledbf
SQL> alter database create datafile as /opt/oracle/oradata/eygle/eygledbf;
Database altered
SQL> select name from v$datafile;
NAME
/opt/oracle/oradata/eygle/systemdbf
/opt/oracle/oradata/eygle/undotbsdbf
/opt/oracle/oradata/eygle/eygledbf
/opt/oracle/oradata/eygle/eygledbf
SQL> alter database open;
alter database open
*
ERROR at line :
ORA: file needs media recovery
ORA: data file : /opt/oracle/oradata/eygle/eygledbf
SQL> recover datafile ;
Media recovery complete
SQL> alter database open;
Database altered
SQL>
