{"id":243,"date":"2021-07-26T14:35:00","date_gmt":"2021-07-26T06:35:00","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=243"},"modified":"2021-08-01T17:10:46","modified_gmt":"2021-08-01T09:10:46","slug":"ora-01210-data-file-header-is-media-corrupt","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=243","title":{"rendered":"ORA-01210: data file header is media corrupt"},"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-69fea6614726f\" 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-69fea6614726f\" 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=243\/#1_%E6%95%85%E9%9A%9C%E7%8E%B0%E8%B1%A1\" >1. \u6545\u969c\u73b0\u8c61<\/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=243\/#2_%E9%97%AE%E9%A2%98%E5%8E%9F%E5%9B%A0\" >2. \u95ee\u9898\u539f\u56e0<\/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=243\/#3_%E8%A7%A3%E5%86%B3%E6%80%9D%E8%B7%AF\" >3. \u89e3\u51b3\u601d\u8def<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=243\/#31_%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9C%89%E5%A4%87%E4%BB%BD%E4%B8%8E%E5%BD%92%E6%A1%A3%E6%97%B6\" >3.1. \u6570\u636e\u5e93\u6709\u5907\u4efd\u4e0e\u5f52\u6863\u65f6<\/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=243\/#32_%E6%95%B0%E6%8D%AE%E5%BA%93%E6%97%A0%E5%A4%87%E4%BB%BD%E4%B9%9F%E6%97%A0%E5%BD%92%E6%A1%A3%E6%97%B6\" >3.2. \u6570\u636e\u5e93\u65e0\u5907\u4efd\u4e5f\u65e0\u5f52\u6863\u65f6<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_%E6%95%85%E9%9A%9C%E7%8E%B0%E8%B1%A1\"><\/span>1. \u6545\u969c\u73b0\u8c61<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u6211\u81ea\u5df1\u7684\u4e00\u4e2aoracle\u6570\u636e\u5e93\u5728\u6253\u5f00\u540e\u62a5\u5982\u4e0b\u9519\u8bef\uff1a<\/p>\n<pre><code class=\"language-sql\">SQL&gt; startup\nORACLE instance started.\n\nTotal System Global Area 1660940440 bytes\nFixed Size               8896664 bytes\nVariable Size            520093696 bytes\nDatabase Buffers         1124073472 bytes\nRedo Buffers             7876608 bytes\nDatabase mounted.\nORA-01122: database file 51 failed verification check\nORA-01110: data file 51: &#039;\/u02\/oradata\/YKT\/zytk\/zytk35_ac02.dbf&#039;\nORA-01210: data file header is media corrupt<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"2_%E9%97%AE%E9%A2%98%E5%8E%9F%E5%9B%A0\"><\/span>2. \u95ee\u9898\u539f\u56e0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<pre><code class=\"language-shell\">~]$ oerr ora 01210\n01210, 00000, &quot;data file header is media corrupt&quot;\n\/\/ *Cause: The file header block is internally inconsistent. The beginning\n\/\/         of the block has a header with a checksum and other data for\n\/\/         insuring the consistancy of the block. It is possible that\n\/\/         the last disk write did not operate correctly. The most likely\n\/\/         problem is that this is not a datafile for any database.\n\/\/ *Action: Have operating system make correct file available to database.\n\/\/         If the trace file dump indicates that only the checksum is wrong,\n\/\/         restore from a backup and do media recovery.<\/code><\/pre>\n<p>\u6570\u636e\u5e93: 12c \u53d1\u5e03 1<br \/>\n\u9519\u8bef\u4ee3\u7801: ORA-01210<br \/>\n\u63cf\u8ff0: \u6570\u636e\u6587\u4ef6\u6807\u5934\u53d1\u751f\u4ecb\u8d28\u635f\u574f<br \/>\n\u539f\u56e0: \u6587\u4ef6\u5934\u5757\u5728\u5185\u90e8\u4e0d\u4e00\u81f4\u3002\u5757\u7684\u5f00\u5934\u5177\u6709\u5e26\u6821\u9a8c\u548c\u7684\u6807\u5934\u548c\u5176\u4ed6\u6570\u636e\uff0c\u4ee5\u786e\u4fdd\u5757\u7684\u4e00\u81f4\u6027\u3002\u4e0a\u6b21\u78c1\u76d8\u5199\u5165\u53ef\u80fd\u65e0\u6cd5\u6b63\u786e\u8fd0\u884c\u3002\u6700\u53ef\u80fd\u7684\u95ee\u9898\u662f\uff0c\u8fd9\u4e0d\u662f\u4efb\u4f55\u6570\u636e\u5e93\u7684\u6570\u636e\u6587\u4ef6\u3002<br \/>\n\u52a8\u4f5c: \u4f7f\u64cd\u4f5c\u7cfb\u7edf\u4f7f\u6b63\u786e\u7684\u6587\u4ef6\u53ef\u7528\u4e8e\u6570\u636e\u5e93\u3002\u5982\u679c\u8ddf\u8e2a\u6587\u4ef6\u8f6c\u50a8\u6307\u793a\u4ec5\u6821\u9a8c\u548c\u9519\u8bef\uff0c\u8bf7\u4ece\u5907\u4efd\u8fd8\u539f\u5e76\u8fdb\u884c\u5a92\u4f53\u6062\u590d\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_%E8%A7%A3%E5%86%B3%E6%80%9D%E8%B7%AF\"><\/span>3. \u89e3\u51b3\u601d\u8def<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"31_%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9C%89%E5%A4%87%E4%BB%BD%E4%B8%8E%E5%BD%92%E6%A1%A3%E6%97%B6\"><\/span>3.1. \u6570\u636e\u5e93\u6709\u5907\u4efd\u4e0e\u5f52\u6863\u65f6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u6267\u884cRMAN\u6062\u590d\uff0c\u53c2\u8003\uff1a<a target=\"_blank\" href=\"https:\/\/oracledbwr.com\/data-recovery-advisor-in-oracle-database-19c\/\">https:\/\/oracledbwr.com\/data-recovery-advisor-in-oracle-database-19c\/<\/a><\/p>\n<pre><code class=\"language-sql\">RMAN&gt;\nrestore datafile 51;\nrecover datafile 51;\nalter database open;<\/code><\/pre>\n<h4><span class=\"ez-toc-section\" id=\"32_%E6%95%B0%E6%8D%AE%E5%BA%93%E6%97%A0%E5%A4%87%E4%BB%BD%E4%B9%9F%E6%97%A0%E5%BD%92%E6%A1%A3%E6%97%B6\"><\/span>3.2. \u6570\u636e\u5e93\u65e0\u5907\u4efd\u4e5f\u65e0\u5f52\u6863\u65f6<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u53c2\u8003\uff1a<a target=\"_blank\" href=\"http:\/\/blog.chinaunix.net\/uid-12380499-id-5818041.html\">http:\/\/blog.chinaunix.net\/uid-12380499-id-5818041.html<\/a><br \/>\n<a target=\"_blank\" href=\"https:\/\/www.codenong.com\/cs109492476\/\">https:\/\/www.codenong.com\/cs109492476\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \u6545\u969c\u73b0\u8c61 \u6211\u81ea\u5df1\u7684\u4e00\u4e2aoracle\u6570\u636e\u5e93\u5728\u6253&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,2],"tags":[17,16],"class_list":{"0":"post-243","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-oracle","8":"tag-ora-01210","9":"tag-oracle"},"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/243","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=243"}],"version-history":[{"count":9,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions"}],"predecessor-version":[{"id":252,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions\/252"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}