{"id":3607,"date":"2018-03-19T09:38:59","date_gmt":"2018-03-19T00:38:59","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3607"},"modified":"2018-03-19T09:38:59","modified_gmt":"2018-03-19T00:38:59","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-db-%ec%9d%98-%eb%b6%84%ec%82%b0-%ed%99%98%ea%b2%bd-%ea%b8%b0%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3607","title":{"rendered":"\uc624\ub77c\ud074 DB \uc758 \ubd84\uc0b0 \ud658\uacbd \uae30\ubc95"},"content":{"rendered":"

\uc624\ub77c\ud074 DB \uc758 \ubd84\uc0b0 \ud658\uacbd \uae30\ubc95
\n<\/span><\/strong><\/span><\/p>\n

 <\/p>\n

1. database link
\n<\/span><\/h3>\n

\uac1c\ub150
\n<\/span><\/h4>\n

\ubd84\uc0b0\ud658\uacbd \uc989 \uc11c\ub85c \ub5a8\uc5b4\uc9c4 \uc624\ub77c\ud074 DB \uc0ac\uc774\uc758 \ud1b5\uc2e0\uc740 Oracle Network\ub2e8\uc758 DB LINK\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <\/span><\/p>\n

Database \uc0ac\uc774\uc758 \ud1b5\uc2e0\uc744 \uc704\ud574\uc11c \uc77c\uc885\uc758 \uc5f0\uacb0 \ub048(\ud558\ub098\uc758 session)\uc744 create database link link_name \u2026\uacfc \uac19\uc740 \uac04\ub2e8\ud55c \ubb38\ubc95\uc758 \ubb38\uc7a5\uc73c\ub85c \ub9cc\ub4e4 \uc218 \uc788\ub294 \uac04\ud3b8\ud55c \ubc29\ubc95\uc774\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

\ub3d9\uae30\ud654 \uae30\ubc95
\n<\/span><\/h4>\n

DB LINK\ub9cc\uc744 \uc774\uc6a9\ud558\uc5ec DATA \ub3d9\uae30\ud654\ub97c \ud560 \uc218 \uc788\uc73c\uba70, program \ub0b4\uc5d0\uc11c
\n<\/span><\/p>\n

 <\/p>\n

insert into emp values (\u2026.); — local DB \uc5d0 \uc800\uc7a5
\n<\/span><\/p>\n

insert into emp@remote_dblink values(\u2026.); — remote DB\uc5d0 \uc800\uc7a5
\n<\/span><\/p>\n

commit;
\n<\/span><\/p>\n

 <\/p>\n

\uc774\ub807\uac8c \uad6c\ud604\ud558\uba74 2PC \ub97c \uc9c0\uc6d0\ud558\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130 \ucc38\uc870 \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud55c\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

\uadf8\ub7ec\ub098 \ubaa8\ub4e0 client \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ubaa8\ub450 local, remote \ub450 \ubc88\uc758 \ud2b8\ub79c\uc7ad\uc158 \ucc98\ub9ac\ub97c \ud574\uc57c\ud55c\ub2e4\ub294 \ubd88\ud3b8\uacfc \ud37c\ud3ec\uba3c\uc2a4 \uc0c1\uc758 \ubb38\uc81c\uc640 local DB\ub294 \uad1c\ucc2e\uc73c\ub098 remote DB\uc5d0 \uc774\uc0c1\uc774 \uc0dd\uae30\uba74 \ubaa8\ub4e0 \ud2b8\ub79c\uc7ad\uc158\uc774 \uc2e4\ud328\ud558\uc5ec ROLLBACK \ub41c\ub2e4\ub294 \ub2e8\uc810\uc774 \uc788\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

2. Materialized View (Read Only Snapshot)<\/span>
\n<\/span><\/h3>\n

 <\/p>\n

\uac1c\ub150
\n<\/span><\/h4>\n

\uc790\uc8fc access\ub418\ub294 Remote DB\uc758 table \ub370\uc774\ud130\ub97c local DB\uc5d0 physical\ud55c \ud615\ud0dc\uc758 \ubcf5\uc81c \ubcf8(\uc77c\ubc18 \ud14c\uc774\ube14)\uc73c\ub85c \uc0dd\uc131\ud558\uc5ec, network failure\ub098 remote db\uc758 failure \uc0c1\ud0dc\uc5d0 \uc0c1\uad00\uc5c6\uc774 local DB\uc5d0\uc11c \ubc14\ub85c ACCESS\ud558\uc5ec \ube60\ub978 \uc131\ub2a5\uacfc \uc548\uc815\uc131\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub294 \uae30\ub2a5\uc774\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

\ub3d9\uae30\ud654 \uae30\ubc95
\n<\/span><\/h4>\n

DB LINK\uc640 inner trigger, package, refresh job\uc744 \ud1b5\ud574\uc11c DATA \ub3d9\uae30\ud654\ub97c \ud558\ub294 \ubc29\ubc95\uc774\ub2e4. program \ub0b4\uc5d0\uc11c\ub294 \ubcf4\ud1b5\uc758 DML \ucc98\ub9ac\uc640 \ub611\uac19\uc774 Local \ud14c\uc774\ube14\uc5d0 \ubcc0\uacbd\ucc98\ub9ac\ud558\uba74 programmer\uc758 \uc5ed\ud560\uc740 \ub05d\uc774\ub2e4 .
\n<\/span><\/p>\n

\uadf8 \uc774\ud6c4 \uc624\ub77c\ud074 replication engine\uc774 \ub0b4\ubd80\uc5d0 \uc788\ub294 inner trigger, package\ub97c \uc774\uc6a9\ud558\uc5ec, \ubcc0\uacbd\ub41c \uc0ac\ud56d\uc744 \ubcc0\uacbd log \ud14c\uc774\ube14\uc5d0 \uc9d1\uc5b4\ub123\uace0, remote db\uac00 refresh job\uc744 \uc8fc\uae30\uc801\uc73c\ub85c \uc218\ud589\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud574 \uac00\uc11c remote\uc758 \ubcf5\uc81c \ubcf8\uc5d0 \ub370\uc774\ud130\ub97c \uc801\uc6a9\ud55c\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

3. Advanced Replication
\n<\/span><\/h3>\n

\uac1c\ub150
\n<\/span><\/h4>\n

Read-only snapshot(materialized view)\uc758 \uae30\ubcf8 \uace8\uaca9\uc5d0\uc11c snapshot\uc758 \ubcc0\uacbd\uc0ac\ud56d\uc744 \uc804\ub2ec\ud558\uae30 \uc704\ud574 snapshot\uc758 \ubcc0\uacbd \ubd84\uc744 \uc800\uc7a5\ud558\ub294 uslog$_snapshot\uacfc push job\uc744 \uc774\uc6a9\ud558\ub294 updateable snapshot(materialized view)\uacfc master table\uacfc master table \uac04\uc758 push \ubc29\uc2dd \ud615\ud0dc\ub85c \ub370\uc774\ud130\ub97c \ub3d9\uae30\ud654 \ud558\ub294 multi master \ubc29\uc2dd \ub450 \uac00\uc9c0\uac00 \uc788\ub2e4.
\n<\/span><\/p>\n

\ub3d9\uae30\ud654 \uae30\ubc95
\n<\/span><\/h4>\n

master table\uc758 \ubcc0\uacbd\uc0c1\ud669\uc740 read-only materialized view\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \ubcc0\uacbd \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud558\uace0, remote db\uac00 refresh job\uc744 \uc218\ud589\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud574 \ub3d9\uae30\ud654 \ud55c\ub2e4. <\/span><\/p>\n

\ubc18\ub300 \ubc29\ud5a5\uc778 materialized view\uc758 \ubcc0\uacbd\uc0ac\ud56d\uc774 \uc0dd\uae38 \uacbd\uc6b0\ub294 mview \uc804\uc6a9 \ubcc0\uacbd\ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud558\uace0, \ub610 push\ud560 \uc218 \uc788\ub3c4\ub85d defcall\uc774\ub780 queue\ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud55c\ub2e4. <\/span><\/p>\n

\uc77c\uc815 \uac04\uaca9 \ud6c4 push job\uc774 defcall\uc5d0 \uc313\uc778 \ub370\uc774\ud130\ub97c master table\uc5d0 \ubc18\uc601\ud55c\ub2e4.
\n<\/span><\/p>\n

\uc774\ub7f0 \ucc98\ub9ac\ub97c \ud1b5\ud558\uc5ec \uc591\ubc29\ud5a5 \ubcf5\uc81c \ucc98\ub9ac\ub97c \uc644\uc131\ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

\ub2e8, \ucc98\ub9ac \ub9e4\ucee4\ub2c8\uc998\uc774 \ub2e4\ub978 \ubc29\uc2dd\ubcf4\ub2e4\ub294 \ubcf5\uc7a1\ud558\uace0, \uc591\ubc29\ud5a5 \ubcc0\uacbd \ucc98\ub9ac \uc2dc \ub370\uc774\ud130\uc758 \ucda9\ub3cc\uc774 \uc788\uc744 \uacbd\uc6b0\uac00 \uc788\uae30 \ub54c\ubb38\uc5d0 conflict resolution routine\ub97c \uc801\uc6a9\ud558\ub294 \ub4f1 \uad00\ub9ac\uc640 setup\uc5d0 \ub354 \uc2e0\uacbd\uc744 \uc368\uc57c \ud558\uba70, replication \uad00\ub9ac\uc790\uc758 \uc219\ub828\ub3c4\uac00 \uc694\uad6c\ub41c\ub2e4.
\n<\/span><\/span><\/p>\n

 <\/p>\n

 <\/p>\n

4. Advanced Replication vs. DataGuard vs. Streams
\n<\/span><\/h3>\n
\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\ud56d\ubaa9<\/span><\/td>\n\n

Advanced replication<\/span><\/p>\n<\/td>\n

\n

DataGuard (Physical)<\/span><\/p>\n<\/td>\n

\n

Streams<\/span><\/p>\n<\/td>\n<\/tr>\n

\uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub808\ubca8\uc758 \ubcf5\uc81c <\/span><\/td>\nYes<\/span><\/td>\nYes (redo log \uc804\uc1a1\ubc29\uc2dd \uc774\ubbc0\ub85c db\uc804\uccb4 \ub808\ubca8\ub9cc \uac00\ub2a5\ud568)<\/span><\/td>\nYes<\/span><\/td>\n<\/tr>\n
Schema \ub808\ubca8 \ubcf5\uc81c<\/span><\/td>\nYes<\/span><\/td>\nNo <\/span><\/td>\nYes<\/span><\/td>\n<\/tr>\n
Table \ub808\ubca8 \ubcf5\uc81c<\/span><\/td>\nYes<\/span><\/td>\nNo<\/span><\/td>\nYes<\/span><\/td>\n<\/tr>\n
DML \ubcf5\uc81c<\/span><\/td>\nYes<\/span><\/td>\nYes<\/span><\/td>\nYes<\/span><\/td>\n<\/tr>\n
DDL \ubcf5\uc81c<\/span><\/td>\nYes (multi-master\ub9cc \uac00\ub2a5)<\/span><\/td>\nYes<\/span><\/td>\nYes<\/span><\/td>\n<\/tr>\n
Failover
\n<\/span><\/p>\n

Mechanism
\n<\/span><\/p>\n<\/td>\n

Manual Failover
\n<\/span><\/td>\n		Failover
\n<\/span><\/p>\n

Switchover
\n<\/span><\/td>\n

Manual Failover
\n<\/span><\/td>\n<\/tr>\n
Change Captured<\/span><\/td>\nLocal<\/span><\/td>\nRemote<\/span><\/td>\nLocal & Remote<\/span><\/td>\n<\/tr>\n
Heterogeneous Database Support (\uc774\uae30\uc885 db\uc9c0\uc6d0)<\/span><\/td>\nYes<\/span><\/td>\nNo<\/span><\/td>\nYes<\/span><\/td>\n<\/tr>\n
Datatype Support<\/span><\/td>\nALL<\/span><\/td>\nSome<\/span><\/td>\nSome<\/span><\/td>\n<\/tr>\n
OS Platform between source and Target<\/span><\/td>\nCan Be Different<\/span><\/td>\nMust Be Same<\/span><\/td>\nCan Be Different<\/span><\/td>\n<\/tr>\n
Oracle Version Between Source and Target<\/span><\/td>\nCan Be Different<\/span><\/td>\nMust Be Same<\/span><\/td>\nCan Be Different<\/span><\/td>\n<\/tr>\n
\uad6c\ud604 reference<\/span><\/td>\n\uc678XX \uc7ac\uc678 \uacf5\uad00<\/span><\/td>\n\ud574XXX\ubd80 (XX\uccad, XX\uccad)<\/span><\/td>\n\ud3ecXX<\/span><\/td>\n<\/tr>\n
\ubc95XX XX\uad6d\uad00\ub9ac\uc18c<\/span><\/td>\nXX\ucc30\uccad<\/span><\/td>\n<\/td>\n<\/tr>\n
\uc721X C3I\/C4I<\/span><\/td>\n\uae08XXX\uc6d0<\/span><\/td>\n<\/td>\n<\/tr>\n
\uc11cX\uc2dc XX\ub3c4\ubcf8\ubd80<\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n


\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc624\ub77c\ud074 DB \uc758 \ubd84\uc0b0 \ud658\uacbd \uae30\ubc95   1. database link \uac1c\ub150 \ubd84\uc0b0\ud658\uacbd \uc989 \uc11c\ub85c \ub5a8\uc5b4\uc9c4 \uc624\ub77c\ud074 DB \uc0ac\uc774\uc758 \ud1b5\uc2e0\uc740 Oracle Network\ub2e8\uc758 DB LINK\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. Database \uc0ac\uc774\uc758 \ud1b5\uc2e0\uc744 \uc704\ud574\uc11c \uc77c\uc885\uc758 \uc5f0\uacb0 \ub048(\ud558\ub098\uc758 session)\uc744 create database link link_name \u2026\uacfc \uac19\uc740 \uac04\ub2e8\ud55c \ubb38\ubc95\uc758 \ubb38\uc7a5\uc73c\ub85c \ub9cc\ub4e4 \uc218 \uc788\ub294 \uac04\ud3b8\ud55c \ubc29\ubc95\uc774\ub2e4.   \ub3d9\uae30\ud654 \uae30\ubc95 DB LINK\ub9cc\uc744 \uc774\uc6a9\ud558\uc5ec DATA \ub3d9\uae30\ud654\ub97c \ud560 […]<\/p>\n","protected":false},"author":1,"featured_media":2876,"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":[541],"tags":[894,71,1026,159],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Cover1.png?fit=1000%2C730","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3607"}],"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=3607"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3607\/revisions"}],"predecessor-version":[{"id":3609,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3607\/revisions\/3609"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2876"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3607"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}