{"id":5203,"date":"2015-08-23T14:26:34","date_gmt":"2015-08-23T12:26:34","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/"},"modified":"2015-08-23T14:26:34","modified_gmt":"2015-08-23T12:26:34","slug":"dataguard-broker-properties-part-ii-log-shipping-parameters","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/","title":{"rendered":"DataGuard broker properties \u2013 Part II: log shipping parameters"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nIn the part I<\/a> we have seen the properties that are imported when you add a database to the configuration, and which are then managed by the broker. Now we will list the properties that are managed by the broker, but whose default value is not imported from the instance parameters.
\n<\/p>\n

LogXpt properties<\/h1>\n

Here are the properties from primary database where I removed those we have seen in previous Part I:<\/p>\n

\nDGMGRL> show database verbose demo11;\n...\n  Properties:\n...\n    DGConnectIdentifier             = '\/\/vm112\/DEMO12'\n    LogXptMode                      = 'ASYNC'\n    RedoRoutes                      = ''\n    DelayMins                       = '0'\n    Binding                         = 'optional'\n    MaxFailure                      = '0'\n    ReopenSecs                      = '300'\n    NetTimeout                      = '30'\n    RedoCompression                 = 'DISABLE'\n    LogShipping                     = 'ON'\n    InconsistentLogXptProps         = '(monitor)'\n    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'\n    AlternateLocation               = ''\n...\n<\/code><\/pre>\n
They are related with log shipping destination. When I enabled the configuration, the LOG_ARCHIVE_DEST have been set with those values:<\/p>\n
\nSQL> show parameter log_archive_dest_1\n \nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_1                   string      location=USE_DB_RECOVERY_FILE_\n                                                 DEST, valid_for=(ALL_LOGFILES,\n                                                  ALL_ROLES)\nlog_archive_dest_2                   string      service=\"\/\/vm112\/DEMO12\", ASYN\n                                                 C NOAFFIRM delay=0 optional co\n                                                 mpression=disable max_failure=\n                                                 0 max_connections=1 reopen=300\n                                                  db_unique_name=\"demo12\" net_t\n                                                 imeout=30, valid_for=(online_l\n                                                 ogfile,all_roles)\nlog_archive_dest_state_1             string      enable\nlog_archive_dest_state_2             string      enable\n<\/code><\/pre>\n
Now, I manage them from the Data Guard broker:<\/p>\n
\nDGMGRL> edit database demo12 set property LogXptMode='SYNC';\nProperty \"logxptmode\" updated\n<\/code><\/pre>\n
which has run the following ALTER SYSTEM:<\/p>\n
\nALTER SYSTEM SET log_archive_dest_2='service=\"\/\/vm112\/DEMO12\"','SYNC AFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=\"demo12\" net_timeout=30','valid_for=(online_logfile,all_roles)' SCOPE=BOTH;\n<\/code><\/pre>\n
When we go to SYNC, the destination is set to SYNC (wait for log shipping) and AFFIRM (wait for log write)<\/p>\n
Properties – LOG_ARCHIVE_DEST attributes<\/h1>\n
Here is the correspondence. The properties change the LOG_ARCHIVE_DEST attributes to set log shipping.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Broker property<\/th>\nLOG_ARCHIVE_DEST<\/th>\n<\/tr>\n<\/thead>\n
RedoRoutes<\/td>\nLOG_ARCHIVE_DEST_n<\/td>\n<\/tr>\n
DGConnectIdentifier<\/td>\nservice=<\/td>\n<\/tr>\n
LogXptMode<\/td>\nSYNC\/ASYNC,AFFIRM\/NOAFFIRM<\/td>\n<\/tr>\n
DelayMins<\/td>\ndelay=<\/td>\n<\/tr>\n
Binding<\/td>\nMANDATORY\/OPTIONAL<\/td>\n<\/tr>\n
MaxFailure<\/td>\nmax_failure=<\/td>\n<\/tr>\n
ReopenSecs<\/td>\nreopen=<\/td>\n<\/tr>\n
NetTimeout<\/td>\nnet_timeout=<\/td>\n<\/tr>\n
RedoCompression<\/td>\ncompression=<\/td>\n<\/tr>\n
LogShipping<\/td>\nLOG_ARCHIVE_DEST_STATE_n<\/td>\n<\/tr>\n
StandbyArchiveLocation<\/td>\nlocation=<\/td>\n<\/tr>\n
AlternateLocation<\/td>\nlocation=<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Not imported<\/h1>\n
I’ll show that those parameters are not<\/strong> imported when we create a configuration. Here I remove and re-create the configuration and I still have the LOG_ARCHIVE_DEST as SYNC.<\/p>\n
\nDGMGRL> REMOVE CONFIGURATION;\nRemoved configuration\nDGMGRL> CREATE CONFIGURATION demo11 AS PRIMARY DATABASE IS demo11 CONNECT IDENTIFIER IS '\/\/vm111\/DEMO11';\nConfiguration \"demo11\" created with primary database \"demo11\"\nDGMGRL> ADD DATABASE demo12 AS CONNECT IDENTIFIER IS '\/\/vm112\/DEMO12';\nDatabase \"demo12\" added\nDGMGRL> ENABLE CONFIGURATION demo11;\nEnabled.\n<\/code><\/pre>\n
But:<\/p>\n
\nSQL> show parameter log_archive_dest_2\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_2                   string      service=\"\/\/vm112\/DEMO12\", ASYN\n                                                 C NOAFFIRM delay=0 optional co\n                                                 mpression=disable max_failure=\n                                                 0 max_connections=1 reopen=300\n                                                  db_unique_name=\"demo12\" net_t\n                                                 imeout=30, valid_for=(online_l\n                                                 ogfile,all_roles)\n<\/code><\/pre>\n
The log shipping attributes have been set to the broker properties defaults. This is the main difference from the properties we have seen in Part I.
\nNever change the LOG_ARCHIVE_DEST with ALTER SYSTEM. they are managed by the broker. And don’t forget to set those properties if you re-create the broker configuration.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . In the part I we have seen the properties that are imported when you add a database to the configuration, and which are then managed by the broker. Now we will list the properties that are managed by the broker, but whose default value is not imported from the instance parameters.<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[221,96],"type_dbi":[],"class_list":["post-5203","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-data-guard","tag-oracle"],"acf":[],"yoast_head":"\nDataGuard broker properties \u2013 Part II: log shipping parameters - dbi Blog<\/title>\n<meta name=\"description\" content=\"The Data Guard broker log shipping properties that are not imported when you create the configuration\" \/>\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\/dataguard-broker-properties-part-ii-log-shipping-parameters\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DataGuard broker properties \u2013 Part II: log shipping parameters\" \/>\n<meta property=\"og:description\" content=\"The Data Guard broker log shipping properties that are not imported when you create the configuration\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-23T12:26:34+00:00\" \/>\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\/dataguard-broker-properties-part-ii-log-shipping-parameters\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"DataGuard broker properties \u2013 Part II: log shipping parameters\",\"datePublished\":\"2015-08-23T12:26:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/\"},\"wordCount\":294,\"commentCount\":0,\"keywords\":[\"Data Guard\",\"Oracle\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/\",\"name\":\"DataGuard broker properties \u2013 Part II: log shipping parameters - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2015-08-23T12:26:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"The Data Guard broker log shipping properties that are not imported when you create the configuration\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DataGuard broker properties \u2013 Part II: log shipping parameters\"}]},{\"@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":"DataGuard broker properties \u2013 Part II: log shipping parameters - dbi Blog","description":"The Data Guard broker log shipping properties that are not imported when you create the configuration","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\/dataguard-broker-properties-part-ii-log-shipping-parameters\/","og_locale":"en_US","og_type":"article","og_title":"DataGuard broker properties \u2013 Part II: log shipping parameters","og_description":"The Data Guard broker log shipping properties that are not imported when you create the configuration","og_url":"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/","og_site_name":"dbi Blog","article_published_time":"2015-08-23T12:26:34+00:00","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\/dataguard-broker-properties-part-ii-log-shipping-parameters\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"DataGuard broker properties \u2013 Part II: log shipping parameters","datePublished":"2015-08-23T12:26:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/"},"wordCount":294,"commentCount":0,"keywords":["Data Guard","Oracle"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/","url":"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/","name":"DataGuard broker properties \u2013 Part II: log shipping parameters - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-08-23T12:26:34+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"The Data Guard broker log shipping properties that are not imported when you create the configuration","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dataguard-broker-properties-part-ii-log-shipping-parameters\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DataGuard broker properties \u2013 Part II: log shipping parameters"}]},{"@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\/5203","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=5203"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5203\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5203"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}