如果您目前拥有一个冷备份，但是缺少了其中的一个数据文件，但你目前存在所有的归档，如果您要恢复数据文件，可以参考以下的示例：

复制代码 代码如下:

[oracle@jumpereygle]$sqlplus"/assysdba"

SQL*Plus:Release9.2.0.4.0-ProductiononSunAug2001:22:502006

Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.

Connectedtoanidleinstance.

SQL>startupmount
ORACLEinstancestarted.

TotalSystemGlobalArea252777592bytes
FixedSize451704bytes
VariableSize134217728bytes
DatabaseBuffers117440512bytes
RedoBuffers667648bytes
Databasemounted.


SQL>alterdatabaseopen;
alterdatabaseopen
*
ERRORatline1:
ORA-01157:cannotidentify/lockdatafile3-seeDBWRtracefile
ORA-01110:datafile3:'/opt/oracle/oradata/eygle/eygle02.dbf'


SQL>alterdatabasecreatedatafile3as'/opt/oracle/oradata/eygle/eygle02.dbf';

Databasealtered.

SQL>selectnamefromv$datafile;

NAME
-------------------------------------------------------
/opt/oracle/oradata/eygle/system01.dbf
/opt/oracle/oradata/eygle/undotbs01.dbf
/opt/oracle/oradata/eygle/eygle02.dbf
/opt/oracle/oradata/eygle/eygle01.dbf

SQL>alterdatabaseopen;
alterdatabaseopen
*
ERRORatline1:
ORA-01113:file3needsmediarecovery
ORA-01110:datafile3:'/opt/oracle/oradata/eygle/eygle02.dbf'


SQL>recoverdatafile3;
Mediarecoverycomplete.
SQL>alterdatabaseopen;

Databasealtered.

SQL>