{"id":388,"date":"2022-01-09T15:12:13","date_gmt":"2022-01-09T15:12:13","guid":{"rendered":"https:\/\/maboc.nl\/?p=388"},"modified":"2022-01-09T15:19:34","modified_gmt":"2022-01-09T15:19:34","slug":"basic-rman-configuration","status":"publish","type":"post","link":"https:\/\/maboc.nl\/?p=388","title":{"rendered":"Basic Rman Configuration"},"content":{"rendered":"<p>A basic rman configuration (backups to disk):<\/p>\n<pre style=\"font-size: 10px;\">\r\nRMAN> show all;\r\n\r\nRMAN configuration parameters for database with db_unique_name TINUS are:\r\nCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;\r\nCONFIGURE BACKUP OPTIMIZATION ON;\r\nCONFIGURE DEFAULT DEVICE TYPE TO DISK;\r\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\r\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\/u04\/backups\/tinus\/%F';\r\nCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;\r\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;\r\nCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;\r\nCONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '\/u04\/backups\/tinus\/%U';\r\nCONFIGURE MAXSETSIZE TO UNLIMITED;\r\nCONFIGURE ENCRYPTION FOR DATABASE OFF;\r\nCONFIGURE ENCRYPTION ALGORITHM 'AES128';\r\nCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;\r\nCONFIGURE RMAN OUTPUT TO KEEP FOR 31 DAYS;\r\nCONFIGURE ARCHIVELOG DELETION POLICY TO NONE;\r\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO '\/u01\/app\/oracle\/product\/19.3\/dbs\/snapcf_tinus.f'; # default\r\n\r\nRMAN>\r\n<\/pre>\n<p>Take care&#8230;this is a starting point.<br \/>\nA lot of adjustments can\/should be made to give a optimal configuration for your case.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A basic rman configuration (backups to disk): RMAN> show all; RMAN configuration parameters for database with db_unique_name TINUS are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#8216;\/u04\/backups\/tinus\/%F&#8217;; CONFIGURE DEVICE TYPE [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,20],"tags":[24,26],"class_list":["post-388","post","type-post","status-publish","format-standard","hentry","category-oracle","category-rman","tag-oracle","tag-rman"],"_links":{"self":[{"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/posts\/388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maboc.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=388"}],"version-history":[{"count":4,"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions"}],"predecessor-version":[{"id":392,"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions\/392"}],"wp:attachment":[{"href":"https:\/\/maboc.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maboc.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maboc.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}