{"id":849,"date":"2021-09-22T01:07:20","date_gmt":"2021-09-21T17:07:20","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=849"},"modified":"2023-10-20T20:57:06","modified_gmt":"2023-10-20T12:57:06","slug":"%e4%bd%bf%e7%94%a8%e6%81%a2%e5%a4%8d%e7%9b%ae%e5%bd%95%e7%ae%a1%e7%90%86oracle%e5%a4%87%e4%bb%bd","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=849","title":{"rendered":"\u4f7f\u7528\u6062\u590d\u76ee\u5f55\u7ba1\u7406Oracle\u5907\u4efd"},"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-69def884d8c1e\" 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-69def884d8c1e\" 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=849\/#1_%E4%BB%80%E4%B9%88%E6%98%AF%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\" >1. \u4ec0\u4e48\u662f\u6062\u590d\u76ee\u5f55<\/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=849\/#2_%E4%BD%BF%E7%94%A8%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95%E7%9A%84%E4%BC%98%E5%8A%BF\" >2. \u4f7f\u7528\u6062\u590d\u76ee\u5f55\u7684\u4f18\u52bf<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#3_%E5%A6%82%E4%BD%95%E5%88%9B%E5%BB%BA%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95%EF%BC%9F\" >3. \u5982\u4f55\u521b\u5efa\u6062\u590d\u76ee\u5f55\uff1f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#4_%E7%A4%BA%E4%BE%8B\" >4. \u793a\u4f8b<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#41_%E5%88%9B%E5%BB%BA%E4%B8%80%E4%B8%AAPDB%E6%95%B0%E6%8D%AE%E5%BA%93%E4%BD%9C%E4%B8%BA%E7%9B%AE%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93\" >4.1. \u521b\u5efa\u4e00\u4e2aPDB\u6570\u636e\u5e93\u4f5c\u4e3a\u76ee\u5f55\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#42_%E5%88%9B%E5%BB%BA%E8%A1%A8%E7%A9%BA%E9%97%B4%E4%B8%8E%E7%94%A8%E6%88%B7%E7%94%A8\" >4.2. \u521b\u5efa\u8868\u7a7a\u95f4\u4e0e\u7528\u6237\u7528<\/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=849\/#43_%E5%88%9B%E5%BB%BA%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\" >4.3. \u521b\u5efa\u6062\u590d\u76ee\u5f55<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#5_RMAN%E8%BF%9E%E6%8E%A5%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\" >5. RMAN\u8fde\u63a5\u6062\u590d\u76ee\u5f55<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#51_%E5%B0%86%E7%9B%AE%E6%A0%87%E6%95%B0%E6%8D%AE%E5%BA%93%E6%B3%A8%E5%86%8C%E5%88%B0%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\" >5.1. \u5c06\u76ee\u6807\u6570\u636e\u5e93\u6ce8\u518c\u5230\u6062\u590d\u76ee\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#52_%E5%9C%A8%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95%E4%B8%8A%E6%B3%A8%E5%86%8C%E7%9B%AE%E6%A0%87%E6%95%B0%E6%8D%AE%E5%BA%93\" >5.2. \u5728\u6062\u590d\u76ee\u5f55\u4e0a\u6ce8\u518c\u76ee\u6807\u6570\u636e\u5e93<\/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=849\/#53_%E5%90%8C%E6%AD%A5%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE\" >5.3. \u540c\u6b65\u5907\u4efd\u6570\u636e<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#6_%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE%E5%BA%93\" >6. \u5907\u4efd\u6570\u636e\u5e93<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#61_%E5%88%9B%E5%BB%BA%E4%B8%80%E4%B8%AA%E8%84%9A%E6%9C%AC\" >6.1. \u521b\u5efa\u4e00\u4e2a\u811a\u672c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#62_%E5%A4%87%E4%BB%BD%E8%84%9A%E6%9C%AC%E5%86%85%E5%AE%B9\" >6.2. \u5907\u4efd\u811a\u672c\u5185\u5bb9<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#63_%E5%B0%86%E8%84%9A%E6%9C%AC%E5%86%85%E5%AE%B9%E5%AD%98%E5%82%A8%E5%88%B0%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\" >6.3. \u5c06\u811a\u672c\u5185\u5bb9\u5b58\u50a8\u5230\u6062\u590d\u76ee\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#64_%E6%9F%A5%E7%9C%8B%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95%E4%B8%AD%E7%9A%84%E8%84%9A%E6%9C%AC%E5%90%8D%E7%A7%B0\" >6.4. \u67e5\u770b\u6062\u590d\u76ee\u5f55\u4e2d\u7684\u811a\u672c\u540d\u79f0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#65_%E6%9F%A5%E7%9C%8B%E8%84%9A%E6%9C%AC%E5%85%B7%E4%BD%93%E5%86%85%E5%AE%B9\" >6.5. \u67e5\u770b\u811a\u672c\u5177\u4f53\u5185\u5bb9<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#66_%E8%BF%90%E8%A1%8C%E8%84%9A%E6%9C%AC\" >6.6. \u8fd0\u884c\u811a\u672c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"http:\/\/dba.qishuo.xin\/?p=849\/#67_%E5%88%A0%E9%99%A4%E8%84%9A%E6%9C%AC\" >6.7. \u5220\u9664\u811a\u672c<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_252dd70202855c109d4a67b944702561.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/09\/wp_editor_md_252dd70202855c109d4a67b944702561.jpg\" alt=\"\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_%E4%BB%80%E4%B9%88%E6%98%AF%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\"><\/span>1. \u4ec0\u4e48\u662f\u6062\u590d\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u6062\u590d\u76ee\u5f55\uff08RMAN Recovery Catalog\uff09\u5b58\u50a8RMAN\u5907\u4efd\u6062\u590d\u76f8\u5173\u4fe1\u606f\u7684\u6570\u636e\u5e93\uff08\u5728\u7269\u7406\u5f62\u5f0f\u4e0a\u53ef\u4ee5\u5bf9\u5e94\u6210Oracle\u4e2d\u7684\u4e00\u4e2aSCHEMA\uff09\u3002\u5f53\u6ca1\u6709\u6062\u590d\u76ee\u5f55\u65f6\uff0cRMAN\u76f8\u5173\u7684\u5907\u4efd\u4fe1\u606f\uff0c\u6bd4\u5982\u5f52\u6863\u6587\u4ef6\u8def\u5f84\u3001\u5907\u4efd\u96c6\u8def\u5f84\u7b49\u5747\u5b58\u50a8\u5728\u76ee\u6807\u6570\u636e\u5e93\u7684\u63a7\u5236\u6587\u4ef6\u4e2d\uff0c\u4e0d\u8fc7\u8003\u8651\u5230\u63a7\u5236\u6587\u4ef6\u5e76\u4e0d\u80fd\u65e0\u9650\u589e\u957f\uff0c\u800c\u4e14\u63a7\u5236\u6587\u4ef6\u4e5f\u4e0d\u4ec5\u4ec5\u662f\u7528\u6765\u5b58\u50a8\u4e0e\u5907\u4efd\u76f8\u5173\u7684\u4fe1\u606f\uff0c\u56e0\u6b64RMAN\u4e5f\u6709\u4e00\u4e2a\u4e13\u95e8\u7684\u5907\u4efd\u4fe1\u606f\u5b58\u50a8\u5730\uff0c\u8fd9\u5c31\u662f\u6062\u590d\u76ee\u5f55\u4e86\uff0c\u5373\uff1a\u76ee\u5f55\u6570\u636e\u5e93\u3002\u5f53\u5f85\u5907\u4efd\u7684\u6570\u636e\u5e93\u6ce8\u518c\u5230\u6062\u590d\u76ee\u5f55\u4e4b\u540e\uff0cRMAN\u76f8\u5173\u7684\u4fe1\u606f\u9664\u4e86\u4fdd\u5b58\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\u5916\uff08\u63a7\u5236\u6587\u4ef6\u5b9e\u9645\u4e0a\u53ea\u4fdd\u5b58\u4e00\u90e8\u5206\uff09\uff0c\u66f4\u52a0\u8be6\u7ec6\u7684\u4fe1\u606f\u5c31\u90fd\u88ab\u5b58\u50a8\u5728\u6062\u590d\u76ee\u5f55\u4e2d\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_%E4%BD%BF%E7%94%A8%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95%E7%9A%84%E4%BC%98%E5%8A%BF\"><\/span>2. \u4f7f\u7528\u6062\u590d\u76ee\u5f55\u7684\u4f18\u52bf<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\u6bd4\u63a7\u5236\u6587\u4ef6\u5b58\u50a8\u66f4\u591a\u989d\u5916\u7684\u5143\u6570\u636e\u5386\u53f2\u8bb0\u5f55<\/li>\n<li>\u5141\u8bb8\u60a8\u4f7f\u7528RMAN\u5b58\u50a8\u811a\u672c<\/li>\n<li>\u5141\u8bb8\u60a8\u4e3a\u6240\u6709\u6ce8\u518c\u76ee\u6807\u521b\u5efa\u81ea\u5b9a\u4e49\u62a5\u544a<\/li>\n<li>\u5141\u8bb8\u60a8\u4f7f\u7528\u5907\u4efd\u547d\u4ee4\u4e2d\u7684\u201c\u6c38\u4e45\u4fdd\u7559\u201d\u5b50\u53e5<\/li>\n<li>\u5141\u8bb8\u60a8\u5217\u51fa\u5728\u67d0\u4e00\u7279\u5b9a\u7684\u65f6\u95f4\u5185\u5b58\u50a8\u4e8e\u76ee\u6807\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e\u6587\u4ef6\u548c\u8868\u7a7a\u95f4\u7684\u5143\u6570\u636e<\/li>\n<li>\u7b80\u5316\u4e86\u7528\u4e8e\u4fdd\u7559RMAN\u5b58\u50a8\u5e93\u5143\u6570\u636e\u7684\u63a7\u5236\u6587\u4ef6\u4e22\u5931\u540e\u7684\u8fd8\u539f\u548c\u6062\u590d<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"3_%E5%A6%82%E4%BD%95%E5%88%9B%E5%BB%BA%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95%EF%BC%9F\"><\/span>3. \u5982\u4f55\u521b\u5efa\u6062\u590d\u76ee\u5f55\uff1f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>\u914d\u7f6e\u6062\u590d\u76ee\u5f55\u6570\u636e\u5e93\u3002<\/li>\n<li>\u521b\u5efa\u8868\u7a7a\u95f4\u4ee5\u5bb9\u7eb3\u5bf9\u8c61\u3002<\/li>\n<li>\u901a\u8fc7recovery_catalog_owner\u521b\u5efa\u6062\u590d\u76ee\u5f55\u6240\u6709\u8005\u89d2\u8272\u3002<\/li>\n<li>\u521b\u5efa\u6062\u590d\u76ee\u5f55\u3002<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"4_%E7%A4%BA%E4%BE%8B\"><\/span>4. \u793a\u4f8b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"41_%E5%88%9B%E5%BB%BA%E4%B8%80%E4%B8%AAPDB%E6%95%B0%E6%8D%AE%E5%BA%93%E4%BD%9C%E4%B8%BA%E7%9B%AE%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>4.1. \u521b\u5efa\u4e00\u4e2aPDB\u6570\u636e\u5e93\u4f5c\u4e3a\u76ee\u5f55\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt; show pdbs;\n\n    CON_ID CON_NAME   OPEN MODE  RESTRICTED\n---------- ----------- ---------- ----------\n  2        PDB$SEED     READ ONLY  NO\n  3        EMCCDB       READ WRITE NO\n\nSQL&gt; create pluggable database catpdb\n     admin user pdbadmin identified by &quot;Hz571!xy00yz&quot; roles=(dba)\n     file_name_convert=(&#039;\/oradata\/CATALOGDB\/pdbseed&#039;,&#039;\/oradata\/CATALOGDB\/catpdb&#039;);\n\nPluggable database created.\n\nSQL&gt; show pdbs;\n\n    CON_ID CON_NAME      OPEN MODE  RESTRICTED\n---------- ----------- ---------- ----------\n   2        PDB$SEED     READ ONLY  NO\n   3        EMCCDB       READ WRITE NO\n   4        CATPDB       MOUNTED\nSQL&gt;\nSQL&gt; alter pluggable database catpdb open;\n\nPluggable database altered.\n\nSQL&gt; alter pluggable database catpdb save state;\n\nPluggable database altered.\n\nSQL&gt; show pdbs;\n\n    CON_ID CON_NAME       OPEN MODE  RESTRICTED\n---------- -------------  ---------- ----------\n     2      PDB$SEED      READ ONLY  NO\n     3      EMCCDB        READ WRITE NO\n     4      CATPDB        READ WRITE NO<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"42_%E5%88%9B%E5%BB%BA%E8%A1%A8%E7%A9%BA%E9%97%B4%E4%B8%8E%E7%94%A8%E6%88%B7%E7%94%A8\"><\/span>4.2. \u521b\u5efa\u8868\u7a7a\u95f4\u4e0e\u7528\u6237\u7528<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt; alter session set container=catpdb;\n\nSession altered.\n\nSQL&gt; create tablespace tbs_cat datafile\n    &#039;\/oradata\/CATALOGDB\/catpdb\/tbs_cat01.dbf&#039; size 1g autoextend on next 500m maxsize 30g,\n    &#039;\/oradata\/CATALOGDB\/catpdb\/tbs_cat02.dbf&#039; size 1g autoextend on next 500m maxsize 30g,\n    &#039;\/oradata\/CATALOGDB\/catpdb\/tbs_cat03.dbf&#039; size 1g autoextend on next 500m maxsize 30g;\n\nTablespace created.\n\nSQL&gt; create user rco identified by &quot;Hz571!xy00yz&quot;\n     default tablespace tbs_cat\n     quota unlimited on tbs_cat;\n\nUser created.\n\nSQL&gt; grant recovery_catalog_owner to rco;\n\nGrant succeeded.\n\nSQL&gt; exit;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"43_%E5%88%9B%E5%BB%BA%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\"><\/span>4.3. \u521b\u5efa\u6062\u590d\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u542f\u52a8 <strong>RMAN<\/strong> \u5e76\u8fd0\u884c\u4ee5\u4e0b RMAN \u547d\u4ee4\u4ee5\u4f5c\u4e3a <strong>rco<\/strong> \u8fde\u63a5\u5230\u6062\u590d\u76ee\u5f55\u6570\u636e\u5e93\u5e76\u521b\u5efa\u6062\u590d\u76ee\u5f55\u3002<\/p>\n<pre><code class=\"language-shell\">~]$ rman catalog &#039;rco\/&quot;Hz571!xy00yz&quot;&#039;@127.0.0.1:1521\/catpdb\n\nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Sep 21 22:51:59 2021\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to recovery catalog database\n\nRMAN&gt; create catalog;\n\nrecovery catalog created<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"5_RMAN%E8%BF%9E%E6%8E%A5%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\"><\/span>5. RMAN\u8fde\u63a5\u6062\u590d\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u524d\u9762\u5df2\u7ecf\u521b\u5efa\u597d\u4e86\u6062\u590d\u76ee\u5f55\uff0c\u5728\u6211\u4eec\u4f7f\u7528RMAN\u8fdb\u884c\u5907\u4efd\u65f6\uff0c\u8981\u8fde\u63a5\u5230\u6062\u590d\u76ee\u5f55\u624d\u80fd\u591f\u8fdb\u884c\u6570\u636e\u5907\u4efd\u3002\u8fde\u63a5\u5230\u6062\u590d\u76ee\u5f55\u7684\u65b9\u5f0f\u4e5f\u662f\u5728\u547d\u4ee4\u884c\u4e0a\u5c31\u53ef\u4ee5\u76f4\u63a5\u64cd\u4f5c\u3002<\/p>\n<p>RMAN\u8fde\u63a5\u6062\u590d\u76ee\u5f55\u8bed\u6cd5\uff1a<\/p>\n<pre><code class=\"language-rman\">rman target user\/password@servicename catalog user\/password@serviecename<\/code><\/pre>\n<p>\u8bed\u6cd5\u89e3\u6790\uff1a<\/p>\n<ul>\n<li>target\u6307\u5b9a\u7684\u662f\u76ee\u6807\u6570\u636e\u5e93\uff08\u65e2\u662f\u8981\u8fdb\u884c\u5907\u4efd\u7684\u6570\u636e\u5e93\uff09\u3002<\/li>\n<li>catalog\u540e\u9762\u6307\u5b9a\u7684\u662f\u6062\u590d\u76ee\u5f55\u7684\u6570\u636e\u5e93\u3002<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"51_%E5%B0%86%E7%9B%AE%E6%A0%87%E6%95%B0%E6%8D%AE%E5%BA%93%E6%B3%A8%E5%86%8C%E5%88%B0%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\"><\/span>5.1. \u5c06\u76ee\u6807\u6570\u636e\u5e93\u6ce8\u518c\u5230\u6062\u590d\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5c06\u76ee\u6807\u6570\u636e\u5e93\uff08\u5373\u8981\u6267\u884c\u5907\u4efd\u7684\u6570\u636e\u5e93\uff09\u6ce8\u518c\u5230\u76ee\u5f55\u6570\u636e\u5e93\u6709\u4e24\u79cd\u8fde\u63a5\u65b9\u5f0f\uff0c<\/p>\n<ul>\n<li>\u65b9\u5f0f\u4e00\u3001\u4ece\u6062\u590d\u76ee\u5f55\u8fde\u63a5\u76ee\u6807\u6570\u636e\u5e93<br \/>\n\u9996\u5148\u5728\u76ee\u6807\u6570\u636e\u8ba9\u521b\u5efa\u4e00\u4e2a\u5177\u6709sysbackup\u6743\u9650\u7684\u7528\u6237\uff0c\u7528\u4e8e\u5907\u4efd\u6574\u4e2aCDB\u4ee5\u53ca\u5176\u4ed6\u6240\u6709PDB\u6570\u636e\u5e93\u3002<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SQL&gt; show con_name;\n\nCON_NAME\n------------------------------\nCDB$ROOT\nSQL&gt;\nSQL&gt; create user c##backup identified by &quot;Hz571!xy00yz&quot;;\n\nUser created.\n\nSQL&gt; grant sysbackup,create session to c##backup;\n\nGrant succeeded.<\/code><\/pre>\n<p>\u5907\u4efd\u6574\u4e2aCDB\u6570\u636e\u5e93\u53ca\u5176\u4e0b\u9762\u7684\u6240\u6709PDB\u7c7b\u4f3c\u4e8e\u975eCDB\u6570\u636e\u5e93\u65b9\u6cd5\u76f8\u540c\uff0c\u4f7f\u7528\u5177\u6709SYSDBA\u6216SYSBACKUP\u6743\u9650\u7528\u6237\u8fde\u63a5\u5230CDB\u7684root\u73af\u5883\u4e0b\u9762\uff0c\u7136\u540e\u6267\u884c <code>backup database<\/code> \u547d\u4ee4\u5373\u53ef\u5b8c\u6210\u6574\u4e2aCDB\u7684\u5907\u4efd\u3002<\/p>\n<pre><code class=\"language-shell\">~]$  rman target &#039;&quot;c##backup\/Hz571!xy00yz@172.16.xxx.xxx:1521\/xxxdb as sysbackup&quot;&#039;  catalog &#039;rco\/&quot;Hz571!xy00yz&quot;&#039;@172.16.xxx.xxx:1521\/catpdb\n\nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Sep 21 23:42:53 2021\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: XXXDB (DBID=4267076118)\nconnected to recovery catalog database<\/code><\/pre>\n<ul>\n<li>\u65b9\u5f0f\u4e8c\u3001\u4ece\u76ee\u6807\u6570\u636e\u5e93\u8fde\u63a5\u6062\u590d\u76ee\u5f55<\/li>\n<\/ul>\n<pre><code class=\"language-shell\">~]$ rman target \/ catalog &#039;rco\/&quot;Hz571!xy00yz&quot;&#039;@172.16.xxx.xxx:1521\/catpdb\n\nRecovery Manager: Release 19.0.0.0.0 - Production on Tue Sep 21 23:01:37 2021\nVersion 19.10.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: xxxDB (DBID=4267076118)\nconnected to recovery catalog database\nPL\/SQL package RCO.DBMS_RCVCAT version 19.03.00.00. in RCVCAT database is not current\nPL\/SQL package RCO.DBMS_RCVMAN version 19.03.00.00 in RCVCAT database is not current<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"52_%E5%9C%A8%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95%E4%B8%8A%E6%B3%A8%E5%86%8C%E7%9B%AE%E6%A0%87%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>5.2. \u5728\u6062\u590d\u76ee\u5f55\u4e0a\u6ce8\u518c\u76ee\u6807\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-rman\">RMAN&gt; register database;\n\ndatabase registered in recovery catalog\nstarting full resync of recovery catalog\nfull resync complete<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"53_%E5%90%8C%E6%AD%A5%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE\"><\/span>5.3. \u540c\u6b65\u5907\u4efd\u6570\u636e<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u5728\u540c\u65f6\u8fde\u63a5\u5230\u76ee\u6807db\u548ccatalog\u6267\u884crman\u547d\u4ee4\u65f6\uff0c\u4e0d\u8bba\u662f\u5c40\u90e8\u540c\u6b65\u8fd8\u662f\u5168\u5c40\u540c\u6b65\uff0c\u540c\u6b65\u64cd\u4f5c\u90fd\u80fd\u591f\u7531rman\u6267\u884c\u76f8\u5173\u547d\u4ee4\uff08backup\u3001configure\uff09\u65f6\u81ea\u52a8\u5224\u65ad\u3001\u81ea\u52a8\u53d1\u8d77\u3002\u5b8c\u5168\u540c\u6b65\u4e5f\u53ef\u4ee5\u901a\u8fc7 <code>resync catalog<\/code> \u624b\u52a8\u53d1\u8d77\uff0c\u4e00\u822c\u6ca1\u6709\u5fc5\u8981\u8fd9\u6837\u505a\uff0c\u4f46\u4ee5\u4e0b3\u79cd\u60c5\u51b5\u9664\u5916<\/p>\n<ol>\n<li>\u4f7f\u7528rman\u6267\u884c\u4e86\u9700\u8981\u540c\u6b65\u7684\u64cd\u4f5c\uff08\u6bd4\u5982configure\u547d\u4ee4\u5907\u4efd\u67d0\u4e2a\u8868\u7a7a\u95f4\uff09\uff0c\u4f46\u662f\u5728\u6267\u884c\u6b64\u7c7b\u547d\u4ee4\u65f6\u7531\u4e8e\u79cd\u79cd\u539f\u56e0rman\u6ca1\u6709\u8fde\u63a5catalog\uff0c\u53ea\u8fde\u63a5\u4e86\u76ee\u6807db<\/li>\n<li>dba\u5907\u4efddb\u7684\u9891\u7387\u8fc7\u4f4e\uff0c\u5f88\u4e45\u4e0d\u7528\u4e00\u6b21rman\uff0c\u8fd9\u6837\uff0c\u7531\u4e8econtrol_file_record_keep_time\u53c2\u6570\u7684\u8bbe\u7f6e\uff0ccatalog\u53ef\u80fd\u4f1a\u9057\u5fd8\u67d0\u4e9b\u5f52\u6863\u65e5\u5fd7\u4fe1\u606f<\/li>\n<li>\u5728db\u7269\u7406\u7ed3\u6784\u53d1\u751f\u53d8\u5316\u4e4b\u540e\uff0c\u6bd4\u5982\uff1a\u6dfb\u52a0\u6570\u636e\u6587\u4ef6\uff0c\u65b0\u5efa\u8868\u7a7a\u95f4\u7b49<\/li>\n<\/ol>\n<pre><code class=\"language-rman\">RMAN&gt; resync catalog;\n\nstarting full resync of recovery catalog\nfull resync complete<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"6_%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>6. \u5907\u4efd\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"61_%E5%88%9B%E5%BB%BA%E4%B8%80%E4%B8%AA%E8%84%9A%E6%9C%AC\"><\/span>6.1. \u521b\u5efa\u4e00\u4e2a\u811a\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-rman\">create script bak_0{\n  crosscheck backup;\n  crosscheck archivelog all;\n  allocate channel c1 type disk maxpiecesize = 200000m;\n  sql &#039;alter system archive log current&#039;;\n  backup incremental level 0 skip inaccessible database tag &#039;inc_0&#039; format &#039;\/oralce\/ora_rman\/bak_0%p_%s_%t.bak&#039; filesperset 4\n  include current controlfile plus archivelog tag &#039;arc_0&#039; format &#039;\/oracle\/ora_rman\/bak_arc%U.bak&#039; filesperset 2\n  delete all input;\n  delete obsolete;\n  release channel c1;\n}<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"62_%E5%A4%87%E4%BB%BD%E8%84%9A%E6%9C%AC%E5%86%85%E5%AE%B9\"><\/span>6.2. \u5907\u4efd\u811a\u672c\u5185\u5bb9<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-rman\">~]# cat dbfullbak.rman\nCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#039;+DATAC1&#039;;\nCONFIGURE DEVICE TYPE DISK PARALLELISM 12 BACKUP TYPE TO BACKUPSET;\nrun {\nbackup full  tag &#039;db_full_bak&#039; format &#039;+DATAC1&#039; database;\nsql &#039;alter system archive log current&#039;;\nbackup format &#039;+DATAC1&#039; archivelog all ;\ndelete noprompt  obsolete;\ndelete noprompt expired backup;\n}<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"63_%E5%B0%86%E8%84%9A%E6%9C%AC%E5%86%85%E5%AE%B9%E5%AD%98%E5%82%A8%E5%88%B0%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95\"><\/span>6.3. \u5c06\u811a\u672c\u5185\u5bb9\u5b58\u50a8\u5230\u6062\u590d\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-rman\">RMAN&gt; create script backup_exadata from file &#039;\/dbData\/OracleBack\/rmanbak\/dbfullbak.rman&#039;;\n\nscript commands will be loaded from file \/dbData\/OracleBack\/rmanbak\/dbfullbak.rman\ncreated script backup_exadata<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"64_%E6%9F%A5%E7%9C%8B%E6%81%A2%E5%A4%8D%E7%9B%AE%E5%BD%95%E4%B8%AD%E7%9A%84%E8%84%9A%E6%9C%AC%E5%90%8D%E7%A7%B0\"><\/span>6.4. \u67e5\u770b\u6062\u590d\u76ee\u5f55\u4e2d\u7684\u811a\u672c\u540d\u79f0<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-rman\">RMAN&gt; list script names;\n\nList of Stored Scripts in Recovery Catalog\n\n    Scripts of Target Database XXXDB\n\n       Script Name\n       Description\n       -----------------------------------------------------------------------\n       backup_exadata<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"65_%E6%9F%A5%E7%9C%8B%E8%84%9A%E6%9C%AC%E5%85%B7%E4%BD%93%E5%86%85%E5%AE%B9\"><\/span>6.5. \u67e5\u770b\u811a\u672c\u5177\u4f53\u5185\u5bb9<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-rman\">RMAN&gt; print script backup_exadata;\n\nprinting stored script: backup_exadata\nCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#039;+DATAC1&#039;;\nCONFIGURE DEVICE TYPE DISK PARALLELISM 12 BACKUP TYPE TO BACKUPSET;\nrun {\nbackup full  tag &#039;db_full_bak&#039; format &#039;+DATAC1&#039; database;\nsql &#039;alter system archive log current&#039;;\nbackup format &#039;+DATAC1&#039; archivelog all ;\ndelete noprompt  obsolete;\ndelete noprompt expired backup;\n}<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"66_%E8%BF%90%E8%A1%8C%E8%84%9A%E6%9C%AC\"><\/span>6.6. \u8fd0\u884c\u811a\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u4f7f\u7528rman\u8fde\u63a5\u76ee\u6807\u5e93\u548ccatalog\u540e\uff0c\u6267\u884crun {execute script ...}<\/p>\n<pre><code class=\"language-rman\">RMAN&gt; run {execute script backup_exadata;}<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"67_%E5%88%A0%E9%99%A4%E8%84%9A%E6%9C%AC\"><\/span>6.7. \u5220\u9664\u811a\u672c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-rman\">RMAN&gt; DELETE SCRIPT backup_exadata;\n\ndeleted script: backup_exadata<\/code><\/pre>\n<p>\u53c2\u8003\uff1aOracle\u5b98\u65b9\u6587\u6863\uff1a<br \/>\n<a target=\"_blank\" href=\"https:\/\/docs.oracle.com\/cd\/B12037_01\/server.101\/b10770\/toc.htm\" title=\"https:\/\/docs.oracle.com\/cd\/B12037_01\/server.101\/b10770\/toc.htm\">https:\/\/docs.oracle.com\/cd\/B12037_01\/server.101\/b10770\/toc.htm<\/a><br \/>\n<a target=\"_blank\" href=\"https:\/\/www.cnblogs.com\/yhq1314\/p\/11040852.html\" title=\"https:\/\/www.cnblogs.com\/yhq1314\/p\/11040852.html\">https:\/\/www.cnblogs.com\/yhq1314\/p\/11040852.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \u4ec0\u4e48\u662f\u6062\u590d\u76ee\u5f55 \u6062\u590d\u76ee\u5f55\uff08RMAN Reco&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,120],"class_list":{"0":"post-849","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-oracle","8":"tag-oracle","9":"tag-rman","10":"tag-120"},"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/849","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=849"}],"version-history":[{"count":19,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/849\/revisions"}],"predecessor-version":[{"id":3423,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/849\/revisions\/3423"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=849"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}