{"id":10251,"date":"2021-07-24T13:15:16","date_gmt":"2021-07-24T05:15:16","guid":{"rendered":"https:\/\/ailog.tw\/lifelog\/?p=10251"},"modified":"2021-07-24T13:20:07","modified_gmt":"2021-07-24T05:20:07","slug":"oracle-rman-restore","status":"publish","type":"post","link":"https:\/\/ailog.tw\/lifelog\/2021\/07\/24\/oracle-rman-restore\/","title":{"rendered":"Oracle\u8cc7\u6599\u5eab\u9032\u884crman restore\u51fa\u73feORA-19870\u3001ORA-19502\u3001ORA-27072"},"content":{"rendered":"<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">\u5c0f\u7de8\u9047\u5230\u4e00\u500bOracle\u8cc7\u6599\u5eab\u9084\u539f\u7684\u554f\u984c\uff0c\u932f\u8aa4\u4ee3\u78bc\u662f\u300cORA-19870\u300d\u3001\u300cORA-19502\u300d\u3001\u300cORA-27072\u300d<!--more--><\/span><\/p>\n<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">\u7d93\u67e5\u8a62\u7d50\u679c\u662f\u78c1\u789f\u7a7a\u9593\u4e0d\u8db3\u9020\u6210\uff0c\u679c\u7136\u5728Linux\u7cfb\u7d71\u4e0b\u900f\u904edf -h\u67e5\u8a62\uff0c\u5c31\u53ef\u4ee5\u770b\u5230\u8cc7\u6599\u5eab\u6a94\u6848\u6240\u5728\u7684\u78c1\u5340\u7a7a\u9593\u5df2\u6eff\u4e86\u3002<\/span><\/p>\n<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">\u8cc7\u6599\u5eab\u9084\u539f\u904e\u7a0b\u7684\u932f\u8aa4\u78bc\uff1a<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\">ORA-19870: error while restoring backup piece \/orabck\/rman\/ORCL_L0_20210723_13694_14.DB<\/span><\/p>\n<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">ORA-19502: write error on file &#8220;\/oradata\/orcl\/ndist_tbs_02.dbf&#8221;, block number 1283592 (block size=8192)<\/span><\/p>\n<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">ORA-27072: File I\/O error<\/span><\/p>\n<p><span style=\"font-size: 14pt; font-family: verdana, geneva;\">Linux\u78c1\u5340\u7a7a\u9593\u67e5\u8a62\u6307\u4ee4\uff1a<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\">df -h<\/span><br \/>\n<span style=\"font-size: 14pt; font-family: verdana, geneva;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10254\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/07\/ORA-27072-02.png\" alt=\"\" width=\"441\" height=\"122\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/07\/ORA-27072-02.png 441w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/07\/ORA-27072-02-300x83.png 300w\" sizes=\"auto, (max-width: 441px) 100vw, 441px\" \/><\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5c0f\u7de8\u9047\u5230\u4e00\u500bOracle\u8cc7\u6599\u5eab\u9084\u539f\u7684\u554f\u984c\uff0c\u932f\u8aa4\u4ee3\u78bc\u662f\u300cORA-19870\u300d\u3001\u300cORA-19502\u300d\u3001\u300cORA- &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/ailog.tw\/lifelog\/2021\/07\/24\/oracle-rman-restore\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008Oracle\u8cc7\u6599\u5eab\u9032\u884crman restore\u51fa\u73feORA-19870\u3001ORA-19502\u3001ORA-27072\u3009<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":10253,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,387],"tags":[4521,4520,4522,1105,4523,4524,4525],"class_list":["post-10251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-itinfo","category-database","tag-ora-19502","tag-ora-19870","tag-ora-27072","tag-oracle","tag-oraclerman-restoreora-19870","tag-rman-restore","tag-4525"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/10251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/comments?post=10251"}],"version-history":[{"count":4,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/10251\/revisions"}],"predecessor-version":[{"id":10257,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/10251\/revisions\/10257"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media\/10253"}],"wp:attachment":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media?parent=10251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/categories?post=10251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/tags?post=10251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}