第五章 從打開的數据庫進行備份与恢复二(完全恢复)

　　在出現故障時，可以用打開數据庫備份并應用重做信息，來完全恢复數据庫。當使用用戶管理的熱備份修复損坏了的數据庫時，常常不得不恢复已經還原的數据文件。

　　本篇任務，在刪除的數据文件的情況下進行完全恢复！

[@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博客 ” ，链接：http://blog.itpub.net/8799875/viewspace-903599/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8799875/viewspace-903599/