日期:2014-05-16 浏览次数:20465 次
具体代码: ?? 前提条件: ??? alter database tbs_data begin backup; ??? host copy D:\app\Administrator\oradata\ticket\TBS_DATA.DBF D:\app\Administrator\oradata\ticket\bak\TBS_DATA.DBF ??? alter database tbs_data end backup; ??? ?? 恢复操作: ??? sqlplus /nolog ??? conn sys/ticket as sysdba ??? shutdown immediate; ??? 删除 D:\app\Administrator\oradata\ticket\TBS_DATA.DBF ??? startup? (备注此处报数据文件的丢失,告诉文件名和数据文件编号 ,启动失败之后,数据处于mount状态) ??? alter database datafile 6 offline; ??? alter database open; ??? select file#,status from v$datafile; ??? select * from v$recover_file; ??? host copy D:\app\Administrator\oradata\ticket\bak\TBS_DATA.DBF D:\app\Administrator\oradata\ticket\TBS_DATA.DBF ??? alter database datafile 6 online; ?????? select file#,status from v$datafile; ??? 验证数据信息。 ?
?