{"id":1122,"date":"2016-01-02T16:21:47","date_gmt":"2016-01-02T16:21:47","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1122"},"modified":"2016-01-02T16:21:47","modified_gmt":"2016-01-02T16:21:47","slug":"flashback-%ec%9d%b4%eb%9e%80","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1122","title":{"rendered":"Flashback \uc774\ub780"},"content":{"rendered":"<p style=\"margin-left: 0.4em;\"><span style=\"color:black; font-family:HY\ud5e4\ub4dc\ub77c\uc778M; font-size:15pt\"><strong>&nbsp; Flashback Database<\/strong><br \/>\n\t\t<\/span><\/p>\n<ul>\n<li><span style=\"color:black\">Oracle Database 10g \uc774\uc804\uae4c\uc9c0\ub294 transactional point-in-time recovery\ub97c \uc704\ud574\uc11c\ub294 backup\uc6a9 file\uacfc redo log file\uc744 \uc774\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uc2dc\uac04\uae4c\uc9c0 \ubcf5\uad6c\ub97c \ud574\uc57c\ub9cc \ud588\uc5c8\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774 \ubc29\ubc95\uc740 backup\uc6a9 file\uc774 \uc624\ub798\ub410\uace0,  archive log\uac00 \ub9ce\uc774 \uc313\uc5ec \uc788\uc744 \ub54c\ub294 \ub9ce\uc740 \uc2dc\uac04\uc774 \uc18c\uc694\ub420 \uc218 \ubc16\uc5d0 \uc5c6\uc2b5\ub2c8\ub2e4.Oracle 10g\ubd80\ud130\ub294  flashback database\ub97c \uc774\uc6a9\ud558\uc5ec \uc880 \ub354 \ube60\ub978 recovery\uac00 \uac00\ub2a5\ud558\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<br \/>\n<\/span><\/li>\n<li>\n<div><span style=\"color:black\">Flashback database\uc758 \uc0ac\uc6a9 \uc6a9\ub3c4\ub294 logical data corruption\uc774\ub098 user error\uc2dc \uc720\uc6a9\ud569\ub2c8\ub2e4. Flashback Database\uc758 \uc7a5\uc810\uc740 \uae30\uc874\uc758 point-in-time recovery\uc5d0 \ube44\ud574 \ub9e4\uc6b0 \ube60\ub978 recovery\uac00 \uac00\ub2a5\ud558\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. Flashback database\ub294 database\uc758 \ud06c\uae30\uc5d0 \ube44\ub840\ud574\uc11c recovery \uc2dc\uac04\uc774 \ub298\uc5b4\ub098\ub294 \uac83\uc774 \uc544\ub2c8\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<br \/>\n<\/span><\/div>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"color:black; font-family:HY\ud5e4\ub4dc\ub77c\uc778M; font-size:15pt\"><strong>Flashback Database\ub97c \uc704\ud574 \ud544\uc694\ud55c \uc694\uc18c<\/strong><br \/>\n\t\t\t\t<\/span><\/p>\n<\/li>\n<li><span style=\"color:black\">Database\uc758 ARCHIVELOG mode \uc6b4\uc601<br \/>\n<\/span><\/li>\n<li><span style=\"color:black\">Flashback log\ub97c \uc704\ud55c flash recovery area<br \/>\n<\/span><\/li>\n<li>\n<div><span style=\"color:black\">Real Application Cluster databases\ub294 Flash Recovery Area\ub97c clustered file system\uc774\ub098 ASM\uc5d0 \ub46c\uc57c \ud569\ub2c8\ub2e4.<br \/>\n<\/span><\/div>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"color:black; font-family:HY\ud5e4\ub4dc\ub77c\uc778M; font-size:15pt\"><strong>Flashback Drop<\/strong><br \/>\n\t\t\t\t<\/span><\/p>\n<\/li>\n<li>\n<div><span style=\"color:black\">Oracle 10g\ubd80\ud130\ub294 \uc544\ub798 \uadf8\ub9bc\uacfc \uac19\uc774 recycle bin(\ud734\uc9c0\ud1b5)\uc774 \uc788\uc5b4\uc11c \uc5b4\ub5a4 table\uc744 drop\ud558\uba74, drop\ub41c table\uacfc \ud574\ub2f9 table\uacfc \uad00\uacc4\ub418\ub294 object\ub4e4\uc744 \uc77c\ubc18\uc801\uc778 SQL \uba85\ub839\uc5b4\ub97c \ud1b5\ud574 \ub418\uc0b4\ub9b4 \uc218 \uc788\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<br \/>\n<\/span><\/div>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"color:black; font-family:HY\ud5e4\ub4dc\ub77c\uc778M; font-size:15pt\"><strong>Flashback Table<\/strong><br \/>\n\t\t\t\t<\/span><\/p>\n<\/li>\n<li>\n<div><span style=\"color:black\">\ud558\ub098\uc758 SQL \ubb38\uc7a5\uc73c\ub85c \ud55c \ud14c\uc774\ube14 \ud639\uc740 \uc5ec\ub7ec \ud14c\uc774\ube14\uc5d0 \ub300\ud574 \uacfc\uac70 \ud2b9\uc815 \uc2dc\uc810\uc73c\ub85c \ub418\ub3cc\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\n<\/span><\/div>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"color:black; font-family:HY\ud5e4\ub4dc\ub77c\uc778M; font-size:15pt\"><strong>Flaskback Query<\/strong><br \/>\n\t\t\t\t<\/span><\/p>\n<\/li>\n<li>\n<div><span style=\"color:black\">\ud558\ub098\uc758 SQL \ubb38\uc7a5\uc744 \ud1b5\ud574 UNDO \uc815\ubcf4\ub97c \uc774\uc6a9\ud574\uc11c \ud2b9\uc815 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uacfc\uac70 \ud2b9\uc815 \uc2dc\uc810\uc758 \ud14c\uc774\ube14 \ub370\uc774\ud130\ub97c \uac04\ud3b8\ud558\uac8c \uc870\ud68c\ud574 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\n<\/span><\/div>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"color:black; font-family:HY\ud5e4\ub4dc\ub77c\uc778M; font-size:15pt\"><strong>Flashback Version Query <\/strong><br \/>\n\t\t\t\t<\/span><\/p>\n<\/li>\n<li>\n<div><span style=\"color:black\">Flashback Versions Query\ub294 Select\uc2dc versions between\uba85\ub839\uc744 \ub123\uc73c\uba74 \ud574\ub2f9 \uc815\ubcf4\uc758 history \uc815\ubcf4\uac00 \uc544\ub798\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 undo tablespace\ub97c \ud1b5\ud574 row level\ub85c \ub098\ud0c0\ub098\uac8c \ub429\ub2c8\ub2e4.<br \/>\n<\/span><\/div>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"color:black; font-family:HY\ud5e4\ub4dc\ub77c\uc778M; font-size:15pt\"><strong>Flashback Transaction Query<\/strong><br \/>\n\t\t\t\t<\/span><\/p>\n<\/li>\n<li>\n<div><span style=\"color:black\">Flashback Transaction Query\ub294 \uc544\ub798\uc758 \uadf8\ub9bc\uacfc \uac19\uc774 user\uc758 \uc2e4\uc218\ub85c \uc798\ubabb\ub41c DML\uc744 \uc218\ud589\ud558\uc600\uc744 \uacbd\uc6b0, transaction level\ub85c \ubcc0\uacbd \uc774\ub825\uc744 \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uae30\ubc18\uc73c\ub85c undo\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 human error\uc5d0 \ub300\ud55c \ubcf5\uad6c\ub97c \ub354\uc6b1 \uc190\uc27d\uac8c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\n<\/span><\/div>\n<p><span style=\"color:black; font-family:HY\ud5e4\ub4dc\ub77c\uc778M; font-size:15pt\"><strong>Flashback Transaction<\/strong><br \/>\n\t\t\t\t<\/span><\/p>\n<\/li>\n<li>\n<div><span style=\"color:black\">\ub2e8\uc21c\ud55c transaction\uc758 \ub418\ub3cc\ub9ac\uae30\ub97c \ub118\uc5b4, \uc758\uc874\uc131\uc774 \uc788\ub294 transaction\ub4e4\uae4c\uc9c0 \ud568\uaed8 \ub418\ub3cc\ub9b4 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<br \/>\n<\/span><\/div>\n<p>&nbsp;<br \/>\n&nbsp;<\/p>\n<p><span style=\"color:black; font-family:Book Antiqua\">&nbsp;<br \/>\n<\/span>&nbsp;<\/p>\n<\/li>\n<\/ul>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Flashback Database Oracle Database 10g \uc774\uc804\uae4c\uc9c0\ub294 transactional point-in-time recovery\ub97c \uc704\ud574\uc11c\ub294 backup\uc6a9 file\uacfc redo log file\uc744 \uc774\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uc2dc\uac04\uae4c\uc9c0 \ubcf5\uad6c\ub97c \ud574\uc57c\ub9cc \ud588\uc5c8\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774 \ubc29\ubc95\uc740 backup\uc6a9 file\uc774 \uc624\ub798\ub410\uace0, archive log\uac00 \ub9ce\uc774 \uc313\uc5ec \uc788\uc744 \ub54c\ub294 \ub9ce\uc740 \uc2dc\uac04\uc774 \uc18c\uc694\ub420 \uc218 \ubc16\uc5d0 \uc5c6\uc2b5\ub2c8\ub2e4.Oracle 10g\ubd80\ud130\ub294 flashback database\ub97c \uc774\uc6a9\ud558\uc5ec \uc880 \ub354 \ube60\ub978 recovery\uac00 \uac00\ub2a5\ud558\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. Flashback database\uc758 \uc0ac\uc6a9 \uc6a9\ub3c4\ub294 logical [&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":[9],"tags":[631,279,632,619,572],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1122"}],"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=1122"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1122\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1122"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}