{"id":1984,"date":"2023-12-19T15:41:48","date_gmt":"2023-12-19T07:41:48","guid":{"rendered":"http:\/\/www.821121.com\/?p=1984"},"modified":"2023-12-19T15:43:19","modified_gmt":"2023-12-19T07:43:19","slug":"%e5%ae%a1%e8%ae%a1%e5%9f%ba%e8%a1%a8-audunified-%e7%9a%84%e6%b8%85%e7%90%86","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1984","title":{"rendered":"\u5ba1\u8ba1\u57fa\u8868 AUD$UNIFIED \u7684\u6e05\u7406"},"content":{"rendered":"

\u6e05\u7406\u5ba1\u8ba1\u57fa\u8868 AUD$UNIFIED
\n\u4e0eaud$\u4e0d\u540c\uff0c AUD$UNIFIED\u4e0d\u652f\u6301\u76f4\u63a5truncate\uff0c\u5176\u4ed6DDL\u4e5f\u662f\u4e0d\u5141\u8bb8\u7684\uff0c\u4f46\u53ea\u662f\u5e38\u89c4\u65b9\u6cd5\u4e0d\u884c\uff0c\u73b0\u5728\u4ecb\u7ecd\u4e0b\u5177\u4f53\u6e05\u7406\u65b9\u6cd5\uff1a<\/p>\n

\"file\"<\/p>\n

\u65b9\u6cd51\uff1a\u4f7f\u7528DBMS_AUDIT_MGMT\u5305<\/p>\n

\u6e05\u7a7a\u6240\u6709\u6570\u636e<\/h4>\n
BEGIN\nDBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(\naudit_trail_type         =>  DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,\nuse_last_arch_timestamp  =>  FALSE);\nEND;\n\/\n<\/code><\/pre>\n
\u9700\u8981\u6307\u5b9a\u6e05\u7406\u65f6\u95f4\u8303\u56f4<\/h4>\n
BEGIN\nDBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,last_archive_time => TO_TIMESTAMP('10-SEP-0714:10:10.0','DD-MON-RRHH24:MI:SS.FF'));\nEND;\n\/<\/code><\/pre>\n
\u81ea\u5b9a\u4e49job\uff0c\u5b9a\u671f\u6e05\u7406<\/h4>\n
BEGIN\nDBMS_AUDIT_MGMT.CREATE_PURGE_JOB(\naudit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,\naudit_trail_purge_interval => 24 \/* hours *\/,\naudit_trail_purge_name => 'CLEANUP_AUDIT_TRAIL_UNIFIED',\nuse_last_arch_timestamp => TRUE);\nEND;\n\/\nBEGIN\nDBMS_SCHEDULER.create_job (\njob_name => 'audit_last_archive_time',\njob_type => 'PLSQL_BLOCK',\njob_action => 'BEGIN\nDBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, TRUNC(SYSTIMESTAMP)-10);\nEND;',\nstart_date => SYSTIMESTAMP,\nrepeat_interval => 'freq=daily; byhour=0; byminute=0; bysecond=0;',\nend_date => NULL,\nenabled => TRUE,\ncomments => 'Automatically set audit last archive time.');\nEND;\n<\/code><\/pre>\n
\u65b9\u6cd52\uff1a\u6570\u636e\u5e93\u542f\u52a8\u81f3upgrade
\nupgrade\u6a21\u5f0f\u4e0b\uff0c\u8be5\u57fa\u8868\u53ef\u4ee5\u8fdb\u884cDDL\u64cd\u4f5c<\/p>\n
alter database open upgrade\uff1b\nalter table audsys.aud$unified truncate  partition sys_p221;<\/code><\/pre>\n
\"file\"<\/p>\n
\u53c2\u8003\u5b98\u65b9\u6587\u6863(Doc ID 1582627.1)<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6e05\u7406\u5ba1\u8ba1\u57fa\u8868 AUD$UNIFIED \u4e0eaud$\u4e0d<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,49],"tags":[62,59,60,61],"class_list":["post-1984","post","type-post","status-publish","format-standard","hentry","category-oracle-12c","category-oracle-19c","tag-12c","tag-audsys-audunified","tag-ddl","tag-oracle"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1984","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=1984"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1984\/revisions"}],"predecessor-version":[{"id":1988,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1984\/revisions\/1988"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1984"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}