{"id":2131,"date":"2018-01-26T10:35:04","date_gmt":"2018-01-26T01:35:04","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2131"},"modified":"2018-01-26T10:39:22","modified_gmt":"2018-01-26T01:39:22","slug":"oracle-12c-recover-table%eb%aa%85%eb%a0%b9%ec%96%b4%eb%a1%9c-table-%eb%b3%b5%ea%b5%ac%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2131","title":{"rendered":"[Oracle 12c] Recover table\uba85\ub839\uc5b4\ub85c Table \ubcf5\uad6c\ud558\uae30"},"content":{"rendered":"

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/b><\/p>\n

RECOVER TABLE<\/span><\/span><\/b><\/p>\n


\n<\/span><\/span><\/b>\uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud55c \ubc31\uc5c5 \ud30c\uc77c\uc5d0\uc11c \ud2b9\uc815 \ud14c\uc774\ube14 \ubcf5\uad6c<\/span><\/b><\/p>\n

\u00a0<\/span><\/span><\/b><\/p>\n

\uc5ec\ub7ec\uac00\uc9c0 \ub370\uc774\ud130 \uc190\uc2e4\uc5d0 \ub300\ud55c \uc7a5\uc560\uc5d0 \ub530\ub978FLASHBACK, LOGMINER, RECYCLEBIN <\/span>\ub4f1 \uc644\uc804 \ubcf5\uad6c \ubc29\ubc95\uc740 \ub9ce\uc2b5\ub2c8\ub2e4<\/span>. <\/span><\/span><\/p>\n

\ud558\uc9c0\ub9cc\u00a0TRUNCATE TABLE <\/span>\uc5d0 \ub300\ud55c \uc644\uc804 \ubcf5\uad6c\ub97c \ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c\ub294 \uc55e\uc5d0\uc11c \uc0b4\ud3b4\ubcf8 \ubc31\uc5c5\ubcf8\uc744 \ud0c0 \uc11c\ubc84\uc5d0 \ub0b4\ub824\uc11c \uc62c\ub824\uc11c \ubcf5\uad6c\ud558\ub294 \ubc29\ubc95 \ubc16\uc5d0 \uc5c6\uc5c8\uc2b5\ub2c8\ub2e4<\/span>. <\/span><\/span><\/p>\n

Oracle 12C <\/span><\/span>\ubc84\uc804\uc5d0\uc11c\ub294 \ud2b9\uc815 \ud14c\uc774\ube14\ub9cc \ubc31\uc5c5 \ub370\uc774\ud130 \uc5d0\uc11c \ubcf5\uad6c \ud558\ub294RECOVER TABLE <\/span>\uae30\ub2a5\uc774 \uc81c\uacf5 \ub429\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\uc9c0\uae08\ubd80\ud130RECOVER TABLE <\/span>\uae30\ub2a5\uc744 \uc774\uc6a9\ud558\uc5ec \ubcf5\uad6c\ud558\ub294 \uc2e4\uc2b5\uc744 \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\n\n\n\n\n
\n

SQL> <\/span><\/span>\ud14c\uc2a4\ud2b8 \uc720\uc800 \uc0dd\uc131 <\/span><\/p>\n

SQL> <\/span><\/span>\ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uc0dd\uc131 <\/span><\/p>\n

SQL> <\/span><\/span>\ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14\uc5d0 \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130 \uc0dd\uc131<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image001[4]\"<\/a><\/span><\/p>\n

\"clip_image002[4]\"<\/a><\/span><\/p>\n

\"clip_image003[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/p>\n

\uc774\uc81c\u00a0RMAN <\/span>\ubc31\uc5c5\uc744 \uc218\ud589 \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\n\n\n\n\n
\n

# rman target \/<\/span><\/span><\/p>\n

RMAN> BACKUP AS COMPRESSED
\nBACKUPSET DATABASE ;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image004[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u00a0<\/span><\/span><\/p>\n

\uc774\uc81cTRUNCATE TABLE <\/span>\uc7a5\uc560\ub97c \ubc1c\uc0dd \uc2dc\ud0b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\n\n\n\n\n
\n

SQL> ALTER SESSION SET
\nNLS_DATE_FORMAT=’YYYY\/MM\/DD HH24:MI:SS’ ;<\/span><\/span><\/p>\n

SQL> SELECT SYSDATE FROM DUAL ;<\/span><\/span><\/p>\n

SQL> TRUNCATE TABLE EMP ;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image005[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/p>\n

\uc774\uc81cRECOVER TABLE <\/span>\uba85\ub839\uc73c\ub85c \ubcf5\uad6c\ub97c \uc2dc\uc791\ud569\ub2c8\ub2e4. <\/span>\uc6b4\uc601DB<\/span>\uac00OPEN<\/span>\uc778 \uc0c1\ud0dc\uc5d0\uc11c \uc2e4\ud589 \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\n\n\n\n\n
\n

SQL> RENAME EMP TO EMP_BACK ;<\/span><\/span><\/p>\n

RMAN> RECOVER TABLE YONGSEOK.EMP UNTIL TIME “TO_DATE(‘2017-11-28:16:18:21′,’yyyy-mm-dd:hh24:mi:ss’)” AUXILIARY DESTINATION ‘\/oracle\/oracle12\/RECOVER_TAB_AREA’ ;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image006[4]\"<\/a><\/span><\/p>\n

\"clip_image007[4]\"<\/a><\/span><\/p>\n

\"clip_image008[4]\"<\/a><\/span><\/p>\n

\"clip_image009[4]\"<\/a><\/span><\/p>\n

\"clip_image010[4]\"<\/a><\/span><\/p>\n

\"clip_image011[4]\"<\/a><\/span><\/p>\n

\"clip_image012[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

RMAN<\/span><\/span>\uc758RECOVER TABLE <\/span>\uba85\ub839\uc5b4\ub97c \uc218\ud589 \ud558\uba74 \ud574\ub2f9TABLE<\/span>\uc758 \ubc31\uc5c5 \uc2dc\uc810\uc5d0 \ud544\uc694\ud55c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 \ud544\uc694\ud55c \ubc31\uc5c5\ub370\uc774\ud0c0 \ud30c\uc77c\uacfc \uae30\ubcf8\uc801\uc73c\ub85c \ud544\uc694\ud55cDB<\/span>\uc758 \uae30\ubcf8 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4SYSTEM, SYSAUX, UNDO <\/span>\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc640 \ud568\uaed8 \ud574\ub2f9 \uc601\uc5ed\uc5d0 \ubcf5\uc81cDB<\/span>\ub97c \uc0dd\uc131 \ud55c\ub2e4<\/span>.<\/span><\/span><\/p>\n

\uadf8\ub9ac\uace0 \ub098\uc11c \ub9cc\ub4e4\uc5b4\uc9c4 \ubcf5\uc81cDB<\/span>\uc5d0\uc11c \ud574\ub2f9TABLE <\/span>\uc744 \ub370\uc774\ud130\ud38c\ud504EXPDP<\/span>\ub97c \uc774\uc6a9\ud574 \ucd94\ucd9c \ud574\uc11c \uc6d0\ub798 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85cIMPDP <\/span>\uc801\uc7ac \ub41c\ub2e4<\/span>. <\/span><\/span><\/p>\n

\uc774\uc804\uc758 \ubc84\uc804\uc5d0\uc11cDBA<\/span>\uac00 \uc218\uc791\uc5c5\uc73c\ub85c \uac01 \ub2e8\uacc4\ubcc4\ub85c \ubcf5\uad6c\ud574\uc57c \ud558\ub294 \uc77c\ub828\uc758 \uacfc\uc815\ub4e4\uc774 \ub2e8 \ud55c \uc904\uc758RMAN <\/span>\uba85\ub839\uc5b4\ub85c \uc9c4\ud589 \ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\uc774\uc81c \ubcf5\uad6c\uac00 \uc798 \ub418\uc5c8\ub294\uc9c0 \ud14c\uc774\ube14\uc744 \uc870\ud68c \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\n\n\n\n\n
\n

SQL> ALTER SESSION SET NLS_DATE_FORMAT=’YYYY\/MM\/DD HH24:MI:SS’ ;<\/span><\/span><\/p>\n

SQL> SELECT SYSDATE FROM DUAL ;<\/span><\/span><\/p>\n

SQL> SELECT * FROM EMP ;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image013[4]\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u00a0<\/span><\/span><\/p>\n

\uac04\ub2e8\ud55cRMAN <\/span>\uba85\ub839\uc5b4\ub85c \ud14c\uc774\ube14 \ubcf5\uad6c\uac00 \uc644\ub8cc \ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u00a0 \u00a0 RECOVER TABLE \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud55c \ubc31\uc5c5 \ud30c\uc77c\uc5d0\uc11c \ud2b9\uc815 \ud14c\uc774\ube14 \ubcf5\uad6c \u00a0 \uc5ec\ub7ec\uac00\uc9c0 \ub370\uc774\ud130 \uc190\uc2e4\uc5d0 \ub300\ud55c \uc7a5\uc560\uc5d0 \ub530\ub978FLASHBACK, LOGMINER, RECYCLEBIN \ub4f1 \uc644\uc804 \ubcf5\uad6c \ubc29\ubc95\uc740 \ub9ce\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc\u00a0TRUNCATE TABLE \uc5d0 \ub300\ud55c \uc644\uc804 \ubcf5\uad6c\ub97c \ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c\ub294 \uc55e\uc5d0\uc11c \uc0b4\ud3b4\ubcf8 \ubc31\uc5c5\ubcf8\uc744 \ud0c0 \uc11c\ubc84\uc5d0 \ub0b4\ub824\uc11c \uc62c\ub824\uc11c \ubcf5\uad6c\ud558\ub294 \ubc29\ubc95 \ubc16\uc5d0 \uc5c6\uc5c8\uc2b5\ub2c8\ub2e4. Oracle 12C \ubc84\uc804\uc5d0\uc11c\ub294 \ud2b9\uc815 \ud14c\uc774\ube14\ub9cc \ubc31\uc5c5 \ub370\uc774\ud130 \uc5d0\uc11c \ubcf5\uad6c \ud558\ub294RECOVER […]<\/p>\n","protected":false},"author":1,"featured_media":2069,"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":[20],"tags":[16],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/oracle-database-upgrade-12c.jpg?fit=625%2C325","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2131"}],"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=2131"}],"version-history":[{"count":7,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2131\/revisions"}],"predecessor-version":[{"id":2138,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2131\/revisions\/2138"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2069"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2131"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}