复制[oracle@localhost ~]$ rm $ORACLE_BASE/product/10.2.0/oradatabak/example01.dbf; SQL> select file#,数据数据error from v$recover_file; FILE# ERROR ---------- ----------------------------------------------------------------- 5 FILE NOT FOUND SQL> select file#,name from v$datafile where file#=5; FILE# NAME ---------- -------------------------------------------------------------------------------- 5 /oracle/10g/oracle/product/10.2.0/oradatabak/example01.dbf --恢复数据文件 RMAN> run { startup force mount; sql alter database datafile 5 offline; sql alter database open; restore datafile 5; recover datafile 5; sql alter database datafile 5 online; 8> } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18. |
喜欢
讨厌