{"id":1415,"date":"2018-05-23T09:46:46","date_gmt":"2018-05-23T01:46:46","guid":{"rendered":"http:\/\/www.821121.com\/?p=1415"},"modified":"2021-02-23T09:50:55","modified_gmt":"2021-02-23T01:50:55","slug":"%e9%97%aa%e5%9b%9e%e6%95%b0%e6%8d%ae%e5%ba%93%ef%bc%88flashback-database%ef%bc%89%e6%a8%a1%e6%8b%9f%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1415","title":{"rendered":"\u95ea\u56de\u6570\u636e\u5e93\uff08Flashback Database\uff09\u6a21\u62df\u6d4b\u8bd5"},"content":{"rendered":"<pre><code class=\"language-sql\">Flashback Database\u547d\u4ee4\u662f\u4e3a\u4e86\u52a0\u5feb\u539f\u672c\u5f88\u6162\u7684\u65f6\u95f4\u70b9\u6570\u636e\u5e93\u6062\u590d\uff08point in time database recovery\uff09\u8fc7\u7a0b\u3002\u95ea\u56de\u53ef\u4ee5\u53d6\u5f97\u5b8c\u6574\u7684\u6570\u636e\u5e93\u6062\u590d\u548c\u4f7f\u7528\u5f52\u6863\u65e5\u5fd7\u7684\u524d\u6eda\uff0c\u4e3b\u8981\u76ee\u7684\u662f\u52a0\u5feb\u4ece\u201c\u610f\u5916\u72b6\u6001\u201c\u4e2d\u6062\u590d\u3002\u95ea\u56de\u6570\u636e\u5e93\u57fa\u4e8e\u95ea\u56de\u65e5\u5fd7flashback log\uff0c\u95ea\u56de\u65e5\u5fd7\u5305\u542b\u5df2\u4fee\u6539\u6570\u636e\u5757\u7684\u201d\u524d\u5f71\u50cf\u201c\uff0c\u53ef\u7528\u4e8e\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u8be5\u65f6\u95f4\u70b9\u4e4b\u524d\u7684\u72b6\u6001\u3002\u95ea\u56de\u6570\u636e\u5e93\u5141\u8bb8\u590d\u539f\u6574\u4e2a\u6570\u636e\u5e93\u5230\u5177\u4f53\u7684\u65f6\u95f4\u70b9\uff0c\u4ece\u800c\u64a4\u9500\u8be5\u65f6\u95f4\u70b9\u4ee5\u6765\u7684\u6240\u6709\u6570\u636e\u5e93\u7684\u53d8\u5316 \u7528\u6237\u8bef\u5220\u9664\u8868\u4e2d\u6570\u636e\u3001\u5220\u9664\u8868\u3001truncate\u8868\u3001\u7d22\u5f15\u3001\u89e6\u53d1\u5668\uff0c\u8868\u7a7a\u95f4\u7b49\u3002Dba\u8bef\u64cd\u4f5c\u7b49\u3002\u7b80\u800c\u8a00\u4e4b\uff0c\u6240\u6709\u64cd\u4f5c\u90fd\u53ef\u4ee5\u95ea\u56de\u3002\n\n\u95ea\u56de\u6570\u636e\u5e93\u80fd\u591f\u4f7f\u4f60\u5728\u4e0d\u6062\u590d\u6570\u636e\u6587\u4ef6\u5907\u4efd\u7684\u60c5\u51b5\u4e0b\u4f7f\u6570\u636e\u5e93\u5012\u56de\u5230\u5148\u53bb\u7684\u67d0\u4e2a\u65f6\u95f4\u70b9\u3002\n\u4f60\u53ef\u4ee5\u901a\u8fc7RMAN\u6216\u8005SQLPLUS\u6765\u95ea\u56de\u6570\u636e\u5e93\uff0c\u66ff\u4ee3\u4f7f\u7528\u590d\u6742\u7684\u8fc7\u7a0b\u3002\n\u4f7f\u7528\u6570\u636e\u5e93\u95ea\u56de\u53ef\u64a4\u9500\u5bfc\u81f4\u903b\u8f91\u6570\u636e\u635f\u574f\u7684\u53d8\u66f4\uff0c\u5982\u679c\u662f\u4ecb\u8d28\u4e22\u5931\u6216\u8005\u7269\u7406\u635f\u574f\uff0c\u5219\u5fc5\u987b\u4f7f\u7528\u4f20\u7edf\u7684\u6062\u590d\u65b9\u6cd5\u8fdb\u884c\u6570\u636e\u5e93\u7684\u6062\u590d\u3002\u95ea\u56de\u6570\u636e\u5e93\u4e0d\u9700\u8981\u6062\u590d\u6570\u636e\u6587\u4ef6\uff0c\n\u4ee5\u6b64\u6062\u590d\u6570\u636e\u5e93\u7684\u6570\u636e\u4e0e\u6240\u9700\u8981\u6062\u590d\u7684\u6570\u636e\u6761\u76ee\u6210\u6b63\u6bd4\uff0c\u548c\u6570\u636e\u5e93\u7684\u5927\u5c0f\u65e0\u5173\u3002\u95ea\u56de\u6570\u636e\u5e93\u5934\u901a\u8fc7\u95ea\u56de\u65e5\u5fd7\u6765\u8fdb\u884c\u6570\u636e\u6062\u590d\uff0c\u6570\u636e\u5e93\u4f1a\u5b9a\u671f\u5c06\u6570\u636e\u5feb\u7684\u524d\u5f71\u50cf\u8bb0\u5f55\u5728\u95ea\u56de\u65e5\u5fd7\u91cc\u9762\u3002<\/code><\/pre>\n<pre><code class=\"language-sql\">\u8fc7\u7a0b\u5982\u4e0b\uff1a\n\ncreate table t;\nSQL&gt; insert into t values(1,1);\n1 row created.\nSQL&gt; commit;\nCommit complete.\nSQL&gt; select dbms_flashback.get_system_change_number from dual;\nGET_SYSTEM_CHANGE_NUMBER\n------------------------\n                 2196505\nSQL&gt; insert into t values(2,2);\n1 row created.\nSQL&gt; commit;\nCommit complete.\nSQL&gt; select dbms_flashback.get_system_change_number from dual;\nGET_SYSTEM_CHANGE_NUMBER\n------------------------\n                 2196523\nSQL&gt; insert into t values(3,3);\n1 row created.\nSQL&gt; commit;\nCommit complete.\nSQL&gt; select dbms_flashback.get_system_change_number from dual;\nGET_SYSTEM_CHANGE_NUMBER\n------------------------\n                 2196545\nSQL&gt; shutdown immediate\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nSQL&gt; startup mount;\nORACLE instance started.\nTotal System Global Area  314572800 bytes\nFixed Size                  1219184 bytes\nVariable Size              75498896 bytes\nDatabase Buffers          234881024 bytes\nRedo Buffers                2973696 bytes\nDatabase mounted.\nSQL&gt; flashback database to scn 2196505;----\u95ea\u56de\u5230\u7b2c\u4e00\u6b21commit\u7684\u65f6\u5019\nFlashback complete.\nSQL&gt; alter database open resetlogs;\nDatabase altered.\nSQL&gt; select * from t;  ---\u95ea\u56de\u6570\u636e\u5e93\u6d4b\u8bd5\u6b63\u5e38\n         A          B\n---------- ----------\n         1          1\nSQL&gt; \n---------------------------------------\nTO timestamp---\u4f8b\u5b50\n flashback database to timestamp to_date(&#039;2011-07-12 10:20:59&#039;,&#039;yyyy-mm-dd hh24:mi:ss&#039;);<\/code><\/pre>\n<pre><code class=\"language-sql\">\u5c0f\u7ed3\uff1a\n\noracle10g\u6570\u636e\u5e93\u63d0\u4f9b\u4e86\u95ea\u56de\u529f\u80fd\uff0c\u65e0\u8bba\u5bf9\u5f00\u53d1\u4eba\u5458\uff0c\u8fd8\u662fDBA\u4eba\u5458\u63d0\u4f9b\u4e86\u4fbf\u6377\u7684\u5904\u7406\u903b\u8f91\u6570\u636e\u4e22\u5931\u7684\u5904\u7406\u65b9\u6cd5\uff0c\u975e\u5e38\u5b9e\u7528<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Flashback Database\u547d\u4ee4\u662f\u4e3a\u4e86\u52a0\u5feb<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,41,40],"tags":[],"class_list":["post-1415","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-41","category--oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1415","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=1415"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1415\/revisions"}],"predecessor-version":[{"id":1417,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1415\/revisions\/1417"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1415"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}