{"id":1408,"date":"2018-04-23T09:26:43","date_gmt":"2018-04-23T01:26:43","guid":{"rendered":"http:\/\/www.821121.com\/?p=1408"},"modified":"2021-02-23T09:32:52","modified_gmt":"2021-02-23T01:32:52","slug":"%e6%a8%a1%e6%8b%9f%e9%9d%9e%e5%bd%92%e6%a1%a3%e6%a8%a1%e5%bc%8f%e7%9a%84%e5%a4%87%e4%bb%bd%e4%b8%8e%e6%81%a2%e5%a4%8d%ef%bc%88%e4%bd%bf%e7%94%a8%e5%86%b7%e5%a4%87","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1408","title":{"rendered":"\u6a21\u62df\u975e\u5f52\u6863\u6a21\u5f0f\u7684\u5907\u4efd\u4e0e\u6062\u590d\uff08\u4f7f\u7528\u51b7\u5907)"},"content":{"rendered":"<h1>1\u3001\u5f00\u542f\u975e\u5f52\u6863\u6a21\u5f0f<\/h1>\n<pre><code class=\"language-sql\">SQL&gt; archive log list\nSQL&gt; alter database noarchivelog;\nSQL&gt; alter database open;<\/code><\/pre>\n<h1>2.\u67e5\u8be2\u6570\u636e\u6587\u4ef6\u548c\u63a7\u5236\u6587\u4ef6\u7684\u4f4d\u7f6e,\u51b7\u5907\u4efd<\/h1>\n<pre><code class=\"language-sql\">select name from v$datafile union select name from v$controlfile;\nNAME\n--------------------------------------------------------------------------------\n\/u01\/app\/oracle\/oradata\/racdb\/control01.ctl\n\/u01\/app\/oracle\/oradata\/racdb\/control02.ctl\n\/u01\/app\/oracle\/oradata\/racdb\/control03.ctl\n\/u01\/app\/oracle\/oradata\/racdb\/eas_d_anjoy_standard01.dbf\n\/u01\/app\/oracle\/oradata\/racdb\/sysaux01.dbf\n\/u01\/app\/oracle\/oradata\/racdb\/system01.dbf\n\/u01\/app\/oracle\/oradata\/racdb\/test01.dbf\n\/u01\/app\/oracle\/oradata\/racdb\/undotbs1.dbf\n\/u01\/app\/oracle\/oradata\/racdb\/users01.dbf\n\nmkdir -p \/home\/oracle\/bak\nshutdown immediate\ncp \/u01\/app\/oracle\/oradata\/racdb\/control01.ctl \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/control02.ctl \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/control03.ctl \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/eas_d_anjoy_standard01.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/sysaux01.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/system01.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/test01.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/undotbs1.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/users01.dbf \/home\/oracle\/bak\/<\/code><\/pre>\n<h1>3. \u5f00\u5e93\uff0c\u8bef\u5220\u4e3b\u8981\u6570\u636e\u6570\u636e<\/h1>\n<pre><code class=\"language-sql\">rm -rf \/u01\/app\/oracle\/oradata\/racdb\/sysaux01.dbf\nrm -rf \/u01\/app\/oracle\/oradata\/racdb\/control01.ctl\n\nstartup\nshutdown immediate\n\u8fd9\u662f\u542f\u52a8\u6570\u636e\u5e93\u62a5\u9519\uff0c\u6b63\u5e38\u5173\u5e93<\/code><\/pre>\n<h1>4.\u6062\u590d\u6570\u636e<\/h1>\n<pre><code class=\"language-sql\">cp \/home\/oracle\/bak\/control01.ctl \/u01\/app\/oracle\/oradata\/racdb\/\ncp \/home\/oracle\/bak\/control02.ctl \/u01\/app\/oracle\/oradata\/racdb\/\ncp \/home\/oracle\/bak\/control03.ctl \/u01\/app\/oracle\/oradata\/racdb\/\ncp \/home\/oracle\/bak\/eas_d_anjoy_standard01.dbf \/u01\/app\/oracle\/oradata\/racdb\/\ncp \/home\/oracle\/bak\/sysaux01.dbf \/u01\/app\/oracle\/oradata\/racdb\/\ncp \/home\/oracle\/bak\/system01.dbf \/u01\/app\/oracle\/oradata\/racdb\/\ncp \/home\/oracle\/bak\/test01.dbf \/u01\/app\/oracle\/oradata\/racdb\/\ncp \/home\/oracle\/bak\/undotbs1.dbf \/u01\/app\/oracle\/oradata\/racdb\/\ncp \/home\/oracle\/bak\/users01.dbf \/u01\/app\/oracle\/oradata\/racdb\/<\/code><\/pre>\n<h1>5.\u91cd\u65b0\u542f\u52a8\u6570\u636e\u5e93<\/h1>\n<pre><code class=\"language-sql\">startup mount\nrecover database until cancel;\nalter database open resetlogs;<\/code><\/pre>\n<h1>6.\u8bef\u5220\u975e\u91cd\u8981\u6570\u636e\u6587\u4ef6<\/h1>\n<pre><code class=\"language-sql\">shutdown immediate\ncp \/u01\/app\/oracle\/oradata\/racdb\/control01.ctl \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/control02.ctl \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/control03.ctl \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/eas_d_anjoy_standard01.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/sysaux01.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/system01.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/test01.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/undotbs1.dbf \/home\/oracle\/bak\/\ncp \/u01\/app\/oracle\/oradata\/racdb\/users01.dbf \/home\/oracle\/bak\/\n\nrm -rf \/u01\/app\/oracle\/oradata\/racdb\/eas_d_anjoy_standard01.dbf\n\nstartup(\u6b63\u5e38\u542f\u5e93\u62a5\u9519\uff09\nshutdown immediate\n\n\u56e0\u4e3a\u6570\u636e\u6587\u4ef6 \/u01\/app\/oracle\/oradata\/racdb\/eas_d_anjoy_standard01.dbf \u4e2d\u7684\u6570\u636e\u5e76\u4e0d\u91cd\u8981\uff0c\nstartup force mount\nalter database datafile 5 offline drop;\nalter database open;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u5f00\u542f\u975e\u5f52\u6863\u6a21\u5f0f SQL&gt; archive<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,48,40],"tags":[],"class_list":["post-1408","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-sql","category--oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1408"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1408\/revisions"}],"predecessor-version":[{"id":1409,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1408\/revisions\/1409"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1408"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}