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;
|