{"id":6570,"date":"2015-12-18T23:24:13","date_gmt":"2015-12-18T22:24:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/"},"modified":"2015-12-18T23:24:13","modified_gmt":"2015-12-18T22:24:13","slug":"ocm-12c-preparation-data-guard-with-oem","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/","title":{"rendered":"OCM 12c preparation: Data Guard with OEM"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nI never create a Data Guard configuration from Enterprise Manager. It’s not that I don’t like GUI, but it is a lot easier to document it when doing from command line: copy paste the commands (actually I write the commands in the documentation and then copy to execute them so that I’m sure about the documentation). But for OCM 12c preparation, I want to be sure I can do it from OEM as it can be faster and prevent to miss a step.<\/p>\n

However, sometimes it fails… Let’s see the Data Guard creation state after a failure on the final steps.
\n
\nOk, the job failed but after the standby creation:<\/p>\n

\"Capture006\"<\/a>
\nfor whatever reason (I don’t understand why you may want to copy external files to standby server. Better put them on a shared filesystem) it failed here.<\/p>\n

However, the job is nearly done and I don’t want to restart it from scratch.<\/p>\n

\"Capture007\"<\/a><\/p>\n

‘Create Standby Database’ includes the duplicate that is the longest step.<\/p>\n

But OEM do not see the standby:<\/p>\n

\"Capture001\"<\/a><\/p>\n

Let’s click on ‘Add Standby Database’ but then cancel:<\/p>\n

\"Capture002\"<\/a><\/p>\n

and here is the Data Guard administration page:<\/p>\n

\"Capture003\"<\/a><\/p>\n

the standby is there, which means that broker configuration is done.
\nBut if I want to do something from there:<\/p>\n

\"Capture004\"<\/a><\/p>\n

I can’t until both datbases are registered:<\/p>\n

\"Capture005\"<\/a><\/p>\n

At that point, I’ll not waste time in Cloud Control because the broker is setup and most of operations can be done with simple commands<\/p>\n

Snapshot standby<\/h3>\n

Let’s convert the physical standby to snapshot standby.<\/p>\n

I check the syntax:<\/p>\n

\nDGMGRL> help convert\n \nConverts a database from one type to another\n \nSyntax:\n \n  CONVERT DATABASE  TO\n     { SNAPSHOT STANDBY | PHYSICAL STANDBY };\n \n<\/code><\/pre>\n
then convert:<\/p>\n
\nDGMGRL> convert database \"CDB112\" to snapshot standby;\nConverting database \"CDB112\" to a Snapshot Standby database, please wait...\nDatabase \"CDB112\" converted successfully\n<\/code><\/pre>\n
And now convert back to physical standby<\/p>\n
\nDGMGRL> convert database \"CDB112\" to physical standby;\nConverting database \"CDB112\" to a Physical Standby database, please wait...\nOperation requires shut down of instance \"CDB112\" on database \"CDB112\"\nShutting down instance \"CDB112\"...\nORA-01017: invalid username\/password; logon denied\n \nWarning: You are no longer connected to ORACLE.\n \nPlease complete the following steps and reissue the CONVERT command:\n        shut down instance \"CDB112\" of database \"CDB112\"\n        start up and mount instance \"CDB112\" of database \"CDB112\"\n<\/code><\/pre>\n
Argh… I connected \/ as sysdba…
\nLet’s do it again:<\/p>\n
\nDGMGRL> connect sys\/oracle\nConnected as SYSDG.\nDGMGRL> convert database \"CDB112\" to physical standby;\nConverting database \"CDB112\" to a Physical Standby database, please wait...\nOperation requires shut down of instance \"CDB112\" on database \"CDB112\"\nShutting down instance \"CDB112\"...\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nOperation requires start up of instance \"CDB112\" on database \"CDB112\"\nStarting instance \"CDB112\"...\nORACLE instance started.\nDatabase mounted.\nContinuing to convert database \"CDB112\" ...\nDatabase \"CDB112\" converted successfully\n<\/code><\/pre>\n
Here it is.<\/p>\n
Now enabling FSFO<\/h3>\n
The configuration created by OEM is in MaxPerformance with ASYNC log shipping, which is not ok for FSFO
\n(‘show database verbose’ if you don’t remember the properties)<\/p>\n
\nDGMGRL> edit database \"CDB112\" set property LogXptMode='SYNC';\nDGMGRL> edit database \"CDB111\" set property LogXptMode='SYNC';\nDGMGRL> edit configuration set protection mode as maxavailability;\n<\/code><\/pre>\n
Second requirement is to be able to flashback datbases to reinstate<\/p>\n
\nCDB111 SQL> alter database flashback on;\nDGMGRL> edit database \"CDB111\" set property FastStartFailoverTarget='CDB112';\nDGMGRL> edit database \"CDB112\" set property FastStartFailoverTarget='CDB111';\nDGMGRL> edit database \"CDB112\" set state='apply-off';\nCDB112 SQL> alter database flashback on;\nDGMGRL> edit database \"CDB112\" set state='apply-on';\n<\/code><\/pre>\n
Then I can enable FSFO (‘help enable’ if you don’t remember the command)<\/p>\n
\nDGMGRL> ENABLE FAST_START FAILOVER\nEnabled.\nDGMGRL> start observer\n<\/code><\/pre>\n
Let’s crash the primary:<\/p>\n
\nDGMGRL> show configuration\n\nConfiguration - CDB111_vm111\n\n  Protection Mode: MaxAvailability\n  Members:\n  CDB111 - Primary database\n    CDB112 - (*) Physical standby database\n\n\nDGMGRL> shutdown abort\nORACLE instance shut down.\n<\/code><\/pre>\n
and here is what I can see at the observer:<\/p>\n
\n23:28:03.00  Friday, December 18, 2015\nInitiating Fast-Start Failover to database \"CDB112\"...\nPerforming failover NOW, please wait...\nFailover succeeded, new primary is \"CDB112\"\n23:28:34.34  Friday, December 18, 2015\n<\/code><\/pre>\n
failover is done.<\/p>\n
And then when restarting the failed server:<\/p>\n
\n23:54:51.34  Friday, December 18, 2015\nInitiating reinstatement for database \"CDB111\"...\nReinstating database \"CDB111\", please wait...\nReinstatement of database \"CDB111\" succeeded\n23:55:18.93  Friday, December 18, 2015\n<\/code><\/pre>\n
This is FSFO: no manual intervention, automatic failover and automatic reinstate.<\/p>\n
Conclusion<\/h3>\n
This is the way I take the Enterprise Manager: I use it as long as it works well (save time when not knowing the syntax, save fingers typing).
\nBut on any issue, let’s go back to the basics or I’ll waste time troubleshooting the GUI in addition to the issue.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . I never create a Data Guard configuration from Enterprise Manager. It’s not that I don’t like GUI, but it is a lot easier to document it when doing from command line: copy paste the commands (actually I write the commands in the documentation and then copy to execute them so that […]<\/p>\n","protected":false},"author":27,"featured_media":6578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[221,714,96],"type_dbi":[],"class_list":["post-6570","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-data-guard","tag-ocm-12c","tag-oracle"],"acf":[],"yoast_head":"\nOCM 12c preparation: Data Guard with OEM - 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\/ocm-12c-preparation-data-guard-with-oem\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OCM 12c preparation: Data Guard with OEM\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . I never create a Data Guard configuration from Enterprise Manager. It’s not that I don’t like GUI, but it is a lot easier to document it when doing from command line: copy paste the commands (actually I write the commands in the documentation and then copy to execute them so that […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-18T22:24:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"531\" \/>\n\t<meta property=\"og:image:height\" content=\"76\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"4 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\/ocm-12c-preparation-data-guard-with-oem\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"OCM 12c preparation: Data Guard with OEM\",\"datePublished\":\"2015-12-18T22:24:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/\"},\"wordCount\":440,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg\",\"keywords\":[\"Data Guard\",\"OCM 12c\",\"Oracle\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/\",\"name\":\"OCM 12c preparation: Data Guard with OEM - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg\",\"datePublished\":\"2015-12-18T22:24:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg\",\"width\":531,\"height\":76},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OCM 12c preparation: Data Guard with OEM\"}]},{\"@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":"OCM 12c preparation: Data Guard with OEM - 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\/ocm-12c-preparation-data-guard-with-oem\/","og_locale":"en_US","og_type":"article","og_title":"OCM 12c preparation: Data Guard with OEM","og_description":"By Franck Pachot . I never create a Data Guard configuration from Enterprise Manager. It’s not that I don’t like GUI, but it is a lot easier to document it when doing from command line: copy paste the commands (actually I write the commands in the documentation and then copy to execute them so that […]","og_url":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/","og_site_name":"dbi Blog","article_published_time":"2015-12-18T22:24:13+00:00","og_image":[{"width":531,"height":76,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"OCM 12c preparation: Data Guard with OEM","datePublished":"2015-12-18T22:24:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/"},"wordCount":440,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg","keywords":["Data Guard","OCM 12c","Oracle"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/","url":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/","name":"OCM 12c preparation: Data Guard with OEM - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg","datePublished":"2015-12-18T22:24:13+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture005-1.jpg","width":531,"height":76},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/ocm-12c-preparation-data-guard-with-oem\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"OCM 12c preparation: Data Guard with OEM"}]},{"@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\/6570","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=6570"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6570\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6578"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6570"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}