{"id":5628,"date":"2020-12-25T08:45:08","date_gmt":"2020-12-25T00:45:08","guid":{"rendered":"https:\/\/ailog.tw\/lifelog\/?p=5628"},"modified":"2021-01-23T15:01:32","modified_gmt":"2021-01-23T07:01:32","slug":"oracle-11-2-0-3-to-11-2-0-4","status":"publish","type":"post","link":"https:\/\/ailog.tw\/lifelog\/2020\/12\/25\/oracle-11-2-0-3-to-11-2-0-4\/","title":{"rendered":"Oracle Database\u5f9e11.2.0.3\u7684RMAN\u5099\u4efd\u8cc7\u6599\u9084\u539f\u523011.2.0.4\u7248\u672c"},"content":{"rendered":"<p>Oracle Database\u5f9e11.2.0.3\u7684\u5099\u4efd\u8cc7\u6599\u9084\u539f\u523011.2.0.4\u7248\u672c\u6642\uff0c\u6703\u9047\u5230\u300cORA-39700: database must be opened with UPGRADE option\u300d\u932f\u8aa4<!--more-->\uff0c\u900f\u904e\u4e0b\u9762\u5e7e\u500b\u6b65\u9a5f\u5c31\u53ef\u4ee5\u8f15\u9b06\u7684\u5c07\u8cc7\u6599\u5eab\u5347\u7d1a\uff0c\u8b93\u8cc7\u6599\u5eab\u53ef\u4ee5\u9806\u5229\u958b\u555f\u3002<\/p>\n<p><strong>\u60c5\u5883\u8aaa\u660e\uff1a<\/strong><br \/>\n\u5c07Oracle 11.2.0.3\u7684rman\u5099\u4efd\u9084\u539f\u523011.2.0.4\u7684\u7248\u672c\uff0c\u7576\u958b\u555f\u8cc7\u6599\u5eab\u6642\u9047\u5230\u4e0b\u5716\u7684ORA-39700\u932f\u8aa4\u8a0a\u606f\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5631 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2020\/12\/oracleupg.jpg\" alt=\"\" width=\"800\" height=\"258\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2020\/12\/oracleupg.jpg 800w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2020\/12\/oracleupg-300x97.jpg 300w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2020\/12\/oracleupg-768x248.jpg 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/p>\n<p><strong>\u4e00\u3001\u6aa2\u67e5\u5347\u7d1asql\u8173\u672c\u6a94\u6848\u662f\u5426\u5b58\u5728<\/strong><br \/>\n<span style=\"color: #ff0000;\">su &#8211; oracle<\/span><br \/>\n<span style=\"color: #ff0000;\">ls -la $ORACLE_HOME\/rdbms\/admin\/catupgrd.sql<\/span><br \/>\n<span style=\"color: #ff0000;\">ls -la $ORACLE_HOME\/rdbms\/admin\/utlu112s.sql<\/span><br \/>\n<span style=\"color: #ff0000;\">ls -la $ORACLE_HOME\/rdbms\/admin\/catuppst.sql<\/span><br \/>\n<span style=\"color: #ff0000;\">ls -la $ORACLE_HOME\/rdbms\/admin\/utlrp.sql<\/span><br \/>\n\u203b\u5982\u679c\u6a94\u6848\u90fd\u5b58\u5728\u5c31\u53ef\u4ee5\u9032\u884c\u4e0b\u4e00\u6b65\u9a5f<\/p>\n<p><strong>\u4e8c\u3001\u4ee5\u5347\u7d1a\u6a21\u5f0f\u555f\u52d5\u8cc7\u6599\u5eab<\/strong><br \/>\nSQL&gt;<span style=\"color: #ff0000;\">startup upgrade;<\/span><\/p>\n<p><strong>\u4e09\u3001\u67e5\u770b\u9810\u5099\u5347\u7ea7\u7684\u8cc7\u8a0a<\/strong><br \/>\nSQL&gt;<span style=\"color: #ff0000;\">@$ORACLE_HOME\/rdbms\/admin\/utlu112i.sql<\/span><\/p>\n<p><strong>\u56db\u3001\u57f7\u884c\u5347\u7d1aSQL\u8173\u672c<\/strong><br \/>\nSQL&gt;<span style=\"color: #ff0000;\">@$ORACLE_HOME\/rdbms\/admin\/catupgrd.sql<\/span><br \/>\nSQL&gt;<span style=\"color: #ff0000;\">@$ORACLE_HOME\/rdbms\/admin\/utlu112s.sql<\/span><br \/>\nSQL&gt;<span style=\"color: #ff0000;\">@$ORACLE_HOME\/rdbms\/admin\/catuppst.sql<\/span><br \/>\nSQL&gt;<span style=\"color: #ff0000;\">@$ORACLE_HOME\/rdbms\/admin\/utlrp.sql<br \/>\n<\/span><span style=\"color: #000000;\">\u203b\u5982\u679c\u904e\u7a0b\u6709\u9047\u5230\u8cc7\u6599\u5eab\u88ab\u95dc\u9589\u7684\u72c0\u6cc1\uff0c\u5c31\u91cd\u65b0\u57f7\u884c\u6b65\u9a5f\u4e8c\u300c<strong>\u4ee5\u5347\u7d1a\u6a21\u5f0f\u555f\u52d5\u8cc7\u6599\u5eab<\/strong>\u300d\uff0c\u5c07\u8cc7\u6599\u5eab\u91cd\u65b0\u555f\u52d5\u3002<\/span><span style=\"color: #ff0000;\"><br \/>\n<\/span><\/p>\n<p><strong>\u4e94\u3001\u91cd\u65b0\u555f\u52d5\u8cc7\u6599\u5eab<\/strong><br \/>\nSQL&gt;<span style=\"color: #ff0000;\">shutdown immediate;<\/span><br \/>\nORA-01109: database not open<br \/>\nDatabase dismounted.<br \/>\n<span style=\"font-size: 1rem;\">ORACLE instance shut down.<br \/>\n<\/span>SQL&gt;<span style=\"color: #ff0000;\">startup;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Database\u5f9e11.2.0.3\u7684\u5099\u4efd\u8cc7\u6599\u9084\u539f\u523011.2.0.4\u7248\u672c\u6642\uff0c\u6703\u9047\u5230\u300cORA-397 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/ailog.tw\/lifelog\/2020\/12\/25\/oracle-11-2-0-3-to-11-2-0-4\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008Oracle Database\u5f9e11.2.0.3\u7684RMAN\u5099\u4efd\u8cc7\u6599\u9084\u539f\u523011.2.0.4\u7248\u672c\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":[2452,2453,2454,2455,2456,1105,2832],"class_list":["post-5628","post","type-post","status-publish","format-standard","hentry","category-itinfo","category-database","tag-11-2-0-3","tag-11-2-0-4","tag-2454","tag-database-must-be-opened-with-upgrade-option","tag-ora-39700","tag-oracle","tag-oracle-database11-2-0-3rman11-2-0-4"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/5628","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=5628"}],"version-history":[{"count":5,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/5628\/revisions"}],"predecessor-version":[{"id":5665,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/5628\/revisions\/5665"}],"wp:attachment":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media?parent=5628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/categories?post=5628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/tags?post=5628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}