시나리오8: system tablespace 구성하는 datafile유실시- 완전복구
작성자 관리자 작성시간 2003-07-23 22:25:25
 

SQL> select * from all_objects;
ERROR
ORA-12571: TNS:packet writer failure

SQL>!ps -ef | grep human <--프로세스가 모두 죽었다

SQL> startup
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/home/human/oradata/HUMAN/system01.dbf'

SQL> shutdown abort
SQL> exit

2) Recovery 시작
예전에 받은 Online Backup으로 부터 System Tablespace를
구성하는 Datafile을 Restore

$ cp ONBACKUP/system01.dbf oradata/HUMAN/

$ sqlplus '/as sysdba'
SQL> startup

Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/human/oradata/HUMAN/system01.dbf'


SQL> recover datafile '/home/human/oradata/HUMAN/system01.dbf'

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto    <-- auto를 입력한다.

....
Log applied.
Media recovery complete. <-- 성공!!
SQL>
SQL> alter database open;


목록 | 입력 | 수정 | 답변 | 삭제