在出現故障時，可以用打開數据庫備份并應用重做信息，來完全恢复數据庫。當使用用戶管理的熱備份修复損坏了的數据庫時，常常不得不恢复已經還原的數据文件。
本篇任務，在刪除的數据文件的情況下進行完全恢复！
[@more@]-- 備份前數据
SYS@HUIYI>select t.name,f.name from v$tablespace t,v$datafile f where t.ts#=f.ts#; NAME NAME ---------------------------------------- ---------------------------------------- SYSTEM G:A9IORADATAHUIYISYSTEM01.DBF UNDOTBS1 G:A9IORADATAHUIYIUNDOTBS01.DBF DRSYS G:A9IORADATAHUIYIDRSYS01.DBF EXAMPLE G:A9IORADATAHUIYIEXAMPLE01.DBF INDX G:A9IORADATAHUIYIINDX01.DBF ODM G:A9IORADATAHUIYIODM01.DBF TOOLS G:A9IORADATAHUIYITOOLS01.DBF USERS G:A9IORADATAHUIYIUSERS01.DBF XDB G:A9IORADATAHUIYIXDB01.DBF TBS01 G:A9IORADATAHUIYITBS01.DBF 10 rows selected. SYS@HUIYI>create table t 2 ( 3 col date 4 ) 5 tablespace tbs01; Table created. SYS@HUIYI>insert into t values(sysdate); 1 row created. SYS@HUIYI>commit; Commit complete. SYS@HUIYI>select * from t; COL ------------------ 09-Mar-07 14:01:23
-- 備份 SYS@HUIYI>@open_backup; -- 備份後的數据
SYS@HUIYI>insert into t values(sysdate); 1 row created. SYS@HUIYI>commit; Commit complete. SYS@HUIYI>select * from t; COL ------------------ 09-Mar-07 14:01:23 09-Mar-07 14:23:23 -- 刪除數据文件 SYS@HUIYI>alter tablespace tbs01 offline; Tablespace altered. SYS@HUIYI>host del %oracle_home%oradatahuiyitbs01.dbf SYS@HUIYI>alter tablespace tbs01 online; alter tablespace tbs01 online * ERROR at line 1: ORA-01157: cannot identify/lock data file 10 - see DBWR trace file ORA-01110: data file 10: 'G:A9IORADATAHUIYITBS01.DBF' SYS@HUIYI>select * from v$recover_file; FILE# ONLINE ONLINE_STATUS ERROR CHANGE# TIME ---------- -------------- -------------- -------------------- ---------- ------------------ 10 OFFLINE OFFLINE OFFLINE NORMAL 0
-- 還原及恢复
SYS@HUIYI>host copy g:bbackuphottbs01.dbf %oracle_home%oradatahuiyi /y SYS@HUIYI>alter tablespace tbs01 online; alter tablespace tbs01 online * ERROR at line 1: ORA-01113: file 10 needs media recovery ORA-01110: data file 10: 'G:A9IORADATAHUIYITBS01.DBF' SYS@HUIYI>select * from v$recover_file; FILE# ONLINE ONLINE_STATUS ERROR CHANGE# TIME ---------- -------------- -------------- -------------------- ---------- ------------------ 10 OFFLINE OFFLINE OFFLINE NORMAL 0 SYS@HUIYI>recover datafile 10; Media recovery complete. SYS@HUIYI>alter tablespace tbs01 online; Tablespace altered. SYS@HUIYI>select * from t; COL ------------------ 09-Mar-07 14:01:23 09-Mar-07 14:23:23
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8799875/viewspace-903599/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
第五章 從打開的數据庫進行備份与恢复
请登录后发表评论
登录
全部评论
