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