Oracle 一般数据库文件的恢复过程
具体代码：?? 前提条件：??? 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;??? 验证数据信息。?
?
