{"id":1984,"date":"2016-01-04T11:34:17","date_gmt":"2016-01-04T13:34:17","guid":{"rendered":"http:\/\/www.dbarj.com.br\/en\/?p=1984"},"modified":"2016-01-04T11:34:17","modified_gmt":"2016-01-04T13:34:17","slug":"change-rman-configuration-using-dbms_backup_restore","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/","title":{"rendered":"Change RMAN configuration using DBMS_BACKUP_RESTORE"},"content":{"rendered":"<p>In this article I will show how to change the RMAN configuration when you are connect\u00a0inside an Oracle DB, using the package <strong>DBMS_BACKUP_RESTORE<\/strong> and its procedures.<\/p>\n<p>Modifying those\u00a0RMAN attributes is an easy task when you are connected via\u00a0Oracle RMAN utility. You can simply use the <a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/backup.112\/e10643\/rcmsynta010.htm#i80338\" target=\"_blank\">CONFIGURE<\/a> syntax to change it.\u00a0However, what a few people know is that you can also do it using the non-documented DBMS package\u00a0DBMS_BACKUP_RESTORE via <strong>SETCONFIG<\/strong> procedure.<\/p>\n<p>This is a specially powerful tool when you have some business or process logic that needs to change it via PL\/SQL.<\/p>\n<p><em>One case where this approach would be useful is, for example, creating a trigger in a Data Guard environment based on the\u00a0DB_ROLE_CHANGE that will\u00a0change the value of &#8220;<strong>ARCHIVELOG DELETION POLICY<\/strong>&#8221; depending if the instance is the primary or the standby:<\/em><\/p>\n<ul>\n<li><em>For Primary:\u00a0CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;<\/em><\/li>\n<li><em>For Standby:\u00a0CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO &#8216;SBT_TAPE&#8217;;<\/em><\/li>\n<\/ul>\n<p>In this article, I will show you how to use it.<\/p>\n<p>First of all, checking the defaults:<\/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>The &#8220;<strong>#default<\/strong>&#8221; in the end of each lines tells us\u00a0that nothing was changed and everything is with out-of-box specs.<\/p>\n<p>First of all, let&#8217;s change the <strong>BACKUP OPTIMIZATION<\/strong> to <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>The number 1 returned by the function is the ID of the configuration inserted. We can check all the configurations modified by querying <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>In RMAN, we can certify that it was correctly modified:<\/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>Now, I will change the parameter <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 now that ID 2 was inserted. Query the configuration table:<\/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>In RMAN, everything is 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>The biggest problem of <strong>SETCONFIG<\/strong> procedure is that it does not make any validation. You can simply add any attribute string or value that you want. Obviously this can generate an dictionary incosistency.<\/p>\n<p>In this example, I will change <strong>CONTROLFILE AUTOBACKUP<\/strong> to <strong>MAYBE<\/strong> (note that this option does not exists).<\/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>It inserted without validating or constraining anything.\u00a0If we check in RMAN, we can see that we corrupted our dictionary,<\/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>And the data is inserted in the RMAN\u00a0configuration table.<\/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>So to clear this mess, we can simply use the\u00a0<strong>DELETECONFIG<\/strong> procedure passing the ID of the line we want to delete.<\/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>Nice. If we check the configuration table and RMAN, now the inconsistency has gone.<\/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>But what if you want to change the value of a\u00a0parameter\u00a0that is already defined on the table? If you simply use <strong>SETCONFIG<\/strong> to define a new value, it will generate an extra line. So you would have 2 values for the same parameter\u00a0that will lead to another inconsistency.<\/p>\n<p>The solution is to remove the parameter\u00a0before adding the new value to it. Let&#8217;s, for example, turn off <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>Checking on configuration table:<\/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>You can also use the\u00a0<strong>RESETCONFIG<\/strong> procedure if you wish to clear all the defined configuration. This is specially if you wish to return all the parameters to their default values.<\/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>That&#8217;s it. Now you can plan\u00a0and\u00a0create PL\/SQL triggers\/procedures\/jobs\u00a0that\u00a0can check and modify the RMAN configurations.<\/p>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-1984 jlk' href='javascript:void(0)' data-task='like' data-post_id='1984' 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-1984 lc'>+11<\/span><\/a><\/div><\/div> <div class='status-1984 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>In this article I will show how to change the RMAN configuration when you are connect\u00a0inside an Oracle DB, using the package DBMS_BACKUP_RESTORE and its procedures. Modifying those\u00a0RMAN attributes is an easy task when you are connected via\u00a0Oracle RMAN utility. You can simply use the CONFIGURE syntax to change it.\u00a0However, what a few people know &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":1994,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-1984","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-rman-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Change RMAN configuration using DBMS_BACKUP_RESTORE - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"In this article I will show how to change the RMAN configuration when you are connect\u00a0inside an Oracle DB, using the package DBMS_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\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Change RMAN configuration using DBMS_BACKUP_RESTORE\",\"datePublished\":\"2016-01-04T13:34:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/\"},\"wordCount\":534,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/RMAN.png\",\"articleSection\":[\"Recovery Manager (RMAN)\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/\",\"name\":\"Change RMAN configuration using DBMS_BACKUP_RESTORE - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/RMAN.png\",\"datePublished\":\"2016-01-04T13:34:17+00:00\",\"description\":\"In this article I will show how to change the RMAN configuration when you are connect\u00a0inside an Oracle DB, using the package DBMS_BACKUP_RESTORE.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-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\\\/en\\\/2016\\\/01\\\/change-rman-configuration-using-dbms_backup_restore\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change RMAN configuration using DBMS_BACKUP_RESTORE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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":"Change RMAN configuration using DBMS_BACKUP_RESTORE - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"In this article I will show how to change the RMAN configuration when you are connect\u00a0inside an Oracle DB, using the package DBMS_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\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Change RMAN configuration using DBMS_BACKUP_RESTORE","datePublished":"2016-01-04T13:34:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/"},"wordCount":534,"commentCount":3,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/RMAN.png","articleSection":["Recovery Manager (RMAN)"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/","url":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/","name":"Change RMAN configuration using DBMS_BACKUP_RESTORE - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/RMAN.png","datePublished":"2016-01-04T13:34:17+00:00","description":"In this article I will show how to change the RMAN configuration when you are connect\u00a0inside an Oracle DB, using the package DBMS_BACKUP_RESTORE.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/en\/2016\/01\/change-rman-configuration-using-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\/en\/2016\/01\/change-rman-configuration-using-dbms_backup_restore\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Change RMAN configuration using DBMS_BACKUP_RESTORE"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/wp-json\/wp\/v2\/posts\/1984","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=1984"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1984\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media\/1994"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=1984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=1984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=1984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}