{"id":886,"date":"2021-09-23T15:24:29","date_gmt":"2021-09-23T07:24:29","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=886"},"modified":"2025-05-16T17:45:51","modified_gmt":"2025-05-16T09:45:51","slug":"oracle-rman-%e5%a4%87%e4%bb%bd%e5%ae%9e%e8%b7%b5","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=886","title":{"rendered":"Oracle Rman \u5907\u4efd\u5b9e\u8df5"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<label for=\"ez-toc-cssicon-toggle-item-6a022ec351cf8\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a022ec351cf8\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#1_%E5%A4%87%E4%BB%BD%E7%AD%96%E7%95%A5\" >1. \u5907\u4efd\u7b56\u7565<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#2_%E8%AE%BE%E7%BD%AE%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%BA%E5%BD%92%E6%A1%A3%E6%A8%A1%E5%BC%8F\" >2. \u8bbe\u7f6e\u6570\u636e\u5e93\u4e3a\u5f52\u6863\u6a21\u5f0f<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#21_RAC%E6%95%B0%E6%8D%AE%E5%BA%93\" >2.1. RAC\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#22_%E5%8D%95%E5%AE%9E%E4%BE%8B%E6%95%B0%E6%8D%AE%E5%BA%93\" >2.2. \u5355\u5b9e\u4f8b\u6570\u636e\u5e93<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#3_%E5%90%AF%E7%A6%81%E7%94%A8%E5%9D%97%E6%94%B9%E5%8F%98%E8%B7%9F%E8%B8%AA\" >3. \u542f\/\u7981\u7528\u5757\u6539\u53d8\u8ddf\u8e2a<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#31_RAC%E6%95%B0%E6%8D%AE%E5%BA%93\" >3.1. RAC\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#32_%E5%8D%95%E5%AE%9E%E4%BE%8B%E6%95%B0%E6%8D%AE%E5%BA%93\" >3.2. \u5355\u5b9e\u4f8b\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#33_%E7%A6%81%E7%94%A8%E5%9D%97%E6%94%B9%E5%8F%98%E8%B7%9F%E8%B8%AA\" >3.3. \u7981\u7528\u5757\u6539\u53d8\u8ddf\u8e2a<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#4_%E5%A4%87%E4%BB%BD%E8%84%9A%E6%9C%AC\" >4. \u5907\u4efd\u811a\u672c<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#41_RAC%E6%95%B0%E6%8D%AE%E5%BA%93-%E4%BD%BF%E7%94%A8catalog%E7%9B%AE%E5%BD%95%E5%A2%9E%E9%87%8F%E5%A4%87%E4%BB%BD\" >4.1. RAC\u6570\u636e\u5e93-\u4f7f\u7528catalog\u76ee\u5f55\u589e\u91cf\u5907\u4efd<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#42_RAC%E6%95%B0%E6%8D%AE%E5%BA%93-%E4%B8%8D%E4%BD%BF%E7%94%A8catalog%E7%9B%AE%E5%BD%95%E5%A2%9E%E9%87%8F%E5%A4%87%E4%BB%BD\" >4.2. RAC\u6570\u636e\u5e93-\u4e0d\u4f7f\u7528catalog\u76ee\u5f55\u589e\u91cf\u5907\u4efd<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#43_%E5%8D%95%E5%AE%9E%E4%BE%8B%E6%95%B0%E6%8D%AE%E5%BA%93-%E5%85%A8%E9%87%8F%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE%E5%BA%93%E8%84%9A%E6%9C%AC\" >4.3. \u5355\u5b9e\u4f8b\u6570\u636e\u5e93-\u5168\u91cf\u5907\u4efd\u6570\u636e\u5e93\u811a\u672c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#44_%E5%8D%95%E5%AE%9E%E4%BE%8B%E6%95%B0%E6%8D%AE%E5%BA%93-%E5%A2%9E%E9%87%8F%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE%E5%BA%93%E8%84%9A%E6%9C%AC\" >4.4. \u5355\u5b9e\u4f8b\u6570\u636e\u5e93-\u589e\u91cf\u5907\u4efd\u6570\u636e\u5e93\u811a\u672c<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"http:\/\/dba.qishuo.xin\/?p=886\/#5_%E5%AE%9A%E6%97%B6%E4%BB%BB%E5%8A%A1\" >5. \u5b9a\u65f6\u4efb\u52a1<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_%E5%A4%87%E4%BB%BD%E7%AD%96%E7%95%A5\"><\/span>1. \u5907\u4efd\u7b56\u7565<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/20181205151221978.gif\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/20181205151221978.gif\" alt=\"RMAN\u5907\u4efd\u7b56\u7565\" title=\"RMAN\u5907\u4efd\u7b56\u7565\" \/><\/a><\/p>\n<p><strong>\u6bcf\u5468\u65e5\u505a0\u7ea7\u5907\u4efd\u3002<\/strong><br \/>\n<strong>\u6bcf\u5468\u4e00\u81f3\u5468\u516d\u505a1\u7ea7\u5dee\u5f02\u589e\u91cf\u5907\u4efd\u3002<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_%E8%AE%BE%E7%BD%AE%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%BA%E5%BD%92%E6%A1%A3%E6%A8%A1%E5%BC%8F\"><\/span>2. \u8bbe\u7f6e\u6570\u636e\u5e93\u4e3a\u5f52\u6863\u6a21\u5f0f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"21_RAC%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>2.1. RAC\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code>~]# su - oracle\n~]$ sqlplus \/ as sysdba\nSQL&gt; alter system set log_archive_dest_1=&#039;LOCATION=+FRA&#039; scope=spfile;\nSQL&gt; shu immediate;\nSQL&gt; startup mount;\nSQL&gt; alter database archivelog\uff1b\nSQL&gt; alter database open;\nSQL&gt; archive log list;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"22_%E5%8D%95%E5%AE%9E%E4%BE%8B%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>2.2. \u5355\u5b9e\u4f8b\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code>~]# mkdir -p \/dbData\/OracleBack\/{archivelog,rmanbak}\n~]# chown -R oracle:oinstall \/dbData\/OracleBack\/\n~]# su - oracle\n~]$ sqlplus \/ as sysdba\nSQL&gt; alter system set log_archive_dest_1=&#039;LOCATION=\/dbData\/OracleBack\/archivelog\/&#039; scope=spfile;\nSQL&gt; shu immediate;\nSQL&gt; startup mount;\nSQL&gt; alter database archivelog\uff1b\nSQL&gt; alter database open;\nSQL&gt; archive log list;<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"3_%E5%90%AF%E7%A6%81%E7%94%A8%E5%9D%97%E6%94%B9%E5%8F%98%E8%B7%9F%E8%B8%AA\"><\/span>3. \u542f\/\u7981\u7528\u5757\u6539\u53d8\u8ddf\u8e2a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"31_RAC%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>3.1. RAC\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt; alter database enable block change tracking using file &#039;+DATAC1&#039;;\n\nDatabase altered<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"32_%E5%8D%95%E5%AE%9E%E4%BE%8B%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>3.2. \u5355\u5b9e\u4f8b\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt; alter database enable block change tracking using file &#039;\/dbData\/OracleBack\/rman_change_track.f&#039; reuse;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"33_%E7%A6%81%E7%94%A8%E5%9D%97%E6%94%B9%E5%8F%98%E8%B7%9F%E8%B8%AA\"><\/span>3.3. \u7981\u7528\u5757\u6539\u53d8\u8ddf\u8e2a<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"4_%E5%A4%87%E4%BB%BD%E8%84%9A%E6%9C%AC\"><\/span>4. \u5907\u4efd\u811a\u672c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"41_RAC%E6%95%B0%E6%8D%AE%E5%BA%93-%E4%BD%BF%E7%94%A8catalog%E7%9B%AE%E5%BD%95%E5%A2%9E%E9%87%8F%E5%A4%87%E4%BB%BD\"><\/span>4.1. RAC\u6570\u636e\u5e93-\u4f7f\u7528catalog\u76ee\u5f55\u589e\u91cf\u5907\u4efd<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><strong><code>cat \/dbData\/OracleBack\/rmanbak\/rmanbackup.sh<\/code><\/strong><\/p>\n<pre><code class=\"language-shell\">#!\/bin\/bash\nsource \/home\/oracle\/.bash_profile\ncurrent_day=`date +%Y%m%d`\nbakfile_path=&#039;+DATAC1&#039;\narchfile_path=&#039;+DATAC1&#039;\nchannel_num=12\nbackup_log=\/dbData\/OracleBack\/rmanbaklog\/rmanbak-$ORACLE_SID-`date +%Y%m%d-%H%M`.log\nweekday=`date &#039;+%u&#039;`\nmkdir -p \/dbData\/OracleBack\/rmanbak\nmkdir -p \/dbData\/OracleBack\/rmanbaklog\n\n$ORACLE_HOME\/bin\/rman target \/ catalog &#039;&quot;rco\/Hz571!xy00yz@xxx.xxx.xxx.xxx:1521\/catpdb&quot;&#039; log=$backup_log &lt;&lt; EON\nCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\n#CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#039;$bakfile_path&#039;;\nCONFIGURE DEVICE TYPE DISK PARALLELISM $channel_num BACKUP TYPE TO BACKUPSET;\nEON\n\ncase $weekday in\n1|2|3|4|5|6)\n# Begin backup incremental level 1  database\n$ORACLE_HOME\/bin\/rman target \/ catalog &#039;&quot;rco\/Hz571!xy00yz@xxx.xxx.xxx.xxx:1521\/catpdb&quot;&#039; log=$backup_log &lt;&lt; EON\nrun {\nBACKUP INCREMENTAL LEVEL 1 DATABASE TAG &#039;DAILY_1&#039; FORMAT &#039;$bakfile_path&#039; PLUS ARCHIVELOG TAG &#039;ARC_1&#039; FORMAT &#039;$archfile_path&#039; DELETE ALL INPUT;\nsql &#039;alter system archive log current&#039;;\nDELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 7 DAYS;\n}\nEON\n;;\n7)\n# Begin backup incremental level 0  database\n$ORACLE_HOME\/bin\/rman target \/ catalog &#039;&quot;rco\/Hz571!xy00yz@xxx.xxx.xxx.xxx:1521\/catpdb&quot;&#039; log=$backup_log &lt;&lt;EON\nrun {\nBACKUP INCREMENTAL LEVEL 0 DATABASE TAG &#039;WEEKLY_0&#039; FORMAT &#039;$bakfile_path&#039; PLUS ARCHIVELOG TAG &#039;ARC_0&#039; FORMAT &#039;$archfile_path&#039; DELETE ALL INPUT;\nsql &#039;alter system archive log current&#039;;\nDELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 7 DAYS;\nDELETE NOPROMPT EXPIRED BACKUP;\n}\nEON\n;;\nesac<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"42_RAC%E6%95%B0%E6%8D%AE%E5%BA%93-%E4%B8%8D%E4%BD%BF%E7%94%A8catalog%E7%9B%AE%E5%BD%95%E5%A2%9E%E9%87%8F%E5%A4%87%E4%BB%BD\"><\/span>4.2. RAC\u6570\u636e\u5e93-\u4e0d\u4f7f\u7528catalog\u76ee\u5f55\u589e\u91cf\u5907\u4efd<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">~]# cat rmanbackup.sh\n#!\/bin\/bash\nsource \/home\/oracle\/.bash_profile\ncurrent_day=`date +%Y%m%d`\nbakfile_path=&#039;+BAKDG&#039;\narchfile_path=&#039;+ARCHDG&#039;\nchannel_num=12\nbackup_log=\/dbData\/OracleBack\/rmanbaklog\/rmanbak-$ORACLE_SID-`date +%Y%m%d-%H%M`.log\nweekday=`date &#039;+%u&#039;`\nmkdir -p \/dbData\/OracleBack\/rmanbak\nmkdir -p \/dbData\/OracleBack\/rmanbaklog\n\n$ORACLE_HOME\/bin\/rman target \/  log=$backup_log &lt;&lt; EON\nCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\nCONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#039;$bakfile_path&#039;;\nCONFIGURE DEVICE TYPE DISK PARALLELISM $channel_num BACKUP TYPE TO BACKUPSET;\nEON\n\ncase $weekday in\n1|2|3|4|5|6)\necho &quot;Begin backup incremental level 1 database&#039;;&quot;\necho &quot;Please see the backup logfile $backup_log&quot;\necho &quot;Please wait for a minute.......................................................&quot;\n$ORACLE_HOME\/bin\/rman target \/ log=$backup_log &lt;&lt;EON\nrun {\nBACKUP INCREMENTAL LEVEL 1 TAG &#039;bakLevel1&#039; FORMAT &#039;$bakfile_path&#039; DATABASE;\nsql &#039;alter system archive log current&#039;;\nBACKUP ARCHIVELOG ALL DELETE INPUT FORMAT &#039;$archfile_path&#039; TAG &#039;ARCH_BAK&#039;;\nDELETE NOPROMPT OBSOLETE;\n}\nEON\n;;\n7)\n# Begin backup incremental level 0  database\necho &quot;Begin backup incremental level 0 database&#039;;&quot;\necho &quot;Please see the backup logfile $backup_log&quot;\necho &quot;Please wait for a minute.......................................................&quot;\n$ORACLE_HOME\/bin\/rman target \/  log=$backup_log &lt;&lt;EON\nrun {\nBACKUP INCREMENTAL LEVEL 0 TAG &#039;bakLevel0&#039; FORMAT &#039;$bakfile_path&#039; DATABASE;\nsql &#039;alter system archive log current&#039;;\nBACKUP ARCHIVELOG ALL DELETE INPUT FORMAT &#039;$archfile_path&#039; TAG &#039;ARCH_BAK&#039;;\nDELETE NOPROMPT OBSOLETE;\nDELETE NOPROMPT EXPIRED BACKUP;\n}\nEON\n;;\nesac<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"43_%E5%8D%95%E5%AE%9E%E4%BE%8B%E6%95%B0%E6%8D%AE%E5%BA%93-%E5%85%A8%E9%87%8F%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE%E5%BA%93%E8%84%9A%E6%9C%AC\"><\/span>4.3. \u5355\u5b9e\u4f8b\u6570\u636e\u5e93-\u5168\u91cf\u5907\u4efd\u6570\u636e\u5e93\u811a\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">~]$ cat rmanbackup.sh\n#!\/bin\/bash\nsource \/home\/oracle\/.bash_profile\ncurrent_day=`date +%Y%m%d`\nbakfile_path=&#039;\/dbData\/OracleBack\/rmanbak&#039;\nchannel_num=4\nbackup_log=\/dbData\/OracleBack\/rmanbaklog\/rmanbak-$ORACLE_SID-`date +%Y%m%d-%H%M`.log\nweekday=`date &#039;+%u&#039;`\nmkdir -p \/dbData\/OracleBack\/rmanbak\nmkdir -p \/dbData\/OracleBack\/rmanbaklog\n\n$ORACLE_HOME\/bin\/rman target \/  log=$backup_log &lt;&lt; EON\nCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\n#CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#039;$bakfile_path&#039;;\nCONFIGURE DEVICE TYPE DISK PARALLELISM $channel_num BACKUP TYPE TO BACKUPSET;\nEON\n\n$ORACLE_HOME\/bin\/rman target \/  log=$backup_log &lt;&lt;EON\nrun {\nBACKUP DATABASE TAG &#039;DB_FULL&#039; FORMAT &#039;$bakfile_path\/dbfull_%T_%U&#039;\n  PLUS ARCHIVELOG TAG &#039;ARC_BAK&#039; FORMAT &#039;$bakfile_path\/arch_%T_%U&#039; DELETE ALL INPUT;\nsql &#039;alter system archive log current&#039;;\n}\nALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;\nDELETE NOPROMPT OBSOLETE;\nDELETE NOPROMPT EXPIRED BACKUP;\nLIST BACKUP SUMMARY;\nRELEASE CHANNEL;\nEON<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"44_%E5%8D%95%E5%AE%9E%E4%BE%8B%E6%95%B0%E6%8D%AE%E5%BA%93-%E5%A2%9E%E9%87%8F%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE%E5%BA%93%E8%84%9A%E6%9C%AC\"><\/span>4.4. \u5355\u5b9e\u4f8b\u6570\u636e\u5e93-\u589e\u91cf\u5907\u4efd\u6570\u636e\u5e93\u811a\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">~]$ cat rmanbackup.sh\n#!\/bin\/bash\nsource \/home\/oracle\/.bash_profile\ncurrent_day=`date +%Y%m%d`\nbakfile_path=&#039;\/OracleData-bak\/rmanbak&#039;\nchannel_num=8\nbackup_log=\/OracleData-bak\/rmanbaklog\/rmanbak-$ORACLE_SID-`date +%Y%m%d-%H%M`.log\nweekday=`date &#039;+%u&#039;`\nmkdir -p \/OracleData-bak\/rmanbak\nmkdir -p \/OracleData-bak\/rmanbaklog\/\n\n$ORACLE_HOME\/bin\/rman target \/  log=$backup_log &lt;&lt; EON\nCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\n#CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#039;$bakfile_path&#039;;\nCONFIGURE DEVICE TYPE DISK PARALLELISM $channel_num BACKUP TYPE TO BACKUPSET;\nCONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 4G;\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#039;$bakfile_path\/ctl_%F&#039;;\nEON\n\ncase $weekday in\n1|2|3|4|5|6)\necho &quot;Begin backup incremental level 1 database&#039;;&quot;\necho &quot;Please see the backup logfile $backup_log&quot;\necho &quot;Please wait for a minute.......................................................&quot;\n$ORACLE_HOME\/bin\/rman target \/ log=$backup_log &lt;&lt;EON\nrun {\nBACKUP INCREMENTAL LEVEL 1 TAG &#039;bakLevel1&#039; FORMAT &#039;$bakfile_path\/dbfile_%T_%U&#039; DATABASE PLUS ARCHIVELOG TAG &#039;ARC_BAK&#039; FORMAT &#039;$bakfile_path\/arch_%T_%U&#039; DELETE ALL INPUT;\nsql &#039;alter system archive log current&#039;;\nDELETE NOPROMPT OBSOLETE;\n}\nEON\n;;\n7)\n# Begin backup incremental level 0  database\necho &quot;Begin backup incremental level 0 database&#039;;&quot;\necho &quot;Please see the backup logfile $backup_log&quot;\necho &quot;Please wait for a minute.......................................................&quot;\n$ORACLE_HOME\/bin\/rman target \/  log=$backup_log &lt;&lt;EON\nrun {\nBACKUP INCREMENTAL LEVEL 0 TAG &#039;bakLevel0&#039; FORMAT &#039;$bakfile_path\/dbfile_%T_%U&#039; DATABASE PLUS ARCHIVELOG TAG &#039;ARC_BAK&#039; FORMAT &#039;$bakfile_path\/arch_%T_%U&#039; DELETE ALL INPUT;\nsql &#039;alter system archive log current&#039;;\nDELETE NOPROMPT OBSOLETE;\nDELETE NOPROMPT EXPIRED BACKUP;\n}\nEON\n;;\nesac<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"5_%E5%AE%9A%E6%97%B6%E4%BB%BB%E5%8A%A1\"><\/span>5. \u5b9a\u65f6\u4efb\u52a1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u5728oracle\u7528\u6237\u4e0b\u521b\u5efa\u5b9a\u65f6\u5907\u4efd\u4efb\u52a1\uff0c\u6bcf\u5929\u7684 <code>04:00<\/code> \u6267\u884c <code>rmanbackup.sh<\/code> \u8fd9\u4e2a\u5907\u4efd\u811a\u672c\u3002<\/p>\n<pre><code class=\"language-shell\">~]# su - oracle\n~]$ crontab -e\n\n00 04 * * * sh \/dbData\/OracleBack\/rmanbak\/rmanbackup.sh<\/code><\/pre>\n<p>\u53e6\u5916\u4e5f\u53ef\u53c2\u8003\u4e0b\u9762\u7684\u5199\u6cd5\uff1a<\/p>\n<pre><code class=\"language-shell\"># Perform full backup on database Sunday at 3:05 am\n5 3 * * 0 \/$scrip_path\/backup_db database_name full &gt; \/$scrip_path\/logs\/full_backup.log\n# Perform incremental backups on database Mon-Sat at 3:05 am\n5 3 * * 1-6 \/$scrip_path\/backup_db database_name inc &gt; \/$scrip_path\/logs\/inc_backup.log<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1. \u5907\u4efd\u7b56\u7565 \u6bcf\u5468\u65e5\u505a0\u7ea7\u5907\u4efd\u3002 \u6bcf\u5468\u4e00\u81f3\u5468\u516d\u505a&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,2],"tags":[16,119,60],"class_list":{"0":"post-886","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-oracle","8":"tag-oracle","9":"tag-rman","10":"tag-60"},"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/886","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=886"}],"version-history":[{"count":28,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/886\/revisions"}],"predecessor-version":[{"id":4132,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/886\/revisions\/4132"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=886"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}