{"id":1473,"date":"2017-11-23T10:01:02","date_gmt":"2017-11-23T13:01:02","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=1473"},"modified":"2018-02-01T16:50:48","modified_gmt":"2018-02-01T19:50:48","slug":"move-datafiles-in-asm","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/move-datafiles-in-asm\/","title":{"rendered":"Move Datafiles in ASM"},"content":{"rendered":"<p><strong>Procedimento para mover datafiles em ASM<\/strong><\/p>\n<p>ID Tablespace Datafile<br \/>\n40 TESTE_D +DG2\/teste\/datafile\/teste_d.303.955634563<br \/>\n39 TESTE_D +DG2\/teste\/datafile\/teste_d.309.955600967<br \/>\n41 TESTE_D +DG2\/teste\/datafile\/teste_d.312.955612387<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:default decode:true \">rman target \/\r\n\r\ncopy datafile 40 TO '+DG4\/teste\/datafile\/teste_d303';\r\ncopy datafile 39 TO '+DG4\/teste\/datafile\/teste_d309';\r\ncopy datafile 41 TO '+DG4\/teste\/datafile\/teste_d312';\r\nSQL 'ALTER DATABASE datafile 40 offline';\r\nSQL 'ALTER DATABASE datafile 39 offline';\r\nSQL 'ALTER DATABASE datafile 41 offline';\r\n\r\nrun{\r\nallocate channel ch1 device TYPE disk;\r\nSET newname FOR datafile 40 TO '+DG4\/teste\/datafile\/teste_d303';\r\nswitch datafile ALL;\r\n}\r\n\r\nrun{\r\nallocate channel ch1 device TYPE disk;\r\nSET newname FOR datafile 39 TO '+DG4\/teste\/datafile\/teste_d309';\r\nswitch datafile ALL;\r\n}\r\n\r\nrun{\r\nallocate channel ch1 device TYPE disk;\r\nSET newname FOR datafile 41 TO '+DG4\/teste\/datafile\/teste_d312';\r\nswitch datafile ALL;\r\n}\r\n\r\nrun {\r\nallocate channel C1 device type disk;\r\nrecover datafile 40;\r\nrecover datafile 39;\r\nrecover datafile 41;\r\n}\r\n\r\nSQL 'ALTER DATABASE datafile 40 online';\r\nSQL 'ALTER DATABASE datafile 39 online';\r\nSQL 'ALTER DATABASE datafile 41 online';<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Apos abra o Banco e Apague os datafiles antigos.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Procedimento para mover datafiles em ASM ID Tablespace Datafile 40 TESTE_D +DG2\/teste\/datafile\/teste_d.303.955634563 39 TESTE_D +DG2\/teste\/datafile\/teste_d.309.955600967 41 TESTE_D +DG2\/teste\/datafile\/teste_d.312.955612387 &nbsp; rman target \/ copy datafile 40 TO &#8216;+DG4\/teste\/datafile\/teste_d303&#8217;; copy datafile 39 TO &#8216;+DG4\/teste\/datafile\/teste_d309&#8217;; copy datafile 41 TO &#8216;+DG4\/teste\/datafile\/teste_d312&#8217;; SQL &#8216;ALTER DATABASE datafile 40 offline&#8217;; SQL &#8216;ALTER DATABASE datafile 39 offline&#8217;; SQL &#8216;ALTER DATABASE datafile 41 offline&#8217;; run{ allocate channel ch1 device TYPE disk; SET newname FOR datafile 40 TO &#8216;+DG4\/teste\/datafile\/teste_d303&#8217;; switch datafile ALL; } run{ allocate[&#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\/1473"}],"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=1473"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1473\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=1473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=1473"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=1473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}