{"id":3163,"date":"2006-12-01T10:10:32","date_gmt":"2006-12-01T10:10:32","guid":{"rendered":"http:\/\/www.istratech.hr\/?p=3163"},"modified":"2021-07-13T07:01:35","modified_gmt":"2021-07-13T07:01:35","slug":"data-replication-in-oracle-database","status":"publish","type":"post","link":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/","title":{"rendered":"Data replication in Oracle database"},"content":{"rendered":"\n

ABSTRACT<\/strong><\/p>\n\n\n\n

This article presents different types of replication mechanism (synchronous and asynchronous) used in Oracle distributed database from version Oracle 7 to Oracle 10g (e.g. Read-only Materialized View, Updateable Materialized View, Multi-master replication, Procedural replication, Oracle Streams). Because Oracle Standard database originally does not have synchronous replication, to resolve this problem, we have developed our own solution and special attention is given to this solution. Implemented in over 100 data base installations across Croatia, the largest one include 35 distributed databases servers interconnected with speed ranging from 64 Kbps to 100 Mbps over mixed optical, wireless, ISDN and plane telephone leased lines.<\/p>\n\n\n

VIEW LECTURE<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

Different types of replication mechanism used in Oracle distributed database from version Oracle 7 to Oracle 10g are explained in the lecture.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_themeisle_gutenberg_block_has_review":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[172,330,327],"tags":[],"class_list":["post-3163","post","type-post","status-publish","format-standard","hentry","category-blog-en","category-conferences","category-hroug-en"],"acf":[],"yoast_head":"\nData replication in Oracle database – Istra Tech<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data replication in Oracle database – Istra Tech\" \/>\n<meta property=\"og:description\" content=\"Different types of replication mechanism used in Oracle distributed database from version Oracle 7 to Oracle 10g are explained in the lecture.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Istra Tech\" \/>\n<meta property=\"article:published_time\" content=\"2006-12-01T10:10:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-13T07:01:35+00:00\" \/>\n<meta name=\"author\" content=\"Istratech Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Istratech Admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/data-replication-in-oracle-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/data-replication-in-oracle-database\\\/\"},\"author\":{\"name\":\"Istratech Admin\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"headline\":\"Data replication in Oracle database\",\"datePublished\":\"2006-12-01T10:10:32+00:00\",\"dateModified\":\"2021-07-13T07:01:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/data-replication-in-oracle-database\\\/\"},\"wordCount\":107,\"commentCount\":0,\"articleSection\":[\"Blog\",\"Conferences\",\"HrOUG\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/data-replication-in-oracle-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/data-replication-in-oracle-database\\\/\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/data-replication-in-oracle-database\\\/\",\"name\":\"Data replication in Oracle database – Istra Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\"},\"datePublished\":\"2006-12-01T10:10:32+00:00\",\"dateModified\":\"2021-07-13T07:01:35+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/data-replication-in-oracle-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/data-replication-in-oracle-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/data-replication-in-oracle-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Po\u010detna stranica\",\"item\":\"https:\\\/\\\/www.istratech.hr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data replication in Oracle database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/\",\"name\":\"Istra Tech\",\"description\":\"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\",\"name\":\"Istratech Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"caption\":\"Istratech Admin\"},\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/author\\\/istratech_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data replication in Oracle database – Istra Tech","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"Data replication in Oracle database – Istra Tech","og_description":"Different types of replication mechanism used in Oracle distributed database from version Oracle 7 to Oracle 10g are explained in the lecture.","og_url":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/","og_site_name":"Istra Tech","article_published_time":"2006-12-01T10:10:32+00:00","article_modified_time":"2021-07-13T07:01:35+00:00","author":"Istratech Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Istratech Admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/#article","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/"},"author":{"name":"Istratech Admin","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"headline":"Data replication in Oracle database","datePublished":"2006-12-01T10:10:32+00:00","dateModified":"2021-07-13T07:01:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/"},"wordCount":107,"commentCount":0,"articleSection":["Blog","Conferences","HrOUG"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/","url":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/","name":"Data replication in Oracle database – Istra Tech","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/#website"},"datePublished":"2006-12-01T10:10:32+00:00","dateModified":"2021-07-13T07:01:35+00:00","author":{"@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"breadcrumb":{"@id":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.istratech.hr\/en\/data-replication-in-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Po\u010detna stranica","item":"https:\/\/www.istratech.hr\/"},{"@type":"ListItem","position":2,"name":"Data replication in Oracle database"}]},{"@type":"WebSite","@id":"https:\/\/www.istratech.hr\/en\/#website","url":"https:\/\/www.istratech.hr\/en\/","name":"Istra Tech","description":"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.istratech.hr\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d","name":"Istratech Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","caption":"Istratech Admin"},"url":"https:\/\/www.istratech.hr\/en\/author\/istratech_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/comments?post=3163"}],"version-history":[{"count":0,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3163\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/media?parent=3163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/categories?post=3163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/tags?post=3163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}