{"id":1995,"date":"2016-01-04T14:05:46","date_gmt":"2016-01-04T16:05:46","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=1995"},"modified":"2016-01-14T15:10:28","modified_gmt":"2016-01-14T17:10:28","slug":"alterando-parametros-rman-usando-dbms_backup_restore","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/","title":{"rendered":"Alterando par\u00e2metros do RMAN usando DBMS_BACKUP_RESTORE"},"content":{"rendered":"<p>Neste artigo, vou mostrar como alterar as configura\u00e7\u00f5es do RMAN quando se est\u00e1 conectado a um BD Oracle, usando a package <strong>DBMS_BACKUP_RESTORE<\/strong> e suas procedures.<\/p>\n<p><strong>Artigo Publicado na OTN:\u00a0<a href=\"http:\/\/www.oracle.com\/technetwork\/pt\/articles\/database-performance\/alterando-configuracoes-rman-2851498-ptb.html\" target=\"_blank\">http:\/\/www.oracle.com\/technetwork\/pt\/articles\/database-performance\/alterando-configuracoes-rman-2851498-ptb.html<\/a><\/strong><\/p>\n<p>Modificar esses atributos do RMAN \u00e9 uma tarefa f\u00e1cil quando estamos conectados via utilit\u00e1rio do Oracle RMAN. Podemos simplesmente utilizar o comando <a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/backup.112\/e10643\/rcmsynta010.htm#i80338\" target=\"_blank\">CONFIGURE<\/a> para alterar qualquer valor.\u00a0No entanto, o que poucas pessoas sabem \u00e9 que isso tamb\u00e9m pode ser feito atrav\u00e9s da package n\u00e3o documentada DBMS_BACKUP_RESTORE, usando a sua procedure <strong>SETCONFIG<\/strong>.<\/p>\n<p>Essa \u00e9 uma ferramenta poderosa especialmente quando temos alguma regra de neg\u00f3cio ou l\u00f3gica de processo que precisa alter\u00e1-los via PL\/SQL.<\/p>\n<p><em>Um caso onde esta abordagem seria \u00fatil, por exemplo, est\u00e1 na cria\u00e7\u00e3o de uma trigger em um ambiente Data Guard, disparada na altera\u00e7\u00e3o da &#8220;ROLE&#8221; do Banco, que alteraria o valor do &#8220;<strong>ARCHIVELOG DELETION POLICY<\/strong>&#8221; dependendo se a inst\u00e2ncia \u00e9 primary ou standby:<\/em><\/p>\n<ul>\n<li><em>No Primary:\u00a0CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;<\/em><\/li>\n<li><em>No Standby:\u00a0CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO &#8216;SBT_TAPE&#8217;;<\/em><\/li>\n<\/ul>\n<p>Vamos ent\u00e3o ver como podemos utilizar esta package.<\/p>\n<p>Antes de mais nada, vou verificar as configura\u00e7\u00f5es padr\u00f5es:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; show all;\r\n\r\nusing target database control file instead of recovery catalog\r\nRMAN configuration parameters for database with db_unique_name ORCL are:\r\nCONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default\r\nCONFIGURE BACKUP OPTIMIZATION OFF; # default\r\nCONFIGURE DEFAULT DEVICE TYPE TO DISK; # default\r\nCONFIGURE CONTROLFILE AUTOBACKUP OFF; # default\r\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default\r\nCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default\r\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\r\nCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\r\nCONFIGURE MAXSETSIZE TO UNLIMITED; # default\r\nCONFIGURE ENCRYPTION FOR DATABASE OFF; # default\r\nCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default\r\nCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default\r\nCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default\r\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO '\/u01\/app\/oracle\/product\/11.2.4\/dbhome_1\/dbs\/snapcf_orcl.f'; # default\r\n\r\nRMAN&gt;<\/pre>\n<p>O &#8220;<strong>#default<\/strong>&#8221; ao final de cada linha significa que nada foi ainda alterado e a especifica\u00e7\u00f5es est\u00e3o todas originais.<\/p>\n<p>Alterando <strong>BACKUP OPTIMIZATION<\/strong> para <strong>ON<\/strong> via PL\/SQL:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; var a number\r\nSQL&gt; exec :a := DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','ON');\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; print :a\r\n\r\n         A\r\n----------\r\n         1\r\n\r\nSQL&gt;<\/pre>\n<p>O n\u00famero 1 retornado pela fun\u00e7\u00e3o \u00e9 o ID desta configura\u00e7\u00e3o inserida. Podemos listar todas as configura\u00e7\u00f5es alteradas consultando a view\u00a0<strong>v$rman_configuration<\/strong>:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; set lines 200\r\nSQL&gt; col name format a40\r\nSQL&gt; col value format a100\r\nSQL&gt; select * from v$rman_configuration;\r\n\r\n     CONF# NAME                                     VALUE\r\n---------- ---------------------------------------- -------------------------------------------------------\r\n         1 BACKUP OPTIMIZATION                      ON\r\n\r\nSQL&gt;<\/pre>\n<p>Pelo RMAN, podemos nos certificar que ele foi modificado corretamente:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; show backup optimization;\r\n\r\nusing target database control file instead of recovery catalog\r\nRMAN configuration parameters for database with db_unique_name ORCL are:\r\nCONFIGURE BACKUP OPTIMIZATION ON;\r\n\r\nRMAN&gt;<\/pre>\n<p>Agora vou alterar o par\u00e2metro\u00a0<strong>COMPRESSION ALGOTITHM<\/strong>:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; exec :a := DBMS_BACKUP_RESTORE.SETCONFIG('COMPRESSION ALGORITHM',q'['HIGH' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD FALSE]');\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; print :a\r\n\r\n         A\r\n----------\r\n         2\r\n\r\nSQL&gt;<\/pre>\n<p>Note que agora o ID 2 que foi inserido. Consultando na tabela de configura\u00e7\u00f5es:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; select * from v$rman_configuration;\r\n\r\n     CONF# NAME                                     VALUE\r\n---------- ---------------------------------------- -------------------------------------------------------\r\n         1 BACKUP OPTIMIZATION                      ON\r\n         2 COMPRESSION ALGORITHM                    'HIGH' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD FALSE\r\n\r\nSQL&gt;<\/pre>\n<p>No RMAN, tudo est\u00e1 OK.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; show compression algorithm;\r\n\r\nRMAN configuration parameters for database with db_unique_name ORCL are:\r\nCONFIGURE COMPRESSION ALGORITHM 'HIGH' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD FALSE;\r\n\r\nRMAN&gt;<\/pre>\n<p>O maior problema da procedure <strong>SETCONFIG<\/strong> \u00e9 que ela n\u00e3o faz qualquer valida\u00e7\u00e3o. Voc\u00ea pode simplesmente adicionar qualquer atributo com qualquer valor que desejar. Obviamente isso pode gerar uma inconsist\u00eancia no dicion\u00e1rio de dados.<\/p>\n<p>Neste exemplo, vou alterar o par\u00e2metro <strong>CONTROLFILE AUTOBACKUP<\/strong> para <strong>MAYBE<\/strong> (note que este valor de op\u00e7\u00e3o na verdade n\u00e3o existe).<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; exec :a := DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','MAYBE');\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; print :a\r\n\r\n         A\r\n----------\r\n         3\r\n\r\nSQL&gt;<\/pre>\n<p>O par\u00e2metro foi inserido sem qualquer valida\u00e7\u00e3o. Se verificarmos agora no RMAN, veremos que o dicion\u00e1rio ficou corrompido:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; show controlfile autobackup;\r\n\r\nRMAN configuration parameters for database with db_unique_name ORCL are:\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of show command at 12\/10\/2015 10:35:47\r\nRMAN-06466: error parsing configuration string (CONFIGURE CONTROLFILE AUTOBACKUP MAYBE;)\r\nRMAN-01009: syntax error: found \"identifier\": expecting one of: \"clear, format, off, on\"\r\nRMAN-01008: the bad identifier was: MAYBE\r\nRMAN-01007: at line 1 column 34 file: Configuration Row\r\n\r\nRMAN&gt;<\/pre>\n<p>E os dados foram adicionadas na tabela de configura\u00e7\u00e3o do RMAN.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; select * from v$rman_configuration;\r\n\r\n     CONF# NAME                                     VALUE\r\n---------- ---------------------------------------- -------------------------------------------------------\r\n         1 BACKUP OPTIMIZATION                      ON\r\n         2 COMPRESSION ALGORITHM                    'HIGH' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD FALSE\r\n         3 CONTROLFILE AUTOBACKUP                   MAYBE\r\n\r\nSQL&gt;<\/pre>\n<p>Para limpar este problema, podemos simplesmente usar a procedure <strong>DELETECONFIG<\/strong> passando como par\u00e2metro o ID da linha que quer ser deletada.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; EXEC DBMS_BACKUP_RESTORE.DELETECONFIG(3);\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt;<\/pre>\n<p>\u00d3timo. Verificando no RMAN e na tabela de configura\u00e7\u00e3o, a inconsist\u00eancia foi resolvida.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; select * from v$rman_configuration;\r\n\r\n     CONF# NAME                                     VALUE\r\n---------- ---------------------------------------- -------------------------------------------------------\r\n         1 BACKUP OPTIMIZATION                      ON\r\n         2 COMPRESSION ALGORITHM                    'HIGH' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD FALSE\r\n\r\nSQL&gt;<\/pre>\n<p>Mas e se quisermos alterar o valor de um par\u00e2metro j\u00e1 cadastrado na tabela? Se simplesmente usarmos o <strong>SETCONFIG<\/strong> para definir este novo valor, a procedure vai gerar uma nova linha na tabela. Desta forma, ter\u00edamos 2 valores para um \u00fanico par\u00e2metro, o que levaria a mais uma inconsist\u00eancia.<\/p>\n<p>A solu\u00e7\u00e3o \u00e9 remover o par\u00e2metro antes de adicionar um novo valor para ele. Vamos como exemplo desligar o <strong>BACKUP OPTIMIZATION<\/strong>.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; exec DBMS_BACKUP_RESTORE.DELETECONFIG(1);\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; exec :a := DBMS_BACKUP_RESTORE.SETCONFIG('BACKUP OPTIMIZATION','OFF');\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; print :a\r\n\r\n         A\r\n----------\r\n         1\r\n\r\nSQL&gt;<\/pre>\n<p>Verificando na tabela de configura\u00e7\u00f5es.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; select * from v$rman_configuration;\r\n\r\n     CONF# NAME                                     VALUE\r\n---------- ---------------------------------------- -------------------------------------------------------\r\n         1 BACKUP OPTIMIZATION                      OFF\r\n         2 COMPRESSION ALGORITHM                    'HIGH' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD FALSE\r\n\r\nSQL&gt;<\/pre>\n<p>Tamb\u00e9m \u00e9 poss\u00edvel utilizar a procedure <strong>RESETCONFIG<\/strong> se quiser limpar todos os par\u00e2metros definidos. Isto \u00e9 bem \u00fatil especialmente para voltar os par\u00e2metros aos seus valores de f\u00e1brica.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; exec DBMS_BACKUP_RESTORE.RESETCONFIG;\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL&gt; select * from v$rman_configuration;\r\n\r\nno rows selected\r\n\r\nSQL&gt;<\/pre>\n<p>\u00d3timo! Agora voc\u00ea j\u00e1 pode criar triggers\/procedures\/jobs que podem consultar e alterar as configura\u00e7\u00f5es do RMAN.<\/p>\n<b>Gostou? N\u00e3o deixe de comentar ou deixar um \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-1995 jlk' href='javascript:void(0)' data-task='like' data-post_id='1995' 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-1995 lc'>+1<\/span><\/a><\/div><\/div> <div class='status-1995 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Neste artigo, vou mostrar como alterar as configura\u00e7\u00f5es do RMAN quando se est\u00e1 conectado a um BD Oracle, usando a package DBMS_BACKUP_RESTORE e suas procedures. Artigo Publicado na OTN:\u00a0http:\/\/www.oracle.com\/technetwork\/pt\/articles\/database-performance\/alterando-configuracoes-rman-2851498-ptb.html Modificar esses atributos do RMAN \u00e9 uma tarefa f\u00e1cil quando estamos conectados via utilit\u00e1rio do Oracle RMAN. Podemos simplesmente utilizar o comando CONFIGURE para alterar qualquer &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/\">Continue lendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":1994,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-1995","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-rman","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Alterando par\u00e2metros do RMAN usando DBMS_BACKUP_RESTORE - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Neste artigo, vou mostrar como alterar as configura\u00e7\u00f5es do RMAN quando se est\u00e1 conectado a um BD Oracle, usando a package\u00a0DBMS_BACKUP_RESTORE.\" \/>\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\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/\" \/>\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=\"6 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\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Alterando par\u00e2metros do RMAN usando DBMS_BACKUP_RESTORE\",\"datePublished\":\"2016-01-04T16:05:46+00:00\",\"dateModified\":\"2016-01-14T17:10:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/\"},\"wordCount\":578,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/RMAN.png\",\"articleSection\":[\"Recovery Manager (RMAN)\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/\",\"name\":\"Alterando par\u00e2metros do RMAN usando DBMS_BACKUP_RESTORE - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/RMAN.png\",\"datePublished\":\"2016-01-04T16:05:46+00:00\",\"dateModified\":\"2016-01-14T17:10:28+00:00\",\"description\":\"Neste artigo, vou mostrar como alterar as configura\u00e7\u00f5es do RMAN quando se est\u00e1 conectado a um BD Oracle, usando a package\u00a0DBMS_BACKUP_RESTORE.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/RMAN.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/RMAN.png\",\"width\":351,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2016\\\/01\\\/alterando-parametros-rman-usando-dbms_backup_restore\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Alterando par\u00e2metros do RMAN usando DBMS_BACKUP_RESTORE\"}]},{\"@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":"Alterando par\u00e2metros do RMAN usando DBMS_BACKUP_RESTORE - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Neste artigo, vou mostrar como alterar as configura\u00e7\u00f5es do RMAN quando se est\u00e1 conectado a um BD Oracle, usando a package\u00a0DBMS_BACKUP_RESTORE.","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\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/","twitter_misc":{"Escrito por":"DBA RJ","Est. tempo de leitura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Alterando par\u00e2metros do RMAN usando DBMS_BACKUP_RESTORE","datePublished":"2016-01-04T16:05:46+00:00","dateModified":"2016-01-14T17:10:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/"},"wordCount":578,"commentCount":2,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/RMAN.png","articleSection":["Recovery Manager (RMAN)"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/","url":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/","name":"Alterando par\u00e2metros do RMAN usando DBMS_BACKUP_RESTORE - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/RMAN.png","datePublished":"2016-01-04T16:05:46+00:00","dateModified":"2016-01-14T17:10:28+00:00","description":"Neste artigo, vou mostrar como alterar as configura\u00e7\u00f5es do RMAN quando se est\u00e1 conectado a um BD Oracle, usando a package\u00a0DBMS_BACKUP_RESTORE.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/#primaryimage","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/RMAN.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/RMAN.png","width":351,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2016\/01\/alterando-parametros-rman-usando-dbms_backup_restore\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/pt-br\/"},{"@type":"ListItem","position":2,"name":"Alterando par\u00e2metros do RMAN usando DBMS_BACKUP_RESTORE"}]},{"@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\/1995","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=1995"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/1995\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/media\/1994"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/media?parent=1995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/categories?post=1995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/tags?post=1995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}