{"id":3370,"date":"2023-10-19T00:52:53","date_gmt":"2023-10-18T16:52:53","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=3370"},"modified":"2023-10-30T14:53:02","modified_gmt":"2023-10-30T06:53:02","slug":"oracle%e6%95%b0%e6%8d%ae%e5%ba%93%e8%bf%81%e7%a7%bb%e6%95%b0%e6%8d%ae%e6%96%87%e4%bb%b6%e3%80%81%e6%97%a5%e5%bf%97%e6%96%87%e4%bb%b6%e4%bb%a5%e5%8f%8a%e6%8e%a7%e5%88%b6%e6%96%87%e4%bb%b6","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=3370","title":{"rendered":"Oracle\u6570\u636e\u5e93\u8fc1\u79fb\u6570\u636e\u6587\u4ef6\u3001\u65e5\u5fd7\u6587\u4ef6\u4ee5\u53ca\u63a7\u5236\u6587\u4ef6"},"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-6a020c8c0a30a\" 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-6a020c8c0a30a\" 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=3370\/#%E7%8E%AF%E5%A2%83\" >\u73af\u5883<\/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=3370\/#%E6%AD%A5%E9%AA%A41_%E5%85%88%E6%9F%A5%E7%9C%8B%E5%90%84%E7%B1%BB%E6%96%87%E4%BB%B6%E6%89%80%E5%9C%A8%E7%9A%84%E7%A3%81%E7%9B%98%E4%BD%8D%E7%BD%AE\" >\u6b65\u9aa41. \u5148\u67e5\u770b\u5404\u7c7b\u6587\u4ef6\u6240\u5728\u7684\u78c1\u76d8\u4f4d\u7f6e<\/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=3370\/#11_%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\" >1.1. \u6570\u636e\u6587\u4ef6<\/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=3370\/#12_%E8%81%94%E6%9C%BA%E9%87%8D%E5%81%9A%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6\" >1.2. \u8054\u673a\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=3370\/#13_%E4%B8%B4%E6%97%B6%E6%96%87%E4%BB%B6\" >1.3. \u4e34\u65f6\u6587\u4ef6<\/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=3370\/#14_%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6\" >1.4. \u63a7\u5236\u6587\u4ef6<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/dba.qishuo.xin\/?p=3370\/#%E6%AD%A5%E9%AA%A42_%E5%88%9B%E5%BB%BA%E4%B8%80%E4%B8%AApfile\" >\u6b65\u9aa42. \u521b\u5efa\u4e00\u4e2apfile<\/a><\/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=3370\/#%E6%AD%A5%E9%AA%A43_%E6%AD%A3%E5%B8%B8%E5%85%B3%E9%97%AD%E6%95%B0%E6%8D%AE%E5%BA%93\" >\u6b65\u9aa43. \u6b63\u5e38\u5173\u95ed\u6570\u636e\u5e93<\/a><\/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=3370\/#%E6%AD%A5%E9%AA%A44_%E5%B0%86%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6%E3%80%81%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6%E3%80%81%E4%B8%B4%E6%97%B6%E6%96%87%E4%BB%B6%E3%80%81%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6%E9%83%BD%E6%8B%B7%E8%B4%9D%E5%88%B0%E6%96%B0%E7%9A%84%E7%9B%AE%E5%BD%95%E4%B8%AD\" >\u6b65\u9aa44. \u5c06\u6570\u636e\u6587\u4ef6\u3001\u65e5\u5fd7\u6587\u4ef6\u3001\u4e34\u65f6\u6587\u4ef6\u3001\u63a7\u5236\u6587\u4ef6\u90fd\u62f7\u8d1d\u5230\u65b0\u7684\u76ee\u5f55\u4e2d<\/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=3370\/#41_%E5%B0%86%E6%97%A7%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95%E6%8B%B7%E8%B4%9D%E5%88%B0%E6%96%B0%E7%9A%84%E7%9B%AE%E5%BD%95\" >4.1. \u5c06\u65e7\u6587\u4ef6\u76ee\u5f55\u62f7\u8d1d\u5230\u65b0\u7684\u76ee\u5f55<\/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=3370\/#42_%E5%B0%86%E6%97%A7%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95%E9%87%8D%E5%91%BD%E5%90%8D\" >4.2. \u5c06\u65e7\u6587\u4ef6\u76ee\u5f55\u91cd\u547d\u540d<\/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=3370\/#%E6%AD%A5%E9%AA%A45_%E4%BF%AE%E6%94%B9%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6%E4%BD%8D%E7%BD%AE%E5%B9%B6%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E5%88%B0mount%E7%8A%B6%E6%80%81\" >\u6b65\u9aa45. \u4fee\u6539\u63a7\u5236\u6587\u4ef6\u4f4d\u7f6e\u5e76\u542f\u52a8\u6570\u636e\u5e93\u5230mount\u72b6\u6001<\/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=3370\/#51_%E4%BF%AE%E6%94%B9%E6%AD%A5%E9%AA%A42%E7%94%9F%E6%88%90%E7%9A%84pfile%E6%96%87%E4%BB%B6%E4%B8%AD%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6%E7%9A%84%E4%BD%8D%E7%BD%AE\" >5.1. \u4fee\u6539\u6b65\u9aa42\u751f\u6210\u7684pfile\u6587\u4ef6\u4e2d\u63a7\u5236\u6587\u4ef6\u7684\u4f4d\u7f6e<\/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=3370\/#52_%E9%80%9A%E8%BF%87pfile%E5%90%AF%E5%8A%A8%E5%88%B0mount%E7%8A%B6%E6%80%81\" >5.2. \u901a\u8fc7pfile\u542f\u52a8\u5230mount\u72b6\u6001<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"http:\/\/dba.qishuo.xin\/?p=3370\/#%E6%AD%A5%E9%AA%A46_%E4%BF%AE%E6%94%B9%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%90%84%E4%B8%AA%E6%96%87%E4%BB%B6%E7%9A%84%E4%BD%8D%E7%BD%AE\" >\u6b65\u9aa46. \u4fee\u6539\u6570\u636e\u5e93\u4e2d\u5404\u4e2a\u6587\u4ef6\u7684\u4f4d\u7f6e<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"http:\/\/dba.qishuo.xin\/?p=3370\/#61_%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\" >6.1. \u6570\u636e\u6587\u4ef6<\/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=3370\/#62_%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6\" >6.2. \u65e5\u5fd7\u6587\u4ef6<\/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=3370\/#63_%E4%B8%B4%E6%97%B6%E6%96%87%E4%BB%B6\" >6.3. \u4e34\u65f6\u6587\u4ef6<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"http:\/\/dba.qishuo.xin\/?p=3370\/#7_%E5%88%9B%E5%BB%BA%E6%96%B0%E7%9A%84spfile%E5%B9%B6%E9%87%8D%E6%96%B0%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93\" >7. \u521b\u5efa\u65b0\u7684spfile,\u5e76\u91cd\u65b0\u542f\u52a8\u6570\u636e\u5e93<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"http:\/\/dba.qishuo.xin\/?p=3370\/#8_%E6%97%A5%E5%BF%97%E5%88%87%E6%8D%A2%E6%97%A0%E6%B3%95%E5%AE%8C%E6%88%90\" >8. \u65e5\u5fd7\u5207\u6362\u65e0\u6cd5\u5b8c\u6210<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"http:\/\/dba.qishuo.xin\/?p=3370\/#%E9%99%84%E5%BD%95\" >\u9644\u5f55<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"http:\/\/dba.qishuo.xin\/?p=3370\/#%E9%99%84%E5%BD%95A%EF%BC%9A%E5%8F%82%E8%80%83%E6%96%87%E6%A1%A3\" >\u9644\u5f55A\uff1a\u53c2\u8003\u6587\u6863<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"%E7%8E%AF%E5%A2%83\"><\/span>\u73af\u5883<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u64cd\u4f5c\u7cfb\u7edf\uff1aCentOS Linux release 7.9.2009 (Core)<br \/>\n\u6570\u636e\u5e93\uff1aOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production<br \/>\nVersion 19.3.0.0.0\uff08\u975e\u5bb9\u5668\u6570\u636e\u5e93\uff0c\u975eASM\u6587\u4ef6\u7ba1\u7406\uff09<br \/>\n\u65e7\u6587\u4ef6\u76ee\u5f55\uff1a\/oradata\/<br \/>\n\u65b0\u6587\u4ef6\u76ee\u5f55\uff1a\/home\/oradata\/<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A41_%E5%85%88%E6%9F%A5%E7%9C%8B%E5%90%84%E7%B1%BB%E6%96%87%E4%BB%B6%E6%89%80%E5%9C%A8%E7%9A%84%E7%A3%81%E7%9B%98%E4%BD%8D%E7%BD%AE\"><\/span>\u6b65\u9aa41. \u5148\u67e5\u770b\u5404\u7c7b\u6587\u4ef6\u6240\u5728\u7684\u78c1\u76d8\u4f4d\u7f6e<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"11_%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\"><\/span>1.1. \u6570\u636e\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<p>\u67e5\u770b\u78c1\u76d8\u4f4d\u7f6e<\/p>\n<pre><code class=\"language-sql\">SELECT *\nFROM dba_data_files;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697638908571.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697638908571.png\" alt=\"file\" \/><\/a><\/p>\n<\/li>\n<li>\n<p>\u751f\u6210\u6570\u636e\u6587\u4ef6\u540d\u66f4\u6362\u7684SQL\u8bed\u53e5<\/p>\n<pre><code class=\"language-sql\">SELECT &#039;ALTER DATABASE RENAME FILE &#039;&#039;&#039; ||\n   a.FILE_NAME || &#039;&#039;&#039; TO &#039;&#039;&#039; ||\n   &#039;\/home&#039; || a.FILE_NAME || &#039;&#039;&#039;;&#039;\nFROM dba_data_files a;<\/code><\/pre>\n<\/li>\n<li>\n<p>\u8fc1\u79fb\u8bed\u53e5\u793a\u4f8b<\/p>\n<pre><code class=\"language-sql\">ALTER DATABASE RENAME FILE &#039;\/oradata\/xxxx\/system01.dbf&#039; TO &#039;\/home\/oradata\/xxxx\/system01.dbf&#039;;\nALTER DATABASE RENAME FILE &#039;\/oradata\/xxxx\/sysaux01.dbf&#039; TO &#039;\/home\/oradata\/xxxx\/sysaux01.dbf&#039;;\nALTER DATABASE RENAME FILE &#039;\/oradata\/xxxx\/undotbs01.dbf&#039; TO &#039;\/home\/oradata\/xxxx\/undotbs01.dbf&#039;;\nALTER DATABASE RENAME FILE &#039;\/oradata\/xxxx\/users01.dbf&#039; TO &#039;\/home\/oradata\/xxxx\/users01.dbf&#039;;<\/code><\/pre>\n<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"12_%E8%81%94%E6%9C%BA%E9%87%8D%E5%81%9A%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6\"><\/span>1.2. \u8054\u673a\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<p>\u67e5\u770b\u78c1\u76d8\u4f4d\u7f6e<\/p>\n<pre><code class=\"language-sql\">SELECT *\nFROM v$logfile;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697640698637.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697640698637.png\" alt=\"file\" \/><\/a><\/p>\n<\/li>\n<li>\n<p>\u751f\u6210\u6570\u636e\u6587\u4ef6\u540d\u66f4\u6362\u7684SQL\u8bed\u53e5<\/p>\n<pre><code class=\"language-sql\">SELECT &#039;ALTER DATABASE RENAME FILE &#039;&#039;&#039; ||\n   a.MEMBER || &#039;&#039;&#039; TO &#039;&#039;&#039; ||\n   &#039;\/home&#039; || a.MEMBER || &#039;&#039;&#039;;&#039;\nFROM v$logfile a;<\/code><\/pre>\n<\/li>\n<li>\n<p>\u8fc1\u79fb\u8bed\u53e5\u793a\u4f8b<\/p>\n<pre><code class=\"language-sql\">ALTER DATABASE RENAME FILE &#039;\/oradata\/xxxx\/redo03.log&#039; TO &#039;\/home\/oradata\/xxxx\/redo03.log&#039;;\nALTER DATABASE RENAME FILE &#039;\/oradata\/xxxx\/redo02.log&#039; TO &#039;\/home\/oradata\/xxxx\/redo02.log&#039;;\nALTER DATABASE RENAME FILE &#039;\/oradata\/xxxx\/redo01.log&#039; TO &#039;\/home\/oradata\/xxxx\/redo01.log&#039;;<\/code><\/pre>\n<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"13_%E4%B8%B4%E6%97%B6%E6%96%87%E4%BB%B6\"><\/span>1.3. \u4e34\u65f6\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<p>\u67e5\u770b\u78c1\u76d8\u4f4d\u7f6e<\/p>\n<pre><code class=\"language-sql\">SELECT *\nFROM dba_temp_files;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641013760.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641013760.png\" alt=\"file\" \/><\/a><\/p>\n<\/li>\n<li>\n<p>\u751f\u6210\u4e34\u65f6\u6587\u4ef6\u540d\u66f4\u6362\u7684SQL\u8bed\u53e5<\/p>\n<pre><code class=\"language-sql\">SELECT &#039;ALTER DATABASE RENAME FILE &#039;&#039;&#039; ||\n   a.file_name || &#039;&#039;&#039; TO &#039;&#039;&#039; ||\n   &#039;\/home&#039; || a.file_name || &#039;&#039;&#039;;&#039;\nFROM dba_temp_files a;<\/code><\/pre>\n<\/li>\n<li>\n<p>\u793a\u4f8b<\/p>\n<pre><code class=\"language-sql\">ALTER DATABASE RENAME FILE &#039;\/oradata\/xxxx\/mypdb\/ET_TEMP.dbf&#039; TO &#039;\/home\/oradata\/xxxx\/mypdb\/ET_TEMP.dbf&#039;;\nALTER DATABASE RENAME FILE &#039;\/oradata\/xxxx\/temp01.dbf&#039; TO &#039;\/home\/oradata\/xxxx\/temp01.dbf&#039;;<\/code><\/pre>\n<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"14_%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6\"><\/span>1.4. \u63a7\u5236\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\u67e5\u770b\u78c1\u76d8\u4f4d\u7f6e\n<pre><code class=\"language-sql\">SELECT *\nFROM v$controlfile;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641426373.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641426373.png\" alt=\"file\" \/><\/a><\/p>\n<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A42_%E5%88%9B%E5%BB%BA%E4%B8%80%E4%B8%AApfile\"><\/span>\u6b65\u9aa42. \u521b\u5efa\u4e00\u4e2apfile<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<pre><code class=\"language-sql\">SQL&gt; create pfile from spfile;<\/code><\/pre>\n<p>\u5728\u76ee\u5f55 <code>$ORACLE_HOME\/dbs<\/code>\u4e2d\u67e5\u770b init+\u5b9e\u4f8b\u540d\u7684\u6587\u4ef6\u3002<br \/>\n<a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641636340.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641636340.png\" alt=\"file\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A43_%E6%AD%A3%E5%B8%B8%E5%85%B3%E9%97%AD%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>\u6b65\u9aa43. \u6b63\u5e38\u5173\u95ed\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<pre><code class=\"language-sql\">SQL&gt; shu immediate;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641670281.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641670281.png\" alt=\"file\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A44_%E5%B0%86%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6%E3%80%81%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6%E3%80%81%E4%B8%B4%E6%97%B6%E6%96%87%E4%BB%B6%E3%80%81%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6%E9%83%BD%E6%8B%B7%E8%B4%9D%E5%88%B0%E6%96%B0%E7%9A%84%E7%9B%AE%E5%BD%95%E4%B8%AD\"><\/span>\u6b65\u9aa44. \u5c06\u6570\u636e\u6587\u4ef6\u3001\u65e5\u5fd7\u6587\u4ef6\u3001\u4e34\u65f6\u6587\u4ef6\u3001\u63a7\u5236\u6587\u4ef6\u90fd\u62f7\u8d1d\u5230\u65b0\u7684\u76ee\u5f55\u4e2d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style='color:red'>\u6ce8\u610f\uff1a\u662f\u62f7\u8d1d\u6587\u4ef6\uff0c\u4e0d\u662fmv,\u9632\u6b62\u79fb\u52a8\u6587\u4ef6\u65f6\u51fa\u9519\uff01<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"41_%E5%B0%86%E6%97%A7%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95%E6%8B%B7%E8%B4%9D%E5%88%B0%E6%96%B0%E7%9A%84%E7%9B%AE%E5%BD%95\"><\/span>4.1. \u5c06\u65e7\u6587\u4ef6\u76ee\u5f55\u62f7\u8d1d\u5230\u65b0\u7684\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">~]# cp -r \/oradata \/home\/\n~]# chown -R oracle:oinstall \/home\/oradata<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697642470269.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697642470269.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"42_%E5%B0%86%E6%97%A7%E6%96%87%E4%BB%B6%E7%9B%AE%E5%BD%95%E9%87%8D%E5%91%BD%E5%90%8D\"><\/span>4.2. \u5c06\u65e7\u6587\u4ef6\u76ee\u5f55\u91cd\u547d\u540d<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-shell\">~]# mv \/oradata \/oradataBak<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A45_%E4%BF%AE%E6%94%B9%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6%E4%BD%8D%E7%BD%AE%E5%B9%B6%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93%E5%88%B0mount%E7%8A%B6%E6%80%81\"><\/span>\u6b65\u9aa45. \u4fee\u6539\u63a7\u5236\u6587\u4ef6\u4f4d\u7f6e\u5e76\u542f\u52a8\u6570\u636e\u5e93\u5230mount\u72b6\u6001<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"51_%E4%BF%AE%E6%94%B9%E6%AD%A5%E9%AA%A42%E7%94%9F%E6%88%90%E7%9A%84pfile%E6%96%87%E4%BB%B6%E4%B8%AD%E6%8E%A7%E5%88%B6%E6%96%87%E4%BB%B6%E7%9A%84%E4%BD%8D%E7%BD%AE\"><\/span>5.1. \u4fee\u6539\u6b65\u9aa42\u751f\u6210\u7684pfile\u6587\u4ef6\u4e2d\u63a7\u5236\u6587\u4ef6\u7684\u4f4d\u7f6e<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641806903.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697641806903.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"52_%E9%80%9A%E8%BF%87pfile%E5%90%AF%E5%8A%A8%E5%88%B0mount%E7%8A%B6%E6%80%81\"><\/span>5.2. \u901a\u8fc7pfile\u542f\u52a8\u5230mount\u72b6\u6001<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<pre><code class=\"language-sql\">SQL&gt; startup pfile=&#039;\/u01\/app\/oracle\/product\/19.3.0\/dbhome_1\/dbs\/initxxxx.ora&#039; mount;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697642703978.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697642703978.png\" alt=\"file\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E6%AD%A5%E9%AA%A46_%E4%BF%AE%E6%94%B9%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%90%84%E4%B8%AA%E6%96%87%E4%BB%B6%E7%9A%84%E4%BD%8D%E7%BD%AE\"><\/span>\u6b65\u9aa46. \u4fee\u6539\u6570\u636e\u5e93\u4e2d\u5404\u4e2a\u6587\u4ef6\u7684\u4f4d\u7f6e<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"61_%E6%95%B0%E6%8D%AE%E6%96%87%E4%BB%B6\"><\/span>6.1. \u6570\u636e\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u793a\u4f8b\uff1a<br \/>\n<a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697643189147.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697643189147.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"62_%E6%97%A5%E5%BF%97%E6%96%87%E4%BB%B6\"><\/span>6.2. \u65e5\u5fd7\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u793a\u4f8b\uff1a<br \/>\n<a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697643241090.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697643241090.png\" alt=\"file\" \/><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"63_%E4%B8%B4%E6%97%B6%E6%96%87%E4%BB%B6\"><\/span>6.3. \u4e34\u65f6\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u793a\u4f8b\uff1a<br \/>\n<a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697643283783.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697643283783.png\" alt=\"file\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_%E5%88%9B%E5%BB%BA%E6%96%B0%E7%9A%84spfile%E5%B9%B6%E9%87%8D%E6%96%B0%E5%90%AF%E5%8A%A8%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>7. \u521b\u5efa\u65b0\u7684spfile,\u5e76\u91cd\u65b0\u542f\u52a8\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<pre><code class=\"language-sql\">SQL&gt; create spfile from pfile;\nSQL&gt; shu immediate;\nSQL&gt; startup;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697643645711.png\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2023\/10\/image-1697643645711.png\" alt=\"file\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_%E6%97%A5%E5%BF%97%E5%88%87%E6%8D%A2%E6%97%A0%E6%B3%95%E5%AE%8C%E6%88%90\"><\/span>8. \u65e5\u5fd7\u5207\u6362\u65e0\u6cd5\u5b8c\u6210<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\n<p>\u65b0\u5efa\u4e86\u4e00\u7ec4\u65e5\u5fd7<\/p>\n<pre><code class=\"language-sql\">SQL&gt; alter database add logfile member &#039;\/home\/oradata\/xxxx\/redo01_1.log&#039; to group 1;\nSQL&gt; alter database add logfile member &#039;\/home\/oradata\/xxxx\/redo02_1.log&#039; to group 2;\nSQL&gt; alter database add logfile member &#039;\/home\/oradata\/xxxx\/redo03_1.log&#039; to group 3;<\/code><\/pre>\n<\/li>\n<li>\n<p>\u5220\u9664\u4e86\u65e7\u7684\u65e5\u5fd7<\/p>\n<pre><code class=\"language-sql\">SQL&gt; alter database drop logfile member &#039;\/home\/oradata\/xxxx\/redo01.log&#039;;\nSQL&gt; alter database drop logfile member &#039;\/home\/oradata\/xxxx\/redo02.log&#039;;\nSQL&gt; alter database drop logfile member &#039;\/home\/oradata\/xxxx\/redo03.log&#039;;<\/code><\/pre>\n<\/li>\n<li>\n<p>\u67e5\u770b\u65e5\u5fd7\u6587\u4ef6<\/p>\n<pre><code class=\"language-sql\">SQL&gt; select group#,member from v$logfile;<\/code><\/pre>\n<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"%E9%99%84%E5%BD%95\"><\/span>\u9644\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"%E9%99%84%E5%BD%95A%EF%BC%9A%E5%8F%82%E8%80%83%E6%96%87%E6%A1%A3\"><\/span>\u9644\u5f55A\uff1a\u53c2\u8003\u6587\u6863<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u6f47\u6e58\u9690\u8005 - <a target=\"_blank\" href=\"https:\/\/www.cnblogs.com\/kerrycode\/p\/3675944.html\" title=\"ORACLE \u79fb\u52a8\u6570\u636e\u6587\u4ef6 \u63a7\u5236\u6587\u4ef6 \u91cd\u505a\u65e5\u5fd7\u6587\u4ef6\">ORACLE \u79fb\u52a8\u6570\u636e\u6587\u4ef6 \u63a7\u5236\u6587\u4ef6 \u91cd\u505a\u65e5\u5fd7\u6587\u4ef6<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u73af\u5883 \u64cd\u4f5c\u7cfb\u7edf\uff1aCentOS Linux rele&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":[],"class_list":["post-3370","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/3370","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=3370"}],"version-history":[{"count":29,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/3370\/revisions"}],"predecessor-version":[{"id":3440,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/3370\/revisions\/3440"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3370"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}