{"id":11857,"date":"2018-10-23T06:07:25","date_gmt":"2018-10-23T04:07:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/"},"modified":"2023-06-09T17:09:05","modified_gmt":"2023-06-09T15:09:05","slug":"oracle-openworld-2018-day-1","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/","title":{"rendered":"Oracle OpenWorld 2018: Day 1"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

The first session I assisted today was Oracle Active Data Guard: Best Practices and New Features Deep Dive<\/strong>.
\nThis session was done by Nitin Karkhanis Director of Software Development managing the Data Guard Broker development team and Mahesh Girkar Senior Director of Software Development in Oracle’s Database Division. His team is responsible for developing High Availability features for Data Guard and Active Data Guard..
\nIt was really a very interesting session. It was divided in two parts: The new features for 18c and new features they will implement for Oracle 19c.<\/p>\n

Some Active Data Guard New Features for Oracle 18c<\/h3>\n

>Multi-Instance Redo Apply support now change block tracking
\n>Data Guard and Database Nologging mode
\n>The database buffer cache will be preserved on an Active Data Guard during role change
\n>Creating private temporary table is supported in Active Data Guard
\n>Better protection against failed logins<\/p>\n

Some New Data Guard Broker Commands for Oracle 18c<\/h3>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
dgmgrl > show <\/code>all<\/code>;<\/code><\/div>\n
dgmgrl > <\/code>set<\/code> debug <\/code>ON<\/code> | <\/code>OFF<\/code><\/div>\n
dgmgrl > <\/code>set<\/code> echo <\/code>ON<\/code> | <\/code>OFF<\/code><\/div>\n
dgmgrl > <\/code>set<\/code> time<\/code> ON<\/code> | <\/code>OFF<\/code><\/div>\n
dgmgrl > validate\u00a0 <\/code>database<\/code> boston spfile;<\/code><\/div>\n
dgmgrl > validate\u00a0 network configuration <\/code>for<\/code> boston;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Some New features for Data Guard in 19c<\/h3>\n

>Multi-Instance Redo Apply will work with the In Memory Column Store
\n>Global Temporary Tables can be now created and dropped in an Active Data Guard Standby
\n>Tunable Automatic Outage Resolution. The parameters that control the wait time that determine a hung process will be now documented
\n>DATA_GUARD_MAX_IO_TIME and DATA_GUARD_MAX_LONGIO_TIME. In former versions these parameters were hidden.
\n>In the future is flashback is done at the primary database no action will be needed on standby side. We just have to mount the standby
\nand Oracle will do the rest<\/p>\n

Some Data Guard Broker Feature in 19c<\/h3>\n

TRACE_LEVEL replaces DEBUG<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
dgmgrl > <\/code>set<\/code> TRACE_LEVEL <\/code>USER<\/code>|SUPPORT<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

New Commands to Set Database Parameters<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
dgmgrl>EDIT <\/code>DATABASE<\/code> SET<\/code> PARAMETER parameter_name=value<\/code><\/div>\n
dgmgrl>EDIT <\/code>DATABASE<\/code> RESET PARAMETER parameter_name=value<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

New command to export and import broker configuration file<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
dgmgrl> export configuration <\/code>to<\/code> \u2018meta.xml\u2019<\/code><\/div>\n
dgmgrl> import configuration <\/code>from<\/code> \u2018meta.xml\u2019<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Properties now pass through to Initialization Parameters
\n>DataGuardSyncLatency (DATA_GUARD_SYNC_LATENCY)
\n>StandbyFileManagement (STANDBY_FILE_MANAGEMENT)<\/p>\n

Another session I attended was Best Practices for Maintaining Oracle RAC\/Single Instance Database Environments <\/strong> presented by Bill Burton Consulting Member of Technical Staff Oracle
\nScott Jesse Senior Director,Customer Support, DB Scalability, Security, Networking, SSC Oracle
\nBryan Vongray, Senior Principal Technical Support Engineer, Oracle.
\nIn fact according to their statistics more than 50% of opened SR concern well kown issues. So in this session they present some tools that can help for troubleshooting and monitoring RAC and Single Instance. They present
\nTFA
\nOraCheck and ExaCheck
\nBy many illustrations, the speakers explain how to use the different tools to diagnose our environment.<\/p>\n

The last session I attended was Inside the Head of a Database Hacker<\/strong> by Mark Fallon, Chief Security Architect, Oracle<\/p>\n

The speaker tried in simple words to understand the motivations and the way the hackers act.
\nThis will help to protect any environment. He comes to the conclusion that the security needs to be a collaboration
\n>Database Security
\n>Application Security
\n>Network Security
\n>End-point Security
\n>Process
\n>Employee Education
\n>Physical Security
\n>Supply Chain Security<\/p>\n

So we will come back tomorrow for another briefing of our day<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw The first session I assisted today was Oracle Active Data Guard: Best Practices and New Features Deep Dive. This session was done by Nitin Karkhanis Director of Software Development managing the Data Guard Broker development team and Mahesh Girkar Senior Director of Software Development in Oracle’s Database Division. His team is responsible […]<\/p>\n","protected":false},"author":27,"featured_media":11858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-11857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring"],"acf":[],"yoast_head":"\nOracle OpenWorld 2018: Day 1 - 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\/oracle-openworld-2018-day-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle OpenWorld 2018: Day 1\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw The first session I assisted today was Oracle Active Data Guard: Best Practices and New Features Deep Dive. This session was done by Nitin Karkhanis Director of Software Development managing the Data Guard Broker development team and Mahesh Girkar Senior Director of Software Development in Oracle’s Database Division. His team is responsible […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-23T04:07:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-09T15:09:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.png\" \/>\n\t<meta property=\"og:image:width\" content=\"823\" \/>\n\t<meta property=\"og:image:height\" content=\"332\" \/>\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\/oracle-openworld-2018-day-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle OpenWorld 2018: Day 1\",\"datePublished\":\"2018-10-23T04:07:25+00:00\",\"dateModified\":\"2023-06-09T15:09:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/\"},\"wordCount\":511,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.png\",\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/\",\"name\":\"Oracle OpenWorld 2018: Day 1 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.png\",\"datePublished\":\"2018-10-23T04:07:25+00:00\",\"dateModified\":\"2023-06-09T15:09:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.png\",\"width\":823,\"height\":332},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle OpenWorld 2018: Day 1\"}]},{\"@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":"Oracle OpenWorld 2018: Day 1 - 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\/oracle-openworld-2018-day-1\/","og_locale":"en_US","og_type":"article","og_title":"Oracle OpenWorld 2018: Day 1","og_description":"By Mouhamadou Diaw The first session I assisted today was Oracle Active Data Guard: Best Practices and New Features Deep Dive. This session was done by Nitin Karkhanis Director of Software Development managing the Data Guard Broker development team and Mahesh Girkar Senior Director of Software Development in Oracle’s Database Division. His team is responsible […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/","og_site_name":"dbi Blog","article_published_time":"2018-10-23T04:07:25+00:00","article_modified_time":"2023-06-09T15:09:05+00:00","og_image":[{"width":823,"height":332,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.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\/oracle-openworld-2018-day-1\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle OpenWorld 2018: Day 1","datePublished":"2018-10-23T04:07:25+00:00","dateModified":"2023-06-09T15:09:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/"},"wordCount":511,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.png","articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/","name":"Oracle OpenWorld 2018: Day 1 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.png","datePublished":"2018-10-23T04:07:25+00:00","dateModified":"2023-06-09T15:09:05+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Captureday02rac.png","width":823,"height":332},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-openworld-2018-day-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle OpenWorld 2018: Day 1"}]},{"@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\/11857","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=11857"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11857\/revisions"}],"predecessor-version":[{"id":25788,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11857\/revisions\/25788"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11858"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11857"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}