{"id":1434,"date":"2015-04-09T16:14:53","date_gmt":"2015-04-09T19:14:53","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=1434"},"modified":"2015-04-09T16:14:53","modified_gmt":"2015-04-09T19:14:53","slug":"erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/","title":{"rendered":"Erro no Oracle Data Guard &#8211; Force closing the keystore for standby rekey."},"content":{"rendered":"<p>Eu tenho configurado uma BD Primary executando Oracle Database 11g com apenas um n\u00f3 de\u00a0<strong>Physical Standby<\/strong>. Esses dias, tentei criar uma coluna criptografada dentro de uma tabela para testar algumas funcionalidades.<\/p>\n<p>Eu acabei, sem querer, estragando as coisas:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Force closing the keystore for standby rekey.\r\nPlease re-copy the keystore from primary before re-open as needed.\r\nApply redo for database master key re-key failed: new master key does not exist in the keystore\r\nMRP0: Background Media Recovery terminated with error 28374\r\nErrors in file \/u02\/diag\/rdbms\/dwqual02\/dwqual02\/trace\/dwqual02_pr00_37644.trc:\r\nORA-28374: typed master key not found in wallet\r\nManaged Standby Recovery not using Real Time Apply\r\nRecovery interrupted!\r\nRecovered data files to a consistent state at change 13453232993830<\/pre>\n<p>O meu BD de standby parou de receber os redo logs por causa da adi\u00e7\u00e3o de uma simples coluna criptograda!<\/p>\n<p>O problema \u00e9 que o meu <strong>Wallet<\/strong> estava configurado apenas no meu BD Primary, n\u00e3o no STBY. Ent\u00e3o, eu prossegui com a cria\u00e7\u00e3o dele no lado do BD STBY.<\/p>\n<p>Primeiramente, verifique o seu arquivo <strong>sqlnet.ora<\/strong> para ver se est\u00e1 sendo utilizado um Wallet apenas para criptografia (o &#8220;encryption wallet&#8221; deve ser compartilhado entre todas as inst\u00e2ncias de seu DG):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">[oracle@blqa09bddsne001 admin]$ cat sqlnet.ora\r\nSQLNET.WALLET_OVERRIDE = TRUE\r\n\r\nWALLET_LOCATION =\r\n  (SOURCE =\r\n    (METHOD = FILE)\r\n    (METHOD_DATA =\r\n      (DIRECTORY = \/u01\/app\/oracle\/wallet\/normal)\r\n    )\r\n  )\r\n\r\nENCRYPTION_WALLET_LOCATION =\r\n  (SOURCE =\r\n    (METHOD = FILE)\r\n    (METHOD_DATA =\r\n      (DIRECTORY = \/u01\/app\/oracle\/wallet\/encrypt)\r\n    )\r\n  )\r\n[oracle@blqa09bddsne001 admin]$\r\n<\/pre>\n<p>Como pode ver, no meu caso eu tenho um Wallet pr\u00f3prio para Criptografias e outro Wallet para outras tarefas (como por exemplo a integra\u00e7\u00e3o de conex\u00e3o EUS-OUD).<\/p>\n<p>Se voc\u00ea tiver apenas um &#8220;WALLET_LOCATION&#8221;, ou ainda, se n\u00e3o tiver qualquer coisa definida, o Oracle ir\u00e1 usar um &#8220;Wallet&#8221; para tudo. Neste caso, v\u00e1 at\u00e9 o caminho padr\u00e3o do Wallet (provavelmente <em>$ORACLE_BASE\/admin\/$ORACLE_SID\/wallet<\/em>).<\/p>\n<p>Voc\u00ea tamb\u00e9m pode verificar onde o waller est\u00e1 rodando a query abaixo na sua primary instance:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; set lines 1000\r\nSQL&gt; format col WRL_PARAMETER a40\r\nSQL&gt; select * from v$encryption_wallet;\r\n\r\nWRL_TYPE             WRL_PARAMETER                            STATUS\r\n-------------------- ---------------------------------------- ------------------\r\nfile                 \/u01\/app\/oracle\/wallet\/encrypt           OPEN\r\n\r\nSQL&gt;<\/pre>\n<p>Tudo que voc\u00ea precisa agora \u00e9 copiar (<strong>scp<\/strong>) o wallet de criptografias (ou o padr\u00e3o se voc\u00ea <span style=\"text-decoration: underline;\"><strong>not<\/strong><\/span> usar o &#8220;ENCRYPTION_WALLET_LOCATION&#8221;) da sua inst\u00e2ncia primary para a standby.<\/p>\n<p>N\u00e3o esquec\u00e7a de coloc\u00e1-lo no diret\u00f3rio padr\u00e3o ou no caminho apontado pelo seu <strong>sqlnet.ora<\/strong>, se existir alguma entrada l\u00e1.<\/p>\n<p>Ap\u00f3s isto, force o Oracle a fehcar o Wallet executando &#8220;<em>ALTER SYSTEM SET ENCRYPTION WALLET CLOSE;<\/em>&#8221; e reinicie o processo de apply. Ou ent\u00e3o, apenas reinicie a sua inst\u00e2ncia standby.<\/p>\n<p>\u00d3timo, o seu Data Guard dever\u00e1 estar agora finalmente aplicando os redo logs novamente!<\/p>\n<b>Gostou? N\u00e3o deixe de comentar ou deixar um \ud83d\udc4d!<\/b>\n<p>&nbsp;<\/p>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-1434 jlk' href='javascript:void(0)' data-task='like' data-post_id='1434' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-1434 lc'>+1<\/span><\/a><\/div><\/div> <div class='status-1434 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Eu tenho configurado uma BD Primary executando Oracle Database 11g com apenas um n\u00f3 de\u00a0Physical Standby. Esses dias, tentei criar uma coluna criptografada dentro de uma tabela para testar algumas funcionalidades. Eu acabei, sem querer, estragando as coisas: Force closing the keystore for standby rekey. Please re-copy the keystore from primary before re-open as needed. &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/\">Continue lendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-1434","post","type-post","status-publish","format-standard","hentry","category-data-guard","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Erro no Oracle Data Guard - Force closing the keystore for standby rekey. - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Como resolver falhas no Data Guard com problemas na wallet key do standby\" \/>\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.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/04\\\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/04\\\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Erro no Oracle Data Guard &#8211; Force closing the keystore for standby rekey.\",\"datePublished\":\"2015-04-09T19:14:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/04\\\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\\\/\"},\"wordCount\":332,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"Data Guard\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/04\\\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/04\\\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/04\\\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\\\/\",\"name\":\"Erro no Oracle Data Guard - Force closing the keystore for standby rekey. - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\"},\"datePublished\":\"2015-04-09T19:14:53+00:00\",\"description\":\"Como resolver falhas no Data Guard com problemas na wallet key do standby\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/04\\\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/04\\\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/04\\\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Erro no Oracle Data Guard - Force closing the keystore for standby rekey.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Erro no Oracle Data Guard - Force closing the keystore for standby rekey. - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Como resolver falhas no Data Guard com problemas na wallet key do standby","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.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/","twitter_misc":{"Escrito por":"DBA RJ","Est. tempo de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Erro no Oracle Data Guard &#8211; Force closing the keystore for standby rekey.","datePublished":"2015-04-09T19:14:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/"},"wordCount":332,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["Data Guard"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/","url":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/","name":"Erro no Oracle Data Guard - Force closing the keystore for standby rekey. - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website"},"datePublished":"2015-04-09T19:14:53+00:00","description":"Como resolver falhas no Data Guard com problemas na wallet key do standby","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/04\/erro-no-oracle-data-guard-force-closing-the-keystore-for-standby-rekey\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/pt-br\/"},{"@type":"ListItem","position":2,"name":"Erro no Oracle Data Guard - Force closing the keystore for standby rekey."}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website","url":"https:\/\/www.dbarj.com.br\/pt-br\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/1434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/comments?post=1434"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/1434\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/media?parent=1434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/categories?post=1434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/tags?post=1434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}