{"id":117,"date":"2020-12-15T14:39:44","date_gmt":"2020-12-15T06:39:44","guid":{"rendered":"https:\/\/www.db2go.net\/?p=117"},"modified":"2020-12-15T14:41:00","modified_gmt":"2020-12-15T06:41:00","slug":"%e6%8e%a8%e8%bf%9bscn%e5%8f%b7","status":"publish","type":"post","link":"https:\/\/www.db2go.net\/?p=117","title":{"rendered":"\u63a8\u8fdbscn\u53f7"},"content":{"rendered":"<p>\u73af\u5883\u662flinux\uff0c11.2.0.4<\/p>\n<ol>\n<li>\u8fdb\u884c\u4e0d\u5b8c\u5168\u6062\u590d<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">recover database until cancel;\nORA-01194: file 1 needs more recovery to be consistent \nORA-01110: data file 1: '\/u01\/oracle\/oradata\/orcl\/system01.dbf'\n<\/code><\/pre>\n<ol start=\"2\">\n<li>\u7528\u9690\u542b\u53c2\u6570\u6253\u5f00\u6570\u636e\u5e93<\/li>\n<\/ol>\n<pre><code class=\"language-sql line-numbers\">select file#,to_char(checkpoint_change#,'999999999999') from v<span class=\"katex math inline\">datafile;\nselect file#,online_status,to_char(change#,'999999999999') from v<\/span>recover_file;\nselect file#,to_char(checkpoint_change#,'999999999999') from v$datafile_header;\n<\/code><\/pre>\n<p>\u4f7f\u7528\u9690\u542b\u53c2\u6570\u6253\u5f00\u6570\u636e\u5e93:<\/p>\n<pre><code class=\"language-sql line-numbers\">_allow_resetlogs_corruption= TRUE\n\nalter database open resetlogs;\n<\/code><\/pre>\n<ol start=\"3\">\n<li>open\u65f6\u62a5\u9519<\/li>\n<\/ol>\n<p>\u4e2d\u95f4\u8981\u662fopen\u62a5\u9519\uff0calert\u65e5\u5fd7\u663e\u793a\u5982ora-01555\u4e4b\u7c7b\u7684\uff0c\u5c31\u9700\u8981\u4f7f\u7528oradebug\u5728mount\u72b6\u6001\u4e0b\u63a8\u8fdbSCN<\/p>\n<pre><code class=\"language-sql line-numbers\">1.\u5f53\u524d\u6570\u636e\u5e93\u7684Current SCN\nselect current_scn||'' from v<span class=\"katex math inline\">database;\n2.\u91cd\u542f\u5230mount\n3.\u4f7f\u7528oradebug poke\u63a8\u8fdbSCN\nSYS@orcl&gt; oradebug setmypid\nStatement processed.\nSYS@orcl&gt; oradebug dumpvar sga kcsgscn_\nkcslf kcsgscn_ [06001AE70, 06001AEA0) = 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 6001AB50 00000000\n\n\u67e5\u8be2scn\u662f65351968\uff0c\u6539\u621085351968\nSYS@orcl&gt; oradebug poke 0x06001AE70 8 85351968\nSYS@orcl&gt; oradebug dumpvar sga kcsgscn_\n\nalter database open;\nselect current_scn||'' from v<\/span>database;\n\n\u6700\u540e\u6539\u56de\u6765\nalter system set \"_allow_resetlogs_corruption\" = false scope=spfile;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u73af\u5883\u662flinux\uff0c11.2.0.4 \u8fdb\u884c\u4e0d\u5b8c\u5168\u6062\u590d recover database until cancel&hellip;<\/p>\n <a href=\"https:\/\/www.db2go.net\/?p=117\" title=\"\u63a8\u8fdbscn\u53f7\" class=\"entry-more-link\"><span>Read More<\/span> <span class=\"screen-reader-text\">\u63a8\u8fdbscn\u53f7<\/span><\/a>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"Layout":"","footnotes":""},"categories":[4],"tags":[],"class_list":["entry","author-suredandan","post-117","post","type-post","status-publish","format-standard","category-oracle"],"views":1571,"_links":{"self":[{"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/posts\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.db2go.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=117"}],"version-history":[{"count":3,"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/posts\/117\/revisions"}],"predecessor-version":[{"id":120,"href":"https:\/\/www.db2go.net\/index.php?rest_route=\/wp\/v2\/posts\/117\/revisions\/120"}],"wp:attachment":[{"href":"https:\/\/www.db2go.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.db2go.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.db2go.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}