如果您目前拥有一个冷备份，但是缺少了其中的一个数据文件，但你目前存在所有的归档，如果您要恢复数据文件，可以参考以下的示例：
复制代码 代码如下:
[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>
【oracle下实现恢复一个丢失的数据文件的代码】相关文章：
★ Oracle中简单查询、限定查询、数据排序SQL语句范例和详细注解