{"id":2081,"date":"2024-08-13T10:26:26","date_gmt":"2024-08-13T02:26:26","guid":{"rendered":"http:\/\/www.821121.com\/?p=2081"},"modified":"2025-05-09T16:44:23","modified_gmt":"2025-05-09T08:44:23","slug":"2081","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=2081","title":{"rendered":"logminer\u7684\u4f7f\u7528"},"content":{"rendered":"

\u4e00\u3001logminer\u7684\u7528\u9014.<\/h1>\n

\u65e5\u5fd7\u6587\u4ef6\u4e2d\u5b58\u653e\u7740\u6240\u6709\u8fdb\u884c\u6570\u636e\u5e93\u6062\u590d\u7684\u6570\u636e\uff0c\u8bb0\u5f55\u4e86\u9488\u5bf9\u6570\u636e\u5e93\u7ed3\u6784\u7684\u6bcf\u4e00\u4e2a\u53d8\u5316\uff0c\u4e5f\u5c31\u662f\u5bf9\u6570\u636e\u5e93\u64cd\u4f5c\u7684\u6240\u6709DML\u8bed\u53e5\u3002logminer \u5de5\u5177\u5373\u53ef\u4ee5\u7528\u6765\u5206\u6790\u5728\u7ebf\uff0c\u4e5f\u53ef\u4ee5\u7528\u6765\u5206\u6790\u79bb\u7ebf\u65e5\u5fd7\u6587\u4ef6\uff0c\u5373\u53ef\u4ee5\u5206\u6790\u672c\u8eab\u81ea\u5df1\u6570\u636e\u5e93\u7684\u91cd\u4f5c\u65e5\u5fd7\u6587\u4ef6\uff0c\u4e5f\u53ef\u4ee5\u7528\u6765\u5206\u6790\u5176\u4ed6\u6570\u636e\u5e93\u7684\u91cd\u4f5c\u65e5\u5fd7\u6587\u4ef6\u3002\u603b\u7684\u8bf4\u6765\uff0clogminer\u5de5\u5177\u7684\u4e3b\u8981\u7528\u9014\u6709\uff1a
\n\u30001\uff0e\u8ddf\u8e2a\u6570\u636e\u5e93\u7684\u53d8\u5316\uff1a\u53ef\u4ee5\u79bb\u7ebf\u7684\u8ddf\u8e2a\u6570\u636e\u5e93\u7684\u53d8\u5316\uff0c\u800c\u4e0d\u4f1a\u5f71\u54cd\u5728\u7ebf\u7cfb\u7edf\u7684\u6027\u80fd\u3002
\n\u30002\uff0e \u56de\u9000\u6570\u636e\u5e93\u7684\u53d8\u5316\uff1a\u56de\u9000\u7279\u5b9a\u7684\u53d8\u5316\u6570\u636e\uff0c\u51cf\u5c11point-in-time recovery\u7684\u6267\u884c\u3002
\n\u30003\uff0e\u4f18\u5316\u548c\u6269\u5bb9\u8ba1\u5212\uff1a\u53ef\u901a\u8fc7\u5206\u6790\u65e5\u5fd7\u6587\u4ef6\u4e2d\u7684\u6570\u636e\u4ee5\u5206\u6790\u6570\u636e\u589e\u957f\u6a21\u5f0f\u3002<\/p>\n

\u4e8c\u3001\u4f7f\u7528logminer\u8fdb\u884c\u65e5\u5fd7\u5206\u6790<\/h1>\n

\uff081\uff09\u65e0\u9650\u5236\u6761\u4ef6<\/h2>\n

SQL> exec dbms_logmnr.start_logmnr( dictfilename=>'\/u01\/app\/oracle\/oradata\/orcl\/arch\/****<\/strong>.ora');<\/p>\n

PL\/SQL \u8fc7\u7a0b\u5df2\u6210\u529f\u5b8c\u6210\u3002<\/p>\n

\uff082\uff09\u6709\u9650\u5236\u6761\u4ef6<\/h2>\n

\u901a\u8fc7\u5bf9\u8fc7\u7a0bDBMS_ LOGMNR.START_LOGMNR\u4e2d\u51e0\u4e2a\u4e0d\u540c\u53c2\u6570\u7684\u8bbe\u7f6e\uff08\u53c2\u6570\u542b\u4e49\u89c1\u88681\uff09\uff0c\u53ef\u4ee5\u7f29\u5c0f\u8981\u5206\u6790\u65e5\u5fd7\u6587\u4ef6\u7684\u8303\u56f4\u3002\u901a\u8fc7\u8bbe\u7f6e\u8d77\u59cb\u65f6\u95f4\u548c\u7ec8\u6b62\u65f6\u95f4\u53c2\u6570\u6211\u4eec\u53ef\u4ee5\u9650\u5236\u53ea\u5206\u6790\u67d0\u4e00\u65f6\u95f4\u8303\u56f4\u7684\u65e5\u5fd7\u3002
\n\u5982\u4e0b\u9762\u7684\u4f8b\u5b50\uff0c\u6211\u4eec\u4ec5\u4ec5\u5206\u67902004\u5e749\u670818\u65e5\u7684\u65e5\u5fd7\uff0c\uff1a
\nSQL> EXECUTE dbms_logmnr.start_logmnrdictfilename => '\/u01\/app\/oracle\/oradata\/orcl\/arch\/****<\/strong>.ora',starttime => to_date('2023-09-19 00:00:00','YYYY-MM-DD HH24:MI:SS'),endtime => to_date('2023-09-20 00:00:00','YYYY-MM-DD HH24:MI:SS '));
\n\u4e5f\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u8d77\u59cbSCN\u548c\u622a\u81f3SCN\u6765\u9650\u5236\u8981\u5206\u6790\u65e5\u5fd7\u7684\u8303\u56f4\uff1a
\nSQL> EXECUTE dbms_logmnr.start_logmnr( dictfilename => '\/u01\/app\/oracle\/oradata\/orcl\/arch\/****<\/strong>.ora', startscn => 112635, endscn => 112690);<\/p>\n

\u89c2\u5bdf\u5206\u6790\u7ed3\u679c<\/h1>\n

V$LOGMNR_DICTIONARY-------\u67e5\u8be2\u4f7f\u7528\u7684\u6570\u636e\u5b57\u5178\u6587\u4ef6
\nV$LOGMNR_PARAMETERS-------\u67e5\u8be2\u5f53\u524dLogMiner\u8bbe\u5b9a\u7684\u53c2\u6570
\nV$LOGMNR_LOGS-------\u67e5\u8be2\u5206\u6790\u7684\u65e5\u5fd7\u6587\u4ef6
\nV$LOGMNR_CONTENTS-------\u65e5\u5fd7\u6587\u4ef6\u7684\u5185\u5bb9<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4e00\u3001logminer\u7684\u7528\u9014. \u65e5\u5fd7\u6587\u4ef6\u4e2d\u5b58\u653e\u7740\u6240\u6709<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-2081","post","type-post","status-publish","format-standard","hentry","category-oracle-12c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/2081","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=2081"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/2081\/revisions"}],"predecessor-version":[{"id":2084,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/2081\/revisions\/2084"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2081"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}