{"id":10336,"date":"2017-08-01T18:34:18","date_gmt":"2017-08-01T16:34:18","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/"},"modified":"2024-10-10T11:54:29","modified_gmt":"2024-10-10T09:54:29","slug":"display-data-guard-configuration-in-sql-developer","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/","title":{"rendered":"Display Data Guard configuration in SQL Developer"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nThe latest version of SQL Developer, the 17.2 one released after Q2 of 2017, has a new item in the DBA view showing the Data Guard configuration. This is the occasion to show how you can cascade the log shipping in Oracle 12<em>c<\/em><br \/>\n<!--more--><br \/>\nA quick note about this new versioning: this is the release for 2017 Q2 and the version number has more digits to mention the exact build time. Here this version is labeled 17.2.0.188.1159 and we can see when it has been built:<\/p>\n<pre><code>\nSQL&gt;  select to_date('17.x.0.188.1159','rr.\"x.0\".ddd.hh24mi') build_time from dual;\n\u00a0\nBUILD_TIME          \n--------------------\n07-JUL-2017 11:59:00\n<\/code><\/pre>\n<h3>Non-Cascading Standby<\/h3>\n<p>Here is my configuration with two standby databases:<\/p>\n<pre><code>\nDGMGRL&gt; show configuration\nConfiguration - orcl\n\u00a0\n  Protection Mode: MaxPerformance\n  Members:\n  orcla - Primary database\n    orclb - Physical standby database\n    orclc - Physical standby database\n\u00a0\nFast-Start Failover: DISABLED\n\u00a0\nConfiguration Status:\nSUCCESS   (status updated 9 seconds ago)\n<\/code><\/pre>\n<p>I have only the LogXptMode defined here, without any RedoRoutes<\/p>\n<pre><code>\nDGMGRL&gt; show database orcla LogXptMode \n  LogXptMode = 'SYNC'\n<\/code><\/pre>\n<p>with this configuration, the broker has set the following log destination on orcla, orclb and orclc:<\/p>\n<pre><code>\nINSTANCE_NAME    NAME                 VALUE\n---------------- -------------------- -------------------------------------------------------------------------------------------------------------\nORCLA            log_archive_dest_1   location=USE_DB_RECOVERY_FILE_DEST, valid_for=(ALL_LOGFILES, ALL_ROLES)\nORCLA            log_archive_dest_2   service=\"ORCLB\", SYNC AFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300\n                                      db_unique_name=\"orclb\" net_timeout=30, valid_for=(online_logfile,all_roles)\nORCLA            log_archive_dest_3   service=\"ORCLC\", SYNC AFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300\n                                      db_unique_name=\"orclc\" net_timeout=30, valid_for=(online_logfile,all_roles)\n\u00a0\nINSTANCE_NAME    NAME                 VALUE\n---------------- -------------------- -------------------------------------------------------------------------------------------------------------\nORCLB            log_archive_dest_1   location=\/u01\/fast_recovery_area\n\u00a0\nINSTANCE_NAME    NAME                 VALUE\n---------------- -------------------- -------------------------------------------------------------------------------------------------------------\nORCLC            log_archive_dest_1   location=\/u01\/fast_recovery_area\n<\/code><\/pre>\n<p>In the latest SQL Developer you have the graphical representation of it from the DBA view \/ Dataguard \/ console:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG001.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-17524\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG001.png\" alt=\"SDDG001\" width=\"1024\" height=\"102\" \/><\/a><\/p>\n<h3>Cascading Standby<\/h3>\n<p>In 12<i>c<\/i> we can define cascading standby: instead of the primary shipping the redo to all standby databases, you can have the primary shipping to one standby only, and this one can forward the redo to another one. You define that with the RedoRoute property:<\/p>\n<pre><code>\nDGMGRL&gt; edit database orcla set property redoroutes = '(local:orclb)         (orclb:orclc async)';\nProperty \"redoroutes\" updated\nDGMGRL&gt; edit database orclb set property redoroutes = '(orcla:orclc async)   (local:orcla)';\nProperty \"redoroutes\" updated\n<\/code><\/pre>\n<p>The first route defined in each property is applied when orcla is the primary database:<\/p>\n<ul>\n<li>on orcla (local:orclb) means that orcla sends redo to orclb when primary<\/li>\n<li>on orclb (orcla:orclc async) means that orclb sends redo to orclc when orcla is primary. LogXptMode is SYNC but overriden here with ASYNC<\/li>\n<\/ul>\n<p>The second route defined in each property is applied when orclb is the primary database:<\/p>\n<ul>\n<li>on orcla (orclb:orclc async) means that orcla sends redo to orclc when orclb is primary. LogXptMode is SYNC but overriden here with ASYNC<\/li>\n<li>on orclb (local:orcla) means that orclb sends redo to orcla when primary<\/li>\n<\/ul>\n<p>With this configuration, and orcla still being the primary, the broker has set the following log destination on orcla, orclb and orclc:<\/p>\n<pre><code>\nINSTANCE_NAME    NAME                 VALUE\n---------------- -------------------- -------------------------------------------------------------------------------------------------------------\nORCLA            log_archive_dest_1   location=USE_DB_RECOVERY_FILE_DEST, valid_for=(ALL_LOGFILES, ALL_ROLES)\nORCLA            log_archive_dest_2   service=\"ORCLB\", SYNC AFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300\n                                      db_unique_name=\"orclb\" net_timeout=30, valid_for=(online_logfile,all_roles)\n\u00a0\nINSTANCE_NAME    NAME                 VALUE\n---------------- -------------------- -------------------------------------------------------------------------------------------------------------\nORCLB            log_archive_dest_1   location=\/u01\/fast_recovery_area\nORCLB            log_archive_dest_2   service=\"ORCLC\", ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=3\n                                      00 db_unique_name=\"orclc\" net_timeout=30, valid_for=(standby_logfile,all_roles)\n\u00a0\nINSTANCE_NAME    NAME                 VALUE\n---------------- -------------------- -------------------------------------------------------------------------------------------------------------\nORCLC            log_archive_dest_1   location=\/u01\/fast_recovery_area\n<\/code><\/pre>\n<p>The show configuration from DGMGRL displays them indented to see the cascading redo shipping:<\/p>\n<pre><code>\nDGMGRL&gt; show configuration\nConfiguration - orcl\n\u00a0\n  Protection Mode: MaxPerformance\n  Members:\n  orcla - Primary database\n    orclb - Physical standby database\n      orclc - Physical standby database (receiving current redo)\n\u00a0\nFast-Start Failover: DISABLED\n\u00a0\nConfiguration Status:\nSUCCESS   (status updated 27 seconds ago)\n<\/code><\/pre>\n<p>And SQL Developer Data Guard console shows:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG0021.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-17573\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG0021.png\" alt=\"SDDG002\" width=\"1024\" height=\"65\" \/><\/a><\/p>\n<h3>Switchover<\/h3>\n<p>Now the goal of defining several routes is to have all log destination automatically changed when the database role change.<br \/>\nI&#8217;m doing a switchover:<\/p>\n<pre><code>\nConnected to \"orclb\"\nConnected as SYSDG.\nDGMGRL&gt; switchover to orclb;\nPerforming switchover NOW, please wait...\nNew primary database \"orclb\" is opening...\nOperation requires start up of instance \"ORCLA\" on database \"orcla\"\nStarting instance \"ORCLA\"...\nORACLE instance started.\nDatabase mounted.\nDatabase opened.\nConnected to \"orcla\"\nSwitchover succeeded, new primary is \"orclb\"\n<\/code><\/pre>\n<p>Now it is orcla which cascades the orclb redo to orclc:<\/p>\n<pre><code>\nDGMGRL&gt; show configuration;\nConfiguration - orcl\n\u00a0\n  Protection Mode: MaxPerformance\n  Members:\n  orclb - Primary database\n    orcla - Physical standby database\n      orclc - Physical standby database (receiving current redo)\n\u00a0\nFast-Start Failover: DISABLED\n\u00a0\nConfiguration Status:\nSUCCESS   (status updated 74 seconds ago)\n<\/code><\/pre>\n<p>Here is how it is displayed from SQL Developer:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG0031.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-17574\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG0031.png\" alt=\"SDDG003\" width=\"1024\" height=\"63\" \/><\/a><\/p>\n<p>We have seen how the configuration is displayed from DGMGRL and graphically from SQL Developer. Of course, you can also query the Data Guard configuration:<\/p>\n<pre><code>\nSQL&gt; select * from V$DATAGUARD_CONFIG;\n\u00a0\nDB_UNIQUE_NAME  PARENT_DBUN  DEST_ROLE         CURRENT_SCN  CON_ID\n--------------  -----------  ---------         -----------  ------\norcla           orclb        PHYSICAL STANDBY  3407900      0\norclc           orcla        PHYSICAL STANDBY  3408303      0\norclb           NONE         PRIMARY DATABASE  0            0\n<\/code><\/pre>\n<p>and the broker configuration:<\/p>\n<pre><code>\nSQL&gt;  select * from V$DG_BROKER_CONFIG;\n\u00a0\nDATABASE  CONNECT_IDENTIFIER  DATAGUARD_ROLE    REDO_SOURCE  ENABLED  STATUS  VERSION  CON_ID\n--------  ------------------  --------------    -----------  -------  ------  -------  ------\norcla     ORCLA               PHYSICAL STANDBY  -UNKNOWN-    TRUE     0       11.0     0\norclb     ORCLB               PRIMARY           -N\/A-        TRUE     0       11.0     0\norclc     ORCLC               PHYSICAL STANDBY  orcla        TRUE     0       11.0     0\n<\/code><\/pre>\n<p>This another reason to use the broker. Once the configuration is setup and tested, you have nothing else to think about when you do a switchover. The log archive destination is automatically updated depending on the database roles.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . The latest version of SQL Developer, the 17.2 one released after Q2 of 2017, has a new item in the DBA view showing the Data Guard configuration. This is the occasion to show how you can cascade the log shipping in Oracle 12c<\/p>\n","protected":false},"author":27,"featured_media":10337,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[221,96,209,1134],"type_dbi":[],"class_list":["post-10336","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-data-guard","tag-oracle","tag-oracle-12c","tag-sql-developer"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Display Data Guard configuration in SQL Developer - 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\/display-data-guard-configuration-in-sql-developer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Display Data Guard configuration in SQL Developer\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . The latest version of SQL Developer, the 17.2 one released after Q2 of 2017, has a new item in the DBA view showing the Data Guard configuration. This is the occasion to show how you can cascade the log shipping in Oracle 12c\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-01T16:34:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-10T09:54:29+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG001.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1436\" \/>\n\t<meta property=\"og:image:height\" content=\"143\" \/>\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=\"3 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\\\/display-data-guard-configuration-in-sql-developer\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Display Data Guard configuration in SQL Developer\",\"datePublished\":\"2017-08-01T16:34:18+00:00\",\"dateModified\":\"2024-10-10T09:54:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/\"},\"wordCount\":452,\"commentCount\":2,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SDDG001.png\",\"keywords\":[\"Data Guard\",\"Oracle\",\"Oracle 12c\",\"SQL Developer\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/\",\"name\":\"Display Data Guard configuration in SQL Developer - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SDDG001.png\",\"datePublished\":\"2017-08-01T16:34:18+00:00\",\"dateModified\":\"2024-10-10T09:54:29+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SDDG001.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/SDDG001.png\",\"width\":1436,\"height\":143},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/display-data-guard-configuration-in-sql-developer\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Display Data Guard configuration in SQL Developer\"}]},{\"@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":"Display Data Guard configuration in SQL Developer - 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\/display-data-guard-configuration-in-sql-developer\/","og_locale":"en_US","og_type":"article","og_title":"Display Data Guard configuration in SQL Developer","og_description":"By Franck Pachot . The latest version of SQL Developer, the 17.2 one released after Q2 of 2017, has a new item in the DBA view showing the Data Guard configuration. This is the occasion to show how you can cascade the log shipping in Oracle 12c","og_url":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/","og_site_name":"dbi Blog","article_published_time":"2017-08-01T16:34:18+00:00","article_modified_time":"2024-10-10T09:54:29+00:00","og_image":[{"width":1436,"height":143,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG001.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Display Data Guard configuration in SQL Developer","datePublished":"2017-08-01T16:34:18+00:00","dateModified":"2024-10-10T09:54:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/"},"wordCount":452,"commentCount":2,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG001.png","keywords":["Data Guard","Oracle","Oracle 12c","SQL Developer"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/","url":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/","name":"Display Data Guard configuration in SQL Developer - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG001.png","datePublished":"2017-08-01T16:34:18+00:00","dateModified":"2024-10-10T09:54:29+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG001.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/SDDG001.png","width":1436,"height":143},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/display-data-guard-configuration-in-sql-developer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Display Data Guard configuration in SQL Developer"}]},{"@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\/10336","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=10336"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10336\/revisions"}],"predecessor-version":[{"id":35162,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10336\/revisions\/35162"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10337"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10336"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}