{"id":2401,"date":"2018-01-26T19:17:11","date_gmt":"2018-01-26T10:17:11","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2401"},"modified":"2018-01-27T20:15:08","modified_gmt":"2018-01-27T11:15:08","slug":"db-admin-flashback-database-%ea%b8%b0%eb%8a%a5%ec%9d%84-%ec%9d%b4%ec%9a%a9%ed%95%9c-rewind-%eb%b3%b5%ea%b5%ac-%ec%98%a4%eb%9d%bc%ed%81%b4-%ed%83%80%ec%9e%84-%eb%a8%b8%ec%8b%a0-%eb%b3%b5%ea%b5%ac","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2401","title":{"rendered":"[DB Admin] \uc624\ub77c\ud074 DB \ud0c0\uc784 \uba38\uc2e0 \uae30\ub2a5 \ubcf5\uad6c"},"content":{"rendered":"

\n

Flashback Database \uae30\ub2a5\uc744 \uc774\uc6a9\ud55c Rewind \ubcf5\uad6c (=\uc624\ub77c\ud074 \ud0c0\uc784 \uba38\uc2e0 \ubcf5\uad6c)<\/strong><\/p>\n

\n

Oracle Flashback Database<\/span><\/span>\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uacfc\uac70 \uc2dc\uac04\uc73c\ub85c \ub418\uac10\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span>\ubbf8\ub514\uc5b4 \ubcf5\uad6c \uc640 \ub2ec\ub9ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uacfc\uac70 \uc0c1\ud0dc\ub85c \ub418\ub3cc\ub9ac\ub824\uba74 \ub370\uc774\ud130 \ud30c\uc77c\uc744 \ubcf5\uc6d0 \ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

\uc9c0\uae08\ubd80\ud130 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uac04\uc744 \ub3cc\ub824 \uc7a5\uc560\ub97c \ubcf5\uad6c\ud558\uaca0\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

\uba3c\uc800 FLASHBACK\u00a0<\/span>\uae30\ub2a5\uc744 \ud65c\uc131\ud654 \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

SQL> SHUTDOWN IMMEDIATE ;<\/span><\/span><\/p>\n

SQL> STARTUP MOUNT ;<\/span><\/span><\/p>\n

SQL> ALTER DATABASE FLASHBACK ON ;<\/span><\/span><\/p>\n

SQL> SHUTDOWN IMMEDIATE ;<\/span><\/span><\/p>\n

SQL> STARTUP ;<\/span><\/span><\/p>\n

SQL> SELECT NAME , FLASHBACK_ON FROM V$DATABASE ;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image002\"<\/a><\/span><\/p>\n

\"clip_image004\"<\/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 \uc77c\ubc18 \uc720\uc800 \uc138\uc158\uc5d0\uc11c \uc7a5\uc560 \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14\uacfc \ud604\uc7ac SCN <\/span>\uac12\uc744 \ud655\uc778 \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

SQL> SELECT COUNT(*) FROM EMP ;<\/span><\/span><\/p>\n

SQL> SELECT CURRENT_SCN FROM V$DATABASE;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image005\"<\/a><\/span><\/p>\n

\"clip_image007\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

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

\uc774\uc81c \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130 \uc720\uc2e4 \uc7a5\uc560\ub97c \ubc1c\uc0dd \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

SQL> DELETE FROM EMP ;<\/span><\/span><\/p>\n

SQL> COMMIT ;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image009\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

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

\ub2e4\uc2dc \ub3cc\uc544\uc624\uae30 \uc704\ud558\uc5ec \ud604\uc7ac\uc758\u00a0SCN <\/span>\uac12\uc744 \uc870\ud68c \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

SQL> SELECT CURRENT_SCN FROM V$DATABASE ;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image011\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

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

\uc774\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc2dc\uac04\uc744 \uacfc\uac70\ub85c \ub3cc\ub9bd\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

SQL> SHUTDOWN IMMEDIATE ;<\/span><\/span><\/p>\n

SQL> STARTUP MOUNT ;<\/span><\/span><\/p>\n

RMAN> FLASHBACK DATABASE TO SCN <<\/span><\/span>\uacfc\uac70 SCN <\/span>\ubc88\ud638<\/span>> ;<\/span><\/span><\/span><\/p>\n

SQL> ALTER DATABASE OPEN READ ONLY ;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image013\"<\/a><\/span><\/p>\n

\"clip_image015\"<\/a><\/span><\/p>\n

\"clip_image017\"<\/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 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud55c \ud14c\uc774\ube14\uc744 \uc870\ud68c \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

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

\n

\"clip_image019\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

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

\uc774\uc81c \ud14c\uc774\ube14\uc744 \uc870\ud68c \ud55c \ud14c\uc774\ube14\uc744 \ubc31\uc5c5 \ubc1b\uc544 \ub193\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

# exp USERID=YONGSEOK\/PARK TABLES=EMP FILE=EMP.DMP<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image021\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

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

\uc774\uc81c \ub2e4\uc2dc \uc6d0\ub798\uc758\u00a0DB <\/span>\uc2dc\uac04\uc73c\ub85c \ub3cc\uc544 \uac11\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

SQL> SHUTDOWN IMMEDIATE ;<\/span><\/span><\/p>\n

SQL> STARTUP MOUNT ;<\/span><\/span><\/p>\n

RMAN> FLASHBACK DATABASE TO SCN <<\/span><\/span>\ud604\uc7ac SCN <\/span>\ubc88\ud638<\/span>> ;<\/span><\/span><\/span><\/p>\n

SQL> ALTER DATABASE OPEN RESETLOGS ;<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image023\"<\/a><\/span><\/p>\n

\"clip_image025\"<\/a><\/span><\/p>\n

\"clip_image027\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

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

RESETLOGS <\/span><\/span>\ub85c \uc624\ud508\ud558\uba74 \ud604\uc7ac\ub85c \ub2e4\uc2dc \ub3cc\uc544 \uc624\uac8c \ub429\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

\uc774\uc81c \ub370\uc774\ud130 \uc720\uc2e4\uc774 \ub418\uc5b4 \uc7a5\uc560 \ub09c \ud14c\uc774\ube14\uc744 \ub2e4\uc2dc \uc870\ud68c \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

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

\n

\"clip_image029\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

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

\uacfc\uac70\uc5d0 \ub3cc\uc544\uac00\uc11c \ubc31\uc5c5 \ubc1b\uc740 \ub370\uc774\ud130\ub97c \ubcf5\uad6c \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

# imp USERID=YONGSEOK\/PARK TABLES=EMP FILE=EMP.DMP IGNORE=Y<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\"clip_image031\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

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

\ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc7a5\uc560 \ub09c \ud14c\uc774\ube14\uc744 \uc870\ud68c\ud558\uc5ec \ubcf5\uad6c\uac00 \uc644\ub8cc \ub418\uc5c8\ub294\uc9c0 \ud655\uc778 \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/span><\/p>\n

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

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

\n

\"clip_image033\"<\/a><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Flashback Database \uae30\ub2a5\uc744 \uc774\uc6a9\ud55c Rewind \ubcf5\uad6c (=\uc624\ub77c\ud074 \ud0c0\uc784 \uba38\uc2e0 \ubcf5\uad6c) Oracle Flashback Database\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uacfc\uac70 \uc2dc\uac04\uc73c\ub85c \ub418\uac10\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubbf8\ub514\uc5b4 \ubcf5\uad6c \uc640 \ub2ec\ub9ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uacfc\uac70 \uc0c1\ud0dc\ub85c \ub418\ub3cc\ub9ac\ub824\uba74 \ub370\uc774\ud130 \ud30c\uc77c\uc744 \ubcf5\uc6d0 \ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uc9c0\uae08\ubd80\ud130 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uac04\uc744 \ub3cc\ub824 \uc7a5\uc560\ub97c \ubcf5\uad6c\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uba3c\uc800 FLASHBACK\u00a0\uae30\ub2a5\uc744 \ud65c\uc131\ud654 \ud569\ub2c8\ub2e4. SQL> SHUTDOWN IMMEDIATE ; SQL> STARTUP MOUNT ; SQL> ALTER […]<\/p>\n","protected":false},"author":1,"featured_media":2429,"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":[829,280,828],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/chine.png?fit=886%2C650","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2401"}],"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=2401"}],"version-history":[{"count":5,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2401\/revisions"}],"predecessor-version":[{"id":2431,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2401\/revisions\/2431"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2429"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2401"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}