oracle下实现恢复一个丢失的数据文件的代码

如果您目前拥有一个冷备份，但是缺少了其中的一个数据文件，但你目前存在所有的归档，如果您要恢复数据文件，可以参考以下的示例：
<div class="codetitle"><a style="CURSOR: pointer" data="64629" class="copybut" id="copybut64629" onclick="doCopy('code64629')"> 代码如下:<div class="codebody" id="code64629">
[oracle@jumpereygle]$sqlplus"/assysdba" SQLPlus: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>