#28_140722_WSHOP2_DATAFILE OPEN 복구

# DATAFILE OPEN 복구

• 만약에 장애가 나서 복구를 해야 한다면 open 시켜놓고 복구를 하는게 바람직하다

문제1. ts405 테이블 스패이스를 생성하고 ts405 테이블 스패이스에 emp 테이블과 똑같은 구조와 테이터로 emp405를 생성하고 나서 ts405테이블 스패이스를 백업받으시오

SQL> create tablespace ts405     datafile '/u01/app/oracle/oradata/dbdb/ts405.dbf' size 20m; SQL> connect scott/tiger SQL> create table emp405     tablespace ts405 as     select * from emp where 1=2; SQL> exit [dbdb:dbdb]$ rman target / RMAN> backup tablespace ts405;

문제3. 위에서 생성한 ts405 테이블스패이스에 data file을 shutdown abort 한 후에 rm으로 삭제하고 mount 상태에서 복구하지 않고 DB를 open 시켜놓고 복구하시오

1.     SQL> select * from v$recover_file;

2.     SQL> alter database datafile 번호 offline;

3.     SLQ> alter database open;

4.     RMAN> restore datafile 번호;

5.     RMAN> recover datafile 번호;

6.     SQL> alter database datafile 번호 online;

SQL> select * from v$recover_file;      FILE# ONLINE  ONLINE_ ERROR                                                                CHANGE# TIME ---------- ------- ------- -----------------------------------------------------          1 ONLINE  ONLINE  UNKNOWN ERROR                                                        1274401 2014/07/22:10:52:05          2 ONLINE  ONLINE  UNKNOWN ERROR                                                        1274401 2014/07/22:10:52:05          3 ONLINE  ONLINE  UNKNOWN ERROR                                                        1274401 2014/07/22:10:52:05          4 ONLINE  ONLINE  UNKNOWN ERROR                                                        1274401 2014/07/22:10:52:05          5 ONLINE  ONLINE  UNKNOWN ERROR                                                        1274401 2014/07/22:10:52:05          6 ONLINE  ONLINE  UNKNOWN ERROR                                                        1274401 2014/07/22:10:52:05          8 ONLINE  ONLINE  FILE NOT FOUND                                                             0 SQL> alter database datafile 8 offline; SQL> alter database open; SQL> exit RMAN> restore datafile 8; SQL> exit RMAN> restore datafile 8; RMAN> recover datafile 8; RMAN> exit [dbdb:dbdb]$ sql SQL>alter database datafile 8 online;