{"id":1477,"date":"2017-11-23T10:04:19","date_gmt":"2017-11-23T13:04:19","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=1477"},"modified":"2018-03-25T16:07:39","modified_gmt":"2018-03-25T19:07:39","slug":"move-controlfile","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/move-controlfile\/","title":{"rendered":"Move Controlfile"},"content":{"rendered":"<p>MOVE Controlfile<\/p>\n<p>Para Mover um Controlfile e bem simples<\/p>\n<p>1- Entre no Rman e fa\u00e7a uma copia do controlfile para um novo diretorio<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; run {\r\nallocate channel C1 device type disk;\r\nrestore controlfile to '+DG3\/mvhm\/controlfile\/ctrl_03_mvhm.ctl' from '+DG1\/mvhm\/controlfile\/ctrl_01_mvhm.ctl';\r\n}\r\n\r\n2&gt; 3&gt; 4&gt;\r\nusing target database control file instead of recovery catalog\r\nallocated channel: C1\r\nchannel C1: sid=3285 devtype=DISK\r\n\r\nStarting restore at 21\/11\/2017\r\n\r\nchannel C1: copied control file copy\r\nFinished restore at 21\/11\/2017\r\nreleased channel: C1<\/pre>\n<p>&nbsp;<\/p>\n<p>2 -apos procedimento Executado Altere no init.ora e Abra o Banco de Dados<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MOVE Controlfile Para Mover um Controlfile e bem simples 1- Entre no Rman e fa\u00e7a uma copia do controlfile para um novo diretorio RMAN&gt; run { allocate channel C1 device type disk; restore controlfile to &#8216;+DG3\/mvhm\/controlfile\/ctrl_03_mvhm.ctl&#8217; from &#8216;+DG1\/mvhm\/controlfile\/ctrl_01_mvhm.ctl&#8217;; } 2&gt; 3&gt; 4&gt; using target database control file instead of recovery catalog allocated channel: C1 channel C1: sid=3285 devtype=DISK Starting restore at 21\/11\/2017 channel C1: copied control file copy Finished restore at 21\/11\/2017 released channel: C1[&#8230;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[21],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1477"}],"collection":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/comments?post=1477"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1477\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=1477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=1477"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=1477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}