{"id":8030,"date":"2016-05-20T20:42:28","date_gmt":"2016-05-20T18:42:28","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/"},"modified":"2016-05-20T20:42:28","modified_gmt":"2016-05-20T18:42:28","slug":"data-guard-as-a-service","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/","title":{"rendered":"Data Guard as a Service"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nA &#8216;Data Guard&#8217; checkbox is available for a long time on the Oracle Public Cloud Database as a Service, but it&#8217;s only for a few days that it does something: create a service with an database in Data Guard.<br \/>\n<!--more--><br \/>\nI&#8217;ve created a database service as usual and the only additional thing I did is to check &#8216;Standby Database with Data Guard&#8217;:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG001.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG001.png\" alt=\"CaptureOPCDG001\" width=\"1146\" height=\"857\" class=\"alignnone size-full wp-image-8766\" \/><\/a><\/p>\n<p>Here are the attributes:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG002.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG002.png\" alt=\"CaptureOPCDG002\" width=\"1133\" height=\"832\" class=\"alignnone size-full wp-image-8765\" \/><\/a><\/p>\n<p>And the creation starts. But in the progress message, you see two VMs:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG003.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG003.png\" alt=\"CaptureOPCDG003\" width=\"1141\" height=\"357\" class=\"alignnone size-full wp-image-8764\" \/><\/a><\/p>\n<p>If you go to the Compute services, only one service is there, the first VM:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG004.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG004.png\" alt=\"CaptureOPCDG004\" width=\"999\" height=\"500\" class=\"alignnone size-full wp-image-8763\" \/><\/a><\/p>\n<p>But back to Database services, when you click on the service, you see the two nodes:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005.png\" alt=\"CaptureOPCDG005\" width=\"1153\" height=\"643\" class=\"alignnone size-full wp-image-8762\" \/><\/a><\/p>\n<p>It&#8217;s a full Data Guard configuration, with the broker automatically configured.<\/p>\n<p>The latency is one millisecond on average which is very good and allows the standby to be in SYNC. Here are some wait events with 4000 small transactions per second (2MB redo per second):<\/p>\n<pre><code>\nWait Event Histogram  DB\/Inst: CDB\/CDB  Snaps: 42-43\n-&gt; Total Waits - units: K is 1000, M is 1000000, G is 1000000000\n-&gt; % of Waits - column heading: &lt;=1s is truly 1s is truly &gt;=1024ms\n-&gt; % of Waits - value: .0 indicates value was  Ordered by Event (idle events last)\n&nbsp;\n                           Total ----------------- % of Waits ------------------\nEvent                      Waits  &lt;1ms  &lt;2ms  &lt;4ms  &lt;8ms &lt;16ms &lt;32ms  1s\n-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----\nLGWR wait for redo copy     100K  99.1    .9    .1    .0    .0\nLNS wait on LGWR            110K 100.0\nRedo Transport MISC         110K  42.2  55.7   1.4    .5    .2    .0    .0\nRedo Writer Remote Sync No  110K 100.0    .0    .0\nSYNC Remote Write           110K  58.9  39.1   1.4    .4    .1    .0    .0\nlog file parallel write     332K  97.7   1.7    .3    .1    .1    .0    .0\nlog file sync              1552K  13.7  46.8  35.8   3.1    .5    .1    .0\n          -------------------------------------------------------------\n<\/code><\/pre>\n<p>Note that if you are not in Extreme Performance edition, you should take care not to open the standby or Active Data Guard usage will be recorded. On service startup, Oracle manages that with the following:<br \/>\n\/etc\/rc.d\/rc.local run \/home\/oracle\/dbsetup.sh which run dbstart (so the standby is open read only)<br \/>\nthen it: shutdown abort and startup mount<br \/>\nthen if it is Extreme Performance it open read only<\/p>\n<p>Finally, if you wonder how the edition is checked, it&#8217;s from the service attributes available from 192.0.0.192:<\/p>\n<pre><code>\n[oracle@opccdb ~]$ links -dump http:\/\/192.0.0.192\/latest\/attributes\/bundle\n   extreme-perf\n<\/code><\/pre>\n<p>As it is a managed database, you can Switchover, Failover and Reinstate from Cloud My Services interface:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG006.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG006.png\" alt=\"CaptureOPCDG006\" width=\"866\" height=\"355\" class=\"alignnone size-full wp-image-8771\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . A &#8216;Data Guard&#8217; checkbox is available for a long time on the Oracle Public Cloud Database as a Service, but it&#8217;s only for a few days that it does something: create a service with an database in Data Guard.<\/p>\n","protected":false},"author":27,"featured_media":8037,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[135,221,96],"type_dbi":[],"class_list":["post-8030","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-cloud","tag-data-guard","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Data Guard as a Service - dbi Blog<\/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.dbi-services.com\/blog\/data-guard-as-a-service\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Guard as a Service\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . A &#8216;Data Guard&#8217; checkbox is available for a long time on the Oracle Public Cloud Database as a Service, but it&#8217;s only for a few days that it does something: create a service with an database in Data Guard.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-20T18:42:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1153\" \/>\n\t<meta property=\"og:image:height\" content=\"643\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Data Guard as a Service\",\"datePublished\":\"2016-05-20T18:42:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/\"},\"wordCount\":271,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png\",\"keywords\":[\"Cloud\",\"Data Guard\",\"Oracle\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/\",\"name\":\"Data Guard as a Service - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png\",\"datePublished\":\"2016-05-20T18:42:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png\",\"width\":1153,\"height\":643},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Guard as a Service\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Guard as a Service - dbi Blog","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.dbi-services.com\/blog\/data-guard-as-a-service\/","og_locale":"en_US","og_type":"article","og_title":"Data Guard as a Service","og_description":"By Franck Pachot . A &#8216;Data Guard&#8217; checkbox is available for a long time on the Oracle Public Cloud Database as a Service, but it&#8217;s only for a few days that it does something: create a service with an database in Data Guard.","og_url":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/","og_site_name":"dbi Blog","article_published_time":"2016-05-20T18:42:28+00:00","og_image":[{"width":1153,"height":643,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Data Guard as a Service","datePublished":"2016-05-20T18:42:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/"},"wordCount":271,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png","keywords":["Cloud","Data Guard","Oracle"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/","url":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/","name":"Data Guard as a Service - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png","datePublished":"2016-05-20T18:42:28+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureOPCDG005-1.png","width":1153,"height":643},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/data-guard-as-a-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Guard as a Service"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8030"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8030\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8037"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8030"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}