{"id":304,"date":"2015-01-19T08:58:18","date_gmt":"2015-01-19T08:58:18","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=304"},"modified":"2018-01-23T17:40:05","modified_gmt":"2018-01-23T08:40:05","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-db-%ec%9e%a5%ec%95%a0-%ec%bc%80%ec%9d%b4%ec%8a%a4-%eb%b3%84-%eb%b3%b5%ea%b5%ac-%eb%b0%a9%eb%b2%95-%ec%82%ac%eb%a1%80-%ec%a4%91%ec%8b%ac","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=304","title":{"rendered":"\uc624\ub77c\ud074  DB \uc7a5\uc560 \ucf00\uc774\uc2a4  \ubcc4 \ubcf5\uad6c \ubc29\ubc95  &#8211; \uc0ac\ub840 \uc911\uc2ec"},"content":{"rendered":"<p style=\"margin-left: 38pt;\"><span style=\"font-size: 16pt; font-family: Book Antiqua;\"><strong><em>Oracle Technical Service <\/em><\/strong><\/span><\/p>\n<p style=\"margin-left: 38pt;\"><span style=\"font-size: 22pt; font-family: \ub9d1\uc740 \uace0\ub515; color: black;\"><strong>\uc624\ub77c\ud074 DB<span style=\"color: #3333ff;\"> <span style=\"color: black;\">\uc7a5\uc560<span style=\"color: #3333ff;\"> <span style=\"color: black;\">\ucf00\uc774\uc2a4<span style=\"color: #3333ff;\"> <span style=\"color: black;\">\ubcc4<span style=\"color: #3333ff;\"> <span style=\"color: black;\">\ubcf5\uad6c<span style=\"color: #3333ff;\"> <span style=\"color: black;\">\ubc29\ubc95<span style=\"color: #3333ff;\"> <span style=\"color: black;\">\uc0ac\ub840 <\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"font-size: 16pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uc808\ucc28\/\ubc29\ubc95 \uae30\uc220\uc11c <\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uac1c\uc694 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc5ec\uae30\uc5d0\uc11c\ub294 \uc624\ub77c\ud074\uc5d0\uc11c\uc758 \uc5ec\ub7ec \uac00\uc9c0 \uc7a5\uc560\uc720\ud615\ubcc4\ub85c \ubcf5\uad6c\uc808\ucc28\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uae30\uc220\ud55c\ub2e4. <\/span><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515; background-color: yellow;\"><strong>NOARHCIVELOG \ubaa8\ub4dc\uc5d0\uc11c\uc758 \ubcf5\uad6c <\/strong><\/span><\/div>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 NOARCHIVELOG mode\ub85c \uc6b4\uc601 \uc911 \ub370\uc774\ud130\ubca0\uc774\uc2a4 Crash\uac00 \ubc1c\uc0dd\ud588\ub2e4\uba74, \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uac00\uc7a5 \ucd5c\uadfc\uc758 Offline full backup\uc744 restore\ud558\uac70\ub098 full database export\uac00 \uc788\ub2e4\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc7ac\uc0dd\uc131\ud558\uace0 Data\ub97c import\ud568\uc73c\ub85c\uc368 \ubcf5\uad6c\uac00 \uac00\ub2a5\ud558\ub2e4. \uadf8\ub7ec\ub098, \uc774\ub7ec\ud55c \uacbd\uc6b0\ub294 \uac00\uc7a5 \ucd5c\uadfc\uc758 \ubc31\uc5c5\uc2dc\uc810\uae4c\uc9c0\ub9cc \ubcf5\uad6c\uac00 \uac00\ub2a5\ud558\ubbc0\ub85c Data\uc758 \uc190\uc2e4\uc774 \ubd88\uac00\ud53c\ud558\ub2e4. <\/span><\/p>\n<p style=\"margin-left: 2pt;\">\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 42pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>Noarchivelog mode\ub85c \uc6b4\uc601 \uc911 datafile\uc758 \uc190\uc2e4 <\/strong><\/span><\/div>\n<\/li>\n<\/ol>\n<ul style=\"margin-left: 64pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c1\ud669 \ud0d0\uc9c0 <\/strong><\/span><\/div>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01157 error \ubc1c\uc0dd <\/span><\/p>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01157 : cannot identify data file 4 &#8211; file not found <\/span><\/p>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01110 : data file 4 : &#8216;\/home\/orahome\/data\/users01.dbf&#8217; <\/span><\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul style=\"margin-left: 64pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 86pt;\">\n<li>\n<div><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0ac\uc6a9\uc790\uc758 data\ub97c \ud3ec\ud568\ud558\uace0 \uc788\ub294 \uacbd\uc6b0 <\/strong><\/span><\/div>\n<ol>\n<li><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uac00\uc7a5 \ucd5c\uadfc\uc758 offline full backup\uc73c\ub85c \ubd80\ud130 complete database &#8211; control files, data files, online redo log files&#8211; \ub97c restore\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Startup database. <\/span><\/li>\n<\/ol>\n<\/li>\n<li><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>Temporary \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uacbd\uc6b0 <\/strong><\/span><\/li>\n<\/ol>\n<ul style=\"margin-left: 119pt;\">\n<li><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Startup mount <\/span><\/li>\n<li><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">alter database datafile &#8216;\/home\/orahome\/data\/temp01.dbf&#8217; offline drop; <\/span><\/li>\n<li><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">alter database open; <\/span><\/li>\n<li><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">drop tablespace TEMP including contents; <\/span><\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">create tablespace TEMP datafile &#8216;\/home\/orahome\/data\/temp01.dbf&#8217; size 100m; <\/span><\/div>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515; background-color: yellow;\"><strong>\ucee8\ud2b8\ub864\ud30c\uc77c <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c1\ud669 \ud0d0\uc9c0 <\/strong><\/span><\/div>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ub9cc\uc57d CKPT process\uac00 \uc874\uc7ac \ud558\uba74 CKPT process\uc5d0 \uc758\ud574\uc11c, \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 LGWR process\uc5d0 \uc758\ud574\uc11c error stack OPIRIP, ORA-00447, ORA-00302, ORA-00202\uac00 \ubc1c\uc0dd\ud55c\ub2e4. <\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 55pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 454px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: 0.75pt solid;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00202 : CONTROL FILE : &#8216;file name&#8217; <strong>&lt; &#8211;<\/strong> \uc190\uc0c1\ub41c file\uc774\ub984 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00302 : limit of %s logs exceeded <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00447 : fatal error in background process<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>&nbsp;<\/p>\n<ul style=\"margin-left: 42pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ud558\ub098\uc758 \ucee8\ud2b8\ub864\ud30c\uc77c \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<ul>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Shutdown abort <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc190\uc0c1\ub41c \ucee8\ud2b8\ub864\ud30c\uc77c\uc744 \ud655\uc778\ud558\uae30 \uc704\ud574 Background process trace file\uc744 \uc810\uac80\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc190\uc0c1\ub41c \ucee8\ud2b8\ub864\ud30c\uc77c\uc744 good control file\ub85c \ub300\uccb4\ud558\uac70\ub098 ( OS\uc0c1\uc5d0\uc11c cp\ub4f1\uc758 \uba85\ub839\uc5b4 \uc774\uc6a9) , Init.ora\uc758 Control_files parameter\uc5d0\uc11c \uc190\uc2e4\ub41c \ucee8\ud2b8\ub864\ud30c\uc77c \uc774\ub984\uc744 \uc0ad\uc81c\ud55c\ub2e4. (\uc77c\ubc18\uc801\uc73c\ub85c, Init.ora\uc758 ifile\uc5d0 \uc815\uc758\ub41c Config.ora\uc5d0 Control_files parameter\uac00 \uc815\uc758\ub418\uc5b4 \uc788\ub2e4.) <\/span><\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Startup <\/span><\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul style=\"margin-left: 46pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubaa8\ub4e0 \ucee8\ud2b8\ub864\ud30c\uc77c \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubc31\uc5c5 \ucee8\ud2b8\ub864\ud30c\uc77c\uc744 \uc774\uc6a9\ud55c \ubcf5\uad6c <\/strong><\/span><\/div>\n<p style=\"margin-left: 8pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ubc31\uc5c5 \ucee8\ud2b8\ub864\ud30c\uc77c\uc744 \uc0ac\uc6a9\ud560 \uacbd\uc6b0 RESETLOGS option\uc774\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c Open\ud574\uc57c \ud558\ubbc0\ub85c, \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ucd5c\ud6c4\uc758 Option\uc774\ub2e4. \ub610\ud55c, RESETLOGS option\uc744 \uc774\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c Open\ud55c \ud6c4 \ubc18\ub4dc\uc2dc DB full backup\uc744 \ud574\uc57c \ud55c\ub2e4. <\/span><\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 124pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Shutdown abort <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Backup \ucee8\ud2b8\ub864\ud30c\uc77c\uc744 restore\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Startup mount <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Recover database using backup controlfile; <\/span><\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database open resetlogs; <\/span><\/div>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ul style=\"margin-left: 68pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c8\ub85c \uc0dd\uc131\ub41c \ucee8\ud2b8\ub864\ud30c\uc77c\uc744 \uc774\uc6a9\ud55c \ubcf5\uad6c <\/strong><\/span><\/div>\n<p style=\"margin-left: 8pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;alter database backup controlfile to trace &#8216; \uba85\ub839\uc5d0 \uc758\ud574 create controlfile script\uac00 \ub9cc\ub4e4\uc5b4\uc838 \uc788\ub2e4\uace0 \uac00\uc815\ud55c\ub2e4. <\/span><\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 110pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Shutdown abort <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Background process\ub97c \uae30\ub3d9\ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; startup nomount; <\/span><\/p>\n<ol style=\"margin-left: 110pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc774\uc804\uc5d0 \uc0dd\uc131\ub41c create control file script\ub97c \uc774\uc6a9\ud558\uc5ec CREATE CONTROLFILE \uba85\ub839\uc5b4\ub97c \uc218\ud589\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Media recovery\ub97c \uc218\ud589\ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; recover database ; <\/span><\/p>\n<ol style=\"margin-left: 110pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">DB\ub97c Open\ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; alter database open; <\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515; background-color: yellow;\"><strong>\uc628\ub77c\uc778 \ub9ac\ub450 \ub85c\uadf8 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ud2b9\uc815 group\uc758 online redo log member \uc911 \ud558\ub098\ub9cc \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c1\ud669 \ud0d0\uc9c0 <\/strong><\/span><\/div>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Redo log switch\uac00 \ubc1c\uc0dd\ud560 \ub54c, Alert.log\uc5d0 ORA-00316, ORA-00312, ORA-00321\uac00 \uae30\ub85d\ub41c\ub2e4. \ucd94\uac00\uc801\uc73c\ub85c LGWR\ub3c4 ORA-00312\ub97c \ubc1c\uc0dd\uc2dc\ud0a8\ub2e4. <\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 58pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 463px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: 0.75pt solid;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00312 : online log 1 thread 1: &#8216;file name&#8217; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00316 : log 1 of thread 1, type %s in header is not log file <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00321 : log 1 of thread 1, cannot update log file header<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 55pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">V$LOG\uc758 status\uac00 &#8216;STALE&#8217; \ud639\uc740 &#8216;INVALID&#8217;\uc778\uc9c0\ub97c \ud655\uc778\ud574\uc57c \ud55c\ub2e4. <\/span><\/p>\n<ul style=\"margin-left: 53pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 77pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Invalid \uc774\uac70\ub098 Stale \uc0c1\ud0dc\uc778 redo log member\ub97c drop\ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; alter database drop logfile member &#8216;file name&#8217;; <\/span><\/p>\n<ol style=\"margin-left: 77pt;\">\n<li>\n<div><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Log member\ub97c \uc7ac \uc0dd\uc131\ud55c\ub2e4. <\/span><\/div>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; alter database add logfile member &#8216;file name&#8217; to group 1; <\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>Archive\ub41c redo log group\uc758 \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c1\ud669 \ud0d0\uc9c0 <\/strong><\/span><\/div>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">LGWR process\uac00 error stack OPIRIP, ORA-00447\uc744 \ubc1c\uc0dd\uc2dc\ud0a8\ub2e4. LGWR\uc758 fail\uc740 \ub2e4\ub978 background process(PMON)\uc758 fail\ub3c4 \uc57c\uae30\ud55c\ub2e4. <\/span><\/p>\n<\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 77pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc190\uc2e4\ub41c log group\uc744 drop\ud558\uace0 \uc7ac \uc0dd\uc131\ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; alter database drop logfile group 1; <\/span><\/p>\n<p style=\"margin-left: 77pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; alter database add logfile group 1 &#8216;log1RECO.dbf&#8217; size 500k; <\/span><\/p>\n<ol style=\"margin-left: 77pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\ub9cc\uc57d \uc131\uacf5\ud558\uc9c0 \ubabb\ud558\uba74, \ub2e4\uc74c\uc758 \uacfc\uc815\uc744 \uc218\ud589\ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Shutdown abort <\/span><\/p>\n<p style=\"margin-left: 77pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Startup mount <\/span><\/p>\n<p style=\"margin-left: 77pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc190\uc2e4\ub41c redo log group\uc744 \uc0ad\uc81c\ud55c\ub2e4. <\/span><\/p>\n<p style=\"margin-left: 77pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; alter database drop logfile group 1; <\/span><\/p>\n<p style=\"margin-left: 77pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database open ( Crash recovery ) <\/span><\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>Archive\ub418\uc9c0 \uc54a\uc740 redo log group\uc758 \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c1\ud669 \ud0d0\uc9c0 <\/strong><\/span><\/div>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ARCH process\uac00 archival\uc815\uc9c0 \uba54\uc138\uc9c0\ub97c \ubc1c\uc0dd\uc2dc\ud0a8\ub2e4. \u2013 ARCH : Archival stopped, error occurred. \uacc4\uc18d\ud574\uc11c online redo log\uc758 \ubb38\uc81c\ub97c \uc54c\ub824 \uc8fc\ub294 ORA-00255, ORA-00312 error\uc640 \uadf8 \uc6d0\uc778\uc744 \uc54c\ub824 \uc8fc\ub294 \ud2b9\uc815 error\uac00 \ubc1c\uc0dd\ud55c\ub2e4. \uac19\uc740 error\uac00 archival stoppage message\uc640 \ud568\uaed8 alert log file\uc5d0\ub3c4 \ubc1c\uc0dd\ud55c\ub2e4. <\/span><\/p>\n<\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 77pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Shutdown abort <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Startup mount <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database NoArchivelog <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc190\uc2e4\ub41c redo log\ub97c \uc0ad\uc81c\ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; alter database drop logfile group 1; <\/span><\/p>\n<ol style=\"margin-left: 77pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database Open ( Crash recovery ) <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Shutdown normal <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Startup mount <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database Archivelog <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database Open <\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ud604\uc7ac\uc758 online redo log group\uc758 \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c1\ud669 \ud0d0\uc9c0 <\/strong><\/span><\/div>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">LGWR process\uac00 error stack OPIRIP, ORA-00447\uc744 \ubc1c\uc0dd\uc2dc\ud0a8\ub2e4. LGWR\uc758 fail\uc740 \ub2e4\ub978 background process\uc758 fail\ub3c4 \uc57c\uae30\ud560 \uc218 \uc788\uc73c\uba70, Alert.log\uc5d0\ub3c4 Background process fail error \uba54\uc138\uc9c0\uc640 ORA-00312, ORA-00313 error\uac00 \ubc1c\uc0dd\ud55c\ub2e4. <\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 65pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 454px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: 0.75pt solid;\"><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00312: online log 1 thread 1: &#8216;\/users2\/chey\/RECO\/oradata\/log1RECO.dbf&#8217; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00313: open failed for members of log group 1 of thread 1<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 84pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">V$LOG\uc640 V$LOGFILE\uc744 \ud1b5\ud574 current log\uc778\uc9c0\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. <\/span><\/p>\n<ul style=\"margin-left: 53pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c restore\ud558\uace0 Incomplete recovery\ub97c \uc218\ud589\ud574\uc57c \ud55c\ub2e4. (Archive log mode\uc77c \uacbd\uc6b0) <\/span><\/p>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 77pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Full database backup restore <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Startup mount <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Recover database until cancel <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database open resetlogs <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Full database \ubc31\uc5c5\uc744 \ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<div style=\"margin-left: 66pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 492px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: 0.75pt solid;\"><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc608\uc81c) <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">$ cp backup\/*.dbf \/users2\/chey\/RECO\/oradata\/ &lt;&#8212; <strong>Full database backup restore<\/strong> <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; <span style=\"font-size: 8pt;\"><strong>startup &lt;&#8211; Database\uac00 mount\ub41c \uc0c1\ud0dc ( startup mount )<\/strong> <\/span><\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORACLE instance started. <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Total System Global Area 16963012 bytes <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Fixed Size 38868 bytes <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Variable Size 16506352 bytes <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Database Buffers 409600 bytes <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Redo Buffers 8192 bytes <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Database mounted. <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00313: open failed for members of log group 1 of thread 1 <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00312: online log 1 thread 1: &#8216;\/users2\/chey\/RECO\/oradata\/log1RECO.dbf&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>ORA-01109: database not open <\/strong><\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt;<strong> <span style=\"font-size: 8pt;\">recover database until cancel ; &lt;&#8211; Incomplete recovery<\/span><\/strong> <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Media recovery complete. <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; <span style=\"font-size: 8pt;\"><strong>alter database open ;<\/strong> <\/span><\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">alter database open <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">* <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01589: must use RESETLOGS or NORESETLOGS option for database open <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; <span style=\"font-size: 8pt;\"><strong>alter database open resetlogs; &lt;&#8211; RESETLOGS \ub97c \uc0ac\uc6a9\ud558\uc5ec Open<\/strong> <\/span><\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Statement processed.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515; background-color: yellow;\"><strong>SYSTEM \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>System \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c1\ud669 \ud0d0\uc9c0 <\/strong><\/span><\/div>\n<p style=\"margin-left: 31pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Disk failure\ub97c \uac80\uc0c9\ud558\uace0, \uadf8\uc5d0 \uad00\ub828\ub418\ub294 data file\uc744 \ucc3e\ub294\ub2e4. <\/span><\/p>\n<p style=\"margin-left: 31pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Startup\uc2dc \ub2e4\uc74c\uacfc \uac19\uc740 error\uac00 \ubc1c\uc0dd\ud55c\ub2e4. <\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 75pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 454px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: 0.75pt solid;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01157: cannot identify data file 1 &#8211; file not found <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01110: data file 1: &#8216;\/users2\/chey\/RECO\/oradata\/systRECO.dbf&#8217;<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<ul style=\"margin-left: 42pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>Data dictionary object\uc758 corruption <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c1\ud669 \ud0d0\uc9c0 <\/strong><\/span><\/div>\n<p style=\"margin-left: 2pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Data dictionary object\uc5d0 ORA-1578 error\uac00 \ubc1c\uc0dd\ud558\uace0, data dictionary corruption\uc5d0 \ud574\ub2f9\ud558\ub294 ORA-600 error\uac00 Alert file\uc5d0 \uae30\ub85d\ub41c\ub2e4. <\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 75pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 454px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: 0.75pt solid;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01578 : ORACLE data block corrupted (file # %s, block # %s)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<ul style=\"margin-left: 42pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>System \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uc190\uc2e4\uc5d0 \ub530\ub978 \ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 88pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc190\uc0c1\ub41c Datafile restore <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Startup mount <\/span><\/li>\n<li>\n<div><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database datafile &#8216;system01.dbf&#8217; online; <\/span><\/div>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&lt;&#8211; V$DATAFILE VIEW\ub97c \ud1b5\ud574 file\uc774 Online\uc0c1\ud0dc\uc778\uc9c0\ub97c \ud655\uc778\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Recover Database <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database open <\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515; background-color: yellow;\"><strong>TEMP \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul style=\"margin-left: 42pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>Temporary \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 datafile\uc758 \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc0c1\ud669 \ud0d0\uc9c0 <\/strong><\/span><\/div>\n<p style=\"margin-left: 9pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Disk failure\ub97c \ud0d0\uc9c0\ud558\uace0 , \uad00\uacc4\ub418\ub294 Oracle file\uc744 \uc54c\uc544 \ub0b8\ub2e4. <\/span><\/p>\n<\/li>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 88pt;\">\n<li>\n<div><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\ud604\uc7ac\uc758 Temporary \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c drop\ud55c\ub2e4. <\/span><\/div>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; Drop tablespace TEMP including contents; <\/span><\/li>\n<li>\n<div><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\ub2e4\ub978 Temporary \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4. <\/span><\/div>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; Create tablespace TEMP datafile &#8216;temp01.dbf&#8217; size 100m; <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0ac\uc6a9\uc790\uc5d0\uac8c Temp \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ud560\ub2f9 <\/span><\/li>\n<\/ol>\n<p><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; Alter user scott temporary tablespace TEMP; <\/span><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515; background-color: yellow;\"><strong>\uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub370\uc774\ud130\ud30c\uc77c\uc758 \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc778\ub371\uc2a4 \ub370\uc774\ud130\ud30c\uc77c\uc758 \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<ul>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc778\ub371\uc2a4 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc7ac\uc0dd\uc131 <\/strong><\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 112pt;\">\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Index \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c drop\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\ub2e4\ub978 Index \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub0b4\uc758 \ubaa8\ub4e0 Index\ub97c \uc7ac \uc0dd\uc131\ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<ul style=\"margin-left: 90pt;\">\n<li>\n<div><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubc31\uc5c5\uc744 restore\ud558\uace0 recover <\/strong><\/span><\/div>\n<ul>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c Offline\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Hot backup\uc73c\ub85c\ubd80\ud130 restore\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Autorecovery\ub97c on\uc73c\ub85c set. <\/span><\/li>\n<li>\n<div><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Recovery process\ub97c \uc218\ud589\ud55c\ub2e4. <\/span><\/div>\n<p style=\"margin-left: 8pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Recover tablespace INDEX1. <\/span><\/p>\n<p style=\"margin-left: 8pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter database INDEX1 online <\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul style=\"margin-left: 42pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ud14c\uc774\ube14 \ub370\uc774\ud130\ud30c\uc77c\uc758 \uc190\uc2e4 <\/strong><\/span><\/div>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 90pt;\">\n<li>\n<div><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ud14c\uc774\ube14\uc744 \uc7ac\uc0dd\uc131. <\/strong><\/span><\/div>\n<ol>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Table\uc758 export\ub97c import\ud55c\ub2e4. <\/span><\/li>\n<\/ol>\n<p style=\"margin-left: 11pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">$ imp userid=system\/manager tables=table_name file=exp <\/span><\/p>\n<p style=\"margin-left: 11pt;\">\n<\/li>\n<li>\n<div><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubc31\uc5c5\uc73c\ub85c \ubd80\ud130 restore\ud55c \ud6c4 recover. <\/strong><\/span><\/div>\n<ol>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c Offline\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Hot backup\uc73c\ub85c\ubd80\ud130 restore\ud55c\ub2e4. <\/span><\/li>\n<li><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Autorecovery\ub97c on\uc73c\ub85c set. <\/span><\/li>\n<li>\n<div><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Recovery process\ub97c \uc218\ud589\ud55c\ub2e4. <\/span><\/div>\n<p style=\"margin-left: 6pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">recover automatic tablespace APPL01. <\/span><\/p>\n<p style=\"margin-left: 6pt;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alter tablespace APPL01 online. <\/span><\/p>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<div style=\"margin-left: 105pt;\">\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 492px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border: 0.75pt solid;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc608\uc81c ) <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Alert.log\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 Error\uac00 \ubc1c\uc0dd\ud55c\ub2e4. <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Errors in file \/users2\/chey\/RECO\/dump\/dbwr_5757.trc: <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01157: cannot identify data file 4 &#8211; file not found <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01110: data file 4: &#8216;\/users2\/chey\/RECO\/oradata\/usrRECO01.dbf&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-07360: sfifi: stat error, unable to obtain information about file. <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">HP-UX Error: 2: No such file or directory <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt; select status,name from v$datafile where status != &#8216;ONLINE&#8217; ; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">STATUS NAME <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SYSTEM \/users2\/chey\/RECO\/oradata\/systRECO.dbf <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>RECOVER<\/strong> \/users2\/chey\/RECO\/oradata\/usrRECO01.dbf <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\u00a0\u00a0\u00a0\u00a0&lt;- V$DATAFILE\uc758 STATUS\ub97c \ud655\uc778\ud55c\ub2e4. <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt;<strong> alter tablespace USERS offline;<\/strong> <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">alter tablespace users offline <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">* <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01191: file 4 is already offline &#8211; cannot do a normal offline <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-01110: data file 4: &#8216;\/users2\/chey\/RECO\/oradata\/usrRECO01.dbf&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>$ cp usrRECO01.bak \/users2\/chey\/RECO\/oradata\/usrRECO01.dbf <\/strong><\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\u00a0\u00a0\u00a0\u00a0&lt;&#8212; Hotbackup\uc73c\ub85c\ubd80\ud130 USERS \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 datafile restore<\/strong> <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt;<strong> set autorecovery on <\/strong><\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\u00a0\u00a0\u00a0\u00a0&lt;&#8211; Automatic recovery\ub97c \uc704\ud574\uc11c arhcive log\ub294 <\/strong><\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\u00a0\u00a0\u00a0\u00a0 Init.ora\uc758 LOG_ARCHIVE_DEST\uc5d0 \uc9c0\uc815\ub41c \uc704\uce58\uc5d0 \uc788\uc5b4\uc57c \ud55c\ub2e4. <\/strong><\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Autorecovery ON <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt;<strong> Recover tablespace USERS;<\/strong> <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Statement processed. <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SVRMGR&gt;<strong> alter tablespace USERS online;<\/strong> <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">Statement processed.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515; background-color: yellow;\"><strong>Flashback\uc744 \uc774\uc6a9\ud55c DELETE \ubcf5\uad6c <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>(\u3131) timestamp\ub97c \uc774\uc6a9\ud55c \ubc29\ubc95 <\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0ac\uc6a9 \uac00\ub2a5 \uc5ec\ubd80 \uc870\ud68c(undo_management = auto) <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; show parameter undo <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">NAME TYPE VALUE <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">undo_management string AUTO <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">undo_retention integer 1800 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">undo_tablespace string UNDOTBS1 <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uad8c\ud55c \ubd80\uc5ec <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; grant execute on dbms_flashback to scott; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Grant succeeded. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud604\uc7ac \uc2dc\uac04 \uc870\ud68c <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; <span style=\"color: red;\"><strong>select systimestamp from dual ;<\/strong><\/span> <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SYSTIMESTAMP <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">04-NOV-13 05.55.51.524776 PM +09:00 <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">delete \uc791\uc5c5 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; delete emp where deptno=20 ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">5 rows deleted. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">commit <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; commit ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Commit complete. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc0ad\uc81c \ub418\uc5c8\ub294\uc9c0 \uc870\ud68c <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; select empno from emp where deptno=20 ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">no rows selected <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">as of timestamp\ub97c \uc774\uc6a9\ud55c \uc870\ud68c <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; <span style=\"color: red;\"><strong>select empno from emp as of timestamp(to_timestamp(&#8217;04-NOV-13 05.55.51&#8242;,&#8217;DD-MON-YY:HH24:MI:SS&#8217;)) where deptno=20 ; <\/strong><\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">EMPNO <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">&#8212;&#8212;&#8212;- <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7369 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7566 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7788 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7876 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7902 <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ud604\uc7ac \ud14c\uc774\ube14\uc5d0 \uc788\ub294\uc9c0 \ub2e4\uc2dc \uc870\ud68c <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; select empno from emp where deptno=20 ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">no rows selected <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">as of timestamp\ub97c \uc774\uc6a9\ud574 insert <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL<span style=\"color: red;\">&gt; <strong>insert into emp select * from emp as of timestamp(to_timestamp(&#8217;04-NOV-13 05.55.51&#8242;,&#8217;DD-MON-YY:HH24:MI:SS&#8217;)) where deptno=20 ;<\/strong><\/span> <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">5 rows created. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">commit <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; commit ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Commit complete. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">insert \uc791\uc5c5 \uc870\ud68c <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; select empno from emp where deptno=20 ; <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">EMPNO <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">&#8212;&#8212;&#8212;- <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7369 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7566 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7788 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7876 <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">7902 <\/span><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515; background-color: yellow;\"><strong>Purge \ud734\uc9c0\ud1b5 \uae30\ub2a5\uc744 \uc774\uc6a9\ud55c DROP TABLE \ubcf5\uad6c <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; conn scott\/tiger <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Connected. <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; select * from emp ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">&#8230; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">14 rows selected. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; drop table emp ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Table dropped. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; commit ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Commit complete. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; select * from emp ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">select * from emp <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">* <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ERROR at line 1: <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">ORA-00942: table or view does not exist <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL<span style=\"color: red;\"><strong>&gt; flashback table emp to before drop ;<\/strong><\/span> <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Flashback complete. <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt; select * from emp ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">&#8230; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">14 rows selected <\/span><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-size: 12pt; font-family: \ub9d1\uc740 \uace0\ub515; background-color: yellow;\"><strong>Table \uc744 Truncate \ud588\uc744 \ub54c \ubcf5\uad6c <\/strong><\/span><\/div>\n<ul style=\"margin-left: 44pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ubcf5\uad6c \uacfc\uc815 <\/strong><\/span><\/div>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"margin-left: 70pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\uc6b4\uc601 DB \uc758 control file trace backup \ud558\uc5ec \ucee8\ud2b8\ub864 \ud30c\uc77c \uc0dd\uc131 \uc2a4\ud06c\ub9bd\uc791\uc131 <\/strong><\/span><\/div>\n<ol>\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><span style=\"color: black;\">alter database backup controlfile to trace ; =&gt; udump \uc5d0 \uac00\uc11c trace file \uc744 \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815\ud55c\ub2e4.<\/span> <\/span><\/div>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><span style=\"color: black;\">\uc608)<\/span> <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">CREATE CONTROLFILE REUSE DATABASE &#8220;TECHDATA&#8221; RESETLOGS ARCHIVELOG <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">MAXLOGFILES 192 <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">MAXLOGMEMBERS 3 <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">MAXDATAFILES 1024 <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">MAXINSTANCES 32 <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">MAXLOGHISTORY 4672 <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">LOGFILE <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 1 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog01&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog11&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 2 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog02&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog12&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 3 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog03&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog13&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 4 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog04&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog14&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 5 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog05&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog15&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 6 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog06&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog16&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 7 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog07&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog17&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 8 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog08&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog18&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 9 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog09&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog19&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">GROUP 10 ( <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog10&#8217;, <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rredolog20&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">) SIZE 1000M <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8212; STANDBY LOGFILE <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">DATAFILE <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">&#8216;\/dev\/rtd_vg01_rlvol30&#8217; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg07_rlvol35&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata08_36&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg01_rlvol31&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg22_rlvol17&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg16_rlvol2 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg07_rlvol7 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg07_rlvol32&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg07_rlvol10&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata08_06&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata16_22&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata08_65&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata08_94&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rti_vg23_rlvol13&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rti_vg21_rlvol18&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rti_vg15_rlvol3 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rti_vg15_rlvol7 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rti_vg08_rlvol5 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rti_vg08_rlvol1 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rindex08_04&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rindex08_10&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rindex08_11&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rindex04_13&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rindex04_19&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rindex08_54&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg17_rlvol11&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg16_rlvol1 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg14_rlvol1 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg16_rlvol3 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg17_rlvol10&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata08_15&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata08_35&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata04_22&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata16_26&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg01_rlvol35&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg07_rlvol8 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg15_rlvol1 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg14_rlvol7 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg17_rlvol4 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rtd_vg20_rlvol9 &#8216; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata04_15&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata04_19&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">,&#8217;\/dev\/rdata16_30&#8242; <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">CHARACTER SET KO16KSC5601 <\/span><\/p>\n<p><span style=\"font-size: 8pt; font-family: \ub9d1\uc740 \uace0\ub515;\">; <\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">RAC =&gt; Single <\/span><\/p>\n<p style=\"margin-left: 70pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\ucee8\ud2b8\ub864 \ud30c\uc77c \uc791\uc131\uc2dc\ub294 \ud14c\uc774\ube14\uc774 \uc18d\ud55c TABLE, INDEX tablespace ,SYSTEM <\/span><\/p>\n<p style=\"margin-left: 70pt;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">Undo, redo, SYSAUX tablespace \ud3ec\ud568\ud55c datafile \uc744 \uc704\uc758 \uc608\ucc98\ub7fc \uc5f4\uac70\ud55c\ub2e4 <\/span><\/p>\n<ol style=\"margin-left: 70pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>\ub2e4\ub978 DB \uc5d0\uc11c init \ud30c\ub77c\ubbf8\ud130\ub97c \ub9cc\ub4e4\uc5b4 startup nomount \ud55c\ub2e4. <\/strong><\/span><\/div>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">startup nomount pfile=&#8217;\ud574\ub2f9 \uacbd\ub85c\uba85&#8217; ; <\/span><\/p>\n<p><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\">\uc704\uc758 \ucee8\ud2b8\ub864 \ud30c\uc77c \uc608\ucc98\ub7fc control file \uc744 \ub9cc\ub4e0\ub2e4. \ucee8\ud2b8\ub864 \ud30c\uc77c\uc744 \ub9cc\ub4e4\uba74 \uc790\ub3d9\uc73c\ub85c DB \ub294 Open \uc0c1\ud0dc\uac00 \ub41c\ub2e4. <\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol style=\"margin-left: 70pt;\">\n<li>\n<div style=\"text-align: justify;\"><span style=\"font-family: \ub9d1\uc740 \uace0\ub515;\"><strong><span style=\"font-size: 10pt;\">\ud574\ub2f9 \uc2dc\uac04 \uc2dc\uc810\uc73c\ub85c \ubcf5\uad6c <\/span><\/strong><\/span><\/div>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">SQL&gt;Recover database until time &#8216;2009-11-09:15:41:11&#8217; using backup controlfile ; <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">RAC =&gt; single\ub85c \ubcf5\uad6c \ud558\uae30 \uc704\ud574\uc120 \ud574\ub2f9 archive \ud30c\uc77c\uc744 \ucc98\uc74c \uba85\uc2dc\ud558\uc5ec \uc785\ub825\ud574\uc57c \ud55c\ub2e4. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">( \uc8fc\uc758 auto \ud558\uba74 \uc790\ub3d9\uc73c\ub85c \uc544\uce74\uc774\ube0c \ud30c\uc77c\uc744 \ubabb \ucc3e\ub294\ub2e4 RAC \uc77c \ub54c) <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\ud574\ub2f9 \uc544\uce74\uc774\ube0c \ubaa8\ub450 \uc801\uc6a9\ud558\uace0 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c open \ud55c\ub2e4. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">alter database open resetlogs ; <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">open \uc774\ud6c4 alert log \ub97c \ubcf4\uba74 \uc774\uc0c1\ud55c \uba54\uc2dc\uc9c0\ub4e4\uc774 \ub9ce\uc774 \ub5a8\uc5b4\uc9c4\ub2e4. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\ubb34\uc2dc\ud558\uace0 \ub2e4\uc74c hidden parameter \uc801\uc6a9\ud558\uace0 DB \ub97c \uc7ac \uae30\ub3d9 \ud558\uc5ec mount\uae4c\uc9c0 \ud558\uace0 \ub2e4\uc2dc <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>_no_recovery_through_resetlogs=TRUE <\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">alter database open resetlogs ; \ud558\uc5ec open \ud55c\ub2e4. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 10pt; font-family: \ub9d1\uc740 \uace0\ub515;\"><strong>&lt; \ucc38\uace0 \uc0ac\ud56d &gt; <\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc544\uce74\uc774\ube0c \ud30c\uc77c\uc774 \ub9ce\uc544 \ud30c\uc77c\uc2dc\uc2a4\ud15c\uc774 \ubd80\uc871\ud560 \uacbd\uc6b0 nfs \uc5d0 \ub9c8\uc6b4\ud2b8 \ud558\uc5ec \uc544\uce74\uc774\ube0c\ub97c restore \ud560 \ub54c\ub294 \ub9c8\uc6b4\ud2b8 \uc635\uc158\uc744 \uc54c\ub9de\uac8c \uc918\uc57c \ud55c\ub2e4. \ub610\ud55c AIX \uc5d0\uc11c\ub098 \ub2e4\ub978 UNIX \uc2dc\uc2a4\ud15c\uc5d0 <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\/etc\/filesystems \uc5d0 nfs \ub9c8\uc6b4\ud2b8\uc5d0 \ub300\ud55c \uc815\uc758\ub97c \ud574\uc57c \ud55c\ub2e4. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\uc608) \/etc\/filesystems <\/span><\/p>\n<p style=\"text-align: justify;\">\n<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">\/oraarch: <\/span><\/p>\n<p style=\"text-align: justify; margin-left: 44pt;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">dev = &#8216;172.18\u2026\u2026. <\/span><\/p>\n<p style=\"text-align: justify; margin-left: 44pt;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">vfs = jfs2 <\/span><\/p>\n<p style=\"text-align: justify; margin-left: 44pt;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">log = \/dev\/hd8 <\/span><\/p>\n<p style=\"text-align: justify; margin-left: 44pt;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">mount = true <\/span><\/p>\n<p style=\"text-align: justify; margin-left: 44pt;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">options = rw <\/span><\/p>\n<p style=\"text-align: justify; margin-left: 70pt;\"><span style=\"font-size: 9pt; font-family: \ub9d1\uc740 \uace0\ub515;\">account = false <\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Technical Service \uc624\ub77c\ud074 DB \uc7a5\uc560 \ucf00\uc774\uc2a4 \ubcc4 \ubcf5\uad6c \ubc29\ubc95 \uc0ac\ub840 &nbsp; &nbsp; \ubcf5\uad6c \uc808\ucc28\/\ubc29\ubc95 \uae30\uc220\uc11c &nbsp; \uac1c\uc694 \uc5ec\uae30\uc5d0\uc11c\ub294 \uc624\ub77c\ud074\uc5d0\uc11c\uc758 \uc5ec\ub7ec \uac00\uc9c0 \uc7a5\uc560\uc720\ud615\ubcc4\ub85c \ubcf5\uad6c\uc808\ucc28\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \uae30\uc220\ud55c\ub2e4. &nbsp; NOARHCIVELOG \ubaa8\ub4dc\uc5d0\uc11c\uc758 \ubcf5\uad6c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 NOARCHIVELOG mode\ub85c \uc6b4\uc601 \uc911 \ub370\uc774\ud130\ubca0\uc774\uc2a4 Crash\uac00 \ubc1c\uc0dd\ud588\ub2e4\uba74, \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uac00\uc7a5 \ucd5c\uadfc\uc758 Offline full backup\uc744 restore\ud558\uac70\ub098 full database export\uac00 \uc788\ub2e4\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc7ac\uc0dd\uc131\ud558\uace0 Data\ub97c import\ud568\uc73c\ub85c\uc368 \ubcf5\uad6c\uac00 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[12,13],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/304"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=304"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/304\/revisions"}],"predecessor-version":[{"id":1570,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/304\/revisions\/1570"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=304"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}