½Ã³ª¸®¿À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;


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦