Re: 오늘의 마지막 문제. os 로 가서 다음의 파일들을 전부 다 삭제하고 복구하시오

[21기_이풍혁]

1. tablespace_name이 TS로 시작하는 데이터 파일들 조회

select file_name, file_id, tablespace_name from dba_data_files where tablespace_name like  'TS%';

---

2. rman으로 data 파일 백업

rman target /

RMAN> backup database;

---

3. ts*.dbf 파일 삭제

rm ts*.dbf

---

4. sqlplus / as sysdba > startup force;

에러로그...

---

5. datafile offline으로 변경

alter database datafile 2 offline;

alter database datafile 5 offline;

alter database datafile 8 offline;

alter database datafile 9 offline;

alter database datafile 10 offline;

alter database datafile 11 offline;

alter database datafile 12 offline;

alter database datafile 14 offline;

alter database datafile 15 offline;

---

6. database open

alter database open;

#Database altered.

---

7. rman 으로 복구

rman target /

restore datafile 2 ;

restore datafile 5 ;

restore datafile 8 ;

restore datafile 9 ;

restore datafile 10 ;

restore datafile 11 ;

restore datafile 12 ;

restore datafile 14 ;

restore datafile 15 ;

recover datafile 2 ;

recover datafile 5 ;

recover datafile 8 ;

recover datafile 9 ;

recover datafile 10 ;

recover datafile 11 ;

recover datafile 12 ;

recover datafile 14 ;

recover datafile 15 ;

---

8. datafile open

alter database datafile 2 online;

alter database datafile 5 online;

alter database datafile 8 online;

alter database datafile 9 online;

alter database datafile 10 online;

alter database datafile 11 online;

alter database datafile 12 online;

alter database datafile 14 online;

alter database datafile 15 online;

---

9. 복구상태 확인

select tablespace_name, file_id, file_name, STATUS from dba_data_files where file_name like '%ts%' order by file_name;