{"id":1218,"date":"2018-03-01T14:42:37","date_gmt":"2018-03-01T06:42:37","guid":{"rendered":"http:\/\/www.oracle.name\/?p=1218"},"modified":"2018-03-01T14:42:37","modified_gmt":"2018-03-01T06:42:37","slug":"oracle%e5%ae%a1%e8%ae%a1%e5%8a%9f%e8%83%bd%e5%a6%82%e4%bd%95%e5%ae%9e%e7%8e%b0%e5%90%af%e5%8a%a8%e5%85%b3%e9%97%ad%e5%8a%9f%e8%83%bd","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1218","title":{"rendered":"oracle\u5ba1\u8ba1\u529f\u80fd\u5982\u4f55\u5b9e\u73b0\u542f\u52a8\u5173\u95ed\u529f\u80fd"},"content":{"rendered":"

\n\t\u4e00 \u5ba1\u8ba1\u529f\u80fd\u7684\u53c2\u6570\u63a7\u5236
\n\taudit_trail \u53c2\u6570\u7684\u503c\u53ef\u4ee5\u8bbe\u7f6e\u4e3a\u4ee5\u4e0b\u51e0\u79cd\n<\/p>\n

\n\t1. NONE\uff1a\u4e0d\u5f00\u542f
\n\t2. DB\uff1a\u5f00\u542f\u5ba1\u8ba1\u529f\u80fd
\n\t3. OS\uff1a\u5ba1\u8ba1\u8bb0\u5f55\u5199\u5165\u4e00\u4e2a\u64cd\u4f5c\u7cfb\u7edf\u6587\u4ef6\u3002
\n\t4. TRUE\uff1a\u4e0e\u53c2\u6570DB\u4e00\u6837
\n\t5. FALSE\uff1a\u4e0d\u5f00\u542f\u5ba1\u8ba1\u529f\u80fd\u3002
\n\t\u8fd9\u4e2a\u53c2\u6570\u662f\u5199\u5728spfile\u91cc\uff0c\u9700\u8981\u91cd\u542f\u6570\u636e\u5e93\u3002 \n<\/p>\n

\n\t\u4e8c \u67e5\u770b\u662f\u5426\u5ba1\u8ba1\u529f\u80fd\u662f\u5426\u542f\u52a8
\n\tSQL> show parameter audit
\n\tNAME                                 TYPE        VALUE
\n\t———————————— ———– ——————————
\n\taudit_file_dest                      string      \/u01\/app\/oracle\/admin\/PROD\/adump
\n\taudit_sys_operations                 boolean     FALSE
\n\taudit_syslog_level                   string
\n\taudit_trail                          string      NONE\n<\/p>\n

\n\t \n<\/p>\n

\n\t\u4e09 \u5f00\u542f\u5ba1\u8ba1
\n\tSQL> conn \/as sysdba
\n\tSQL> show parameter audit
\n\tNAME                                 TYPE        VALUE
\n\t———————————— ———– ——————————
\n\taudit_file_dest                      string      \/u01\/app\/oracle\/admin\/PROD\/adump
\n\taudit_sys_operations                 boolean     FALSE
\n\taudit_syslog_level                   string
\n\taudit_trail                          string      NONE\n<\/p>\n

\n\tSQL> alter system set audit_sys_operations=TRUE scope=spfile;–\u5ba1\u8ba1\u7ba1\u7406\u7528\u6237(\u4ee5sysdba\/sysoper\u89d2\u8272\u767b\u9646)
\n\tSQL> alter system set audit_trail=db,extended scope=spfile;\n<\/p>\n

\n\t\u91cd\u542f\u5b9e\u4f8b
\n\tSQL> show parameter audit
\n\tNAME                                 TYPE        VALUE
\n\t———————————— ———– ——————————
\n\taudit_file_dest                      string      \/u01\/app\/oracle\/admin\/PROD\/adump
\n\taudit_sys_operations                 boolean     TRUE
\n\taudit_syslog_level                   string
\n\taudit_trail                          string      DB, EXTENDED     
\n\t\uff08\u5b8c\u6210\uff09\n<\/p>\n

\n\t\u56db \u5173\u95ed\u5ba1\u8ba1\n<\/p>\n

\n\tSQL> conn \/as sysdba
\n\tSQL> show parameter audit
\n\tSQL> alter system set audit_trail = none scope=spfile;
\n\t\u91cd\u542f\u5b9e\u4f8b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4e00 \u5ba1\u8ba1\u529f\u80fd\u7684\u53c2\u6570\u63a7\u5236 audit_trail \u53c2\u6570\u7684\u503c\u53ef\u4ee5\u8bbe\u7f6e\u4e3a\u4ee5\u4e0b\u51e0\u79cd 1. NONE\uff1a\u4e0d\u5f00\u542f 2. DB … \u7ee7\u7eed\u9605\u8bfboracle\u5ba1\u8ba1\u529f\u80fd\u5982\u4f55\u5b9e\u73b0\u542f\u52a8\u5173\u95ed\u529f\u80fd<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31,1],"tags":[188],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1218"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1218"}],"version-history":[{"count":1,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1218\/revisions"}],"predecessor-version":[{"id":1219,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1218\/revisions\/1219"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}