{"id":17352,"date":"2024-02-26T23:05:12","date_gmt":"2024-02-26T15:05:12","guid":{"rendered":"https:\/\/ailog.tw\/lifelog\/?p=17352"},"modified":"2024-02-26T23:14:26","modified_gmt":"2024-02-26T15:14:26","slug":"ora-01589-2","status":"publish","type":"post","link":"https:\/\/ailog.tw\/lifelog\/2024\/02\/26\/ora-01589-2\/","title":{"rendered":"Oracle\u79fb\u8f49\u5230\u5225\u53f0\u8a2d\u5099\u5f8c\u906d\u9047ORA-01589: must use RESETLOGS or NORESETLOGS option for database open"},"content":{"rendered":"<p>\u5c0f\u7de8\u6709\u6b21\u642c\u79fbOracle Database\u4e3b\u6a5f\u5f8c\uff0c\u7576\u8cc7\u6599\u5eab\u670d\u52d9\u8981\u555f\u52d5\u6642\u537b\u544a\u8b66ORA-01589: must use RESETLOGS or NORESETLOGS option for database open\uff0c\u5c0f\u7de8\u4f86\u5206\u4eab\u7576\u6642\u5982\u4f55\u8655\u7406\u7684\u5427!<\/p>\n<p><!--more--><\/p>\n<p>01\u3001<\/p>\n<pre><span style=\"color: #0000ff;\">sqlplus \"\/ as sysdba\"<\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17357 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-01.png\" alt=\"\" width=\"822\" height=\"225\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-01.png 822w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-01-300x82.png 300w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-01-768x210.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>02\u3001<\/p>\n<pre>SQL&gt;<span style=\"color: #0000ff;\">shutdown abort<\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17358 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-02.png\" alt=\"\" width=\"511\" height=\"56\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-02.png 511w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-02-300x33.png 300w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>03\u3001<\/p>\n<pre>SQL&gt;<span style=\"color: #0000ff;\">startup mount<\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17359 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-03.png\" alt=\"\" width=\"378\" height=\"56\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-03.png 378w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-03-300x44.png 300w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>04\u3001<\/p>\n<pre>SQL&gt;<span style=\"color: #0000ff;\">alter database open resetlogs;\r\n<\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17360 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-04.png\" alt=\"\" width=\"437\" height=\"73\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-04.png 437w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-04-300x50.png 300w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>05\u3001<\/p>\n<pre>SQL&gt;<span style=\"color: #0000ff;\">shutdown abort<\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17361 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-05.png\" alt=\"\" width=\"438\" height=\"56\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-05.png 438w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-05-300x38.png 300w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>06\u3001<\/p>\n<pre>SQL&gt;<span style=\"color: #0000ff;\">startup<\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17362 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-6.png\" alt=\"\" width=\"377\" height=\"63\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-6.png 377w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2024\/02\/ORA-01589-6-300x50.png 300w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5c0f\u7de8\u6709\u6b21\u642c\u79fbOracle Database\u4e3b\u6a5f\u5f8c\uff0c\u7576\u8cc7\u6599\u5eab\u670d\u52d9\u8981\u555f\u52d5\u6642\u537b\u544a\u8b66ORA-01589: must u &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/ailog.tw\/lifelog\/2024\/02\/26\/ora-01589-2\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008Oracle\u79fb\u8f49\u5230\u5225\u53f0\u8a2d\u5099\u5f8c\u906d\u9047ORA-01589: must use RESETLOGS or NORESETLOGS option for database open\u3009<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,387],"tags":[4602,1105],"class_list":["post-17352","post","type-post","status-publish","format-standard","hentry","category-itinfo","category-database","tag-ora-01589","tag-oracle"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/17352","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=17352"}],"version-history":[{"count":5,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/17352\/revisions"}],"predecessor-version":[{"id":17363,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/17352\/revisions\/17363"}],"wp:attachment":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media?parent=17352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/categories?post=17352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/tags?post=17352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}