11.2.0.1\u7248\u672c\u5ba1\u8ba1\u8868\u5b58\u653e\u5728SYSTEM<\/p>\n
11.2.0.2\u7248\u672c\u540e\u5ba1\u8ba1\u8868\u5b58\u653e\u5728SYSAUX<\/p>\n
\u53c2\u8003\u8d44\u6599\uff1a<\/p>\n
https:\/\/oracle-base.com\/articles\/11g\/auditing-enhancements-11gr2<\/p>\n
[sql]<\/p>\n
CREATE TABLESPACE audit_aux
\nDATAFILE ‘ +DATA\/xxxx\/datafile\/audit_aux01.dbf’
\nSIZE 1M AUTOEXTEND ON NEXT 1M;
\nBEGIN
\nDBMS_AUDIT_MGMT.set_audit_trail_location(
\naudit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
\naudit_trail_location_value => ‘AUDIT_AUX’);
\nEND;
\n\/<\/p>\n
PL\/SQL procedure successfully completed.<\/p>\n
SQL><\/p>\n
— Check locations.
\nSELECT table_name, tablespace_name
\nFROM dba_tables
\nWHERE table_name IN (‘AUD$’, ‘FGA_LOG$’)
\nORDER BY table_name;<\/p>\n
TABLE_NAME TABLESPACE_NAME
\n—————————— ——————————
\nAUD$ AUDIT_AUX
\nFGA_LOG$ SYSTEM<\/p>\n
SQL>
\nBEGIN
\nDBMS_AUDIT_MGMT.set_audit_trail_location(
\naudit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,
\naudit_trail_location_value => ‘AUDIT_AUX’);
\nEND;
\n\/<\/p>\n
PL\/SQL procedure successfully completed.<\/p>\n
SQL><\/p>\n
— Check locations.
\nSELECT table_name, tablespace_name
\nFROM dba_tables
\nWHERE table_name IN (‘AUD$’, ‘FGA_LOG$’)
\nORDER BY table_name;<\/p>\n
TABLE_NAME TABLESPACE_NAME
\n—————————— ——————————
\nAUD$ AUDIT_AUX
\nFGA_LOG$ AUDIT_AUX
\nBEGIN
\nDBMS_AUDIT_MGMT.init_cleanup(
\naudit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,
\ndefault_cleanup_interval => 12 \/* hours *\/);
\nEND;
\n\/
\nPL\/SQL procedure successfully completed.
\nSQL><\/p>\n
SELECT * FROM dba_audit_mgmt_config_params;<\/p>\n
PARAMETER_NAME PARAMETER_VALUE AUDIT_TRAIL
\n—————————— ——————– ——————–
\nDB AUDIT TABLESPACE SYSTEM STANDARD AUDIT TRAIL
\nDB AUDIT TABLESPACE SYSTEM FGA AUDIT TRAIL
\nAUDIT FILE MAX SIZE 10000 OS AUDIT TRAIL
\nAUDIT FILE MAX SIZE 10000 XML AUDIT TRAIL
\nAUDIT FILE MAX AGE 5 OS AUDIT TRAIL
\nAUDIT FILE MAX AGE 5 XML AUDIT TRAIL
\nDB AUDIT CLEAN BATCH SIZE 10000 STANDARD AUDIT TRAIL
\nDB AUDIT CLEAN BATCH SIZE 10000 FGA AUDIT TRAIL
\nOS FILE CLEAN BATCH SIZE 1000 OS AUDIT TRAIL
\nOS FILE CLEAN BATCH SIZE 1000 XML AUDIT TRAIL
\nDEFAULT CLEAN UP INTERVAL 12 OS AUDIT TRAIL<\/p>\n
PARAMETER_NAME PARAMETER_VALUE AUDIT_TRAIL
\n—————————— ——————– ——————–
\nDEFAULT CLEAN UP INTERVAL 12 STANDARD AUDIT TRAIL
\nDEFAULT CLEAN UP INTERVAL 12 FGA AUDIT TRAIL
\nDEFAULT CLEAN UP INTERVAL 12 XML AUDIT TRAIL
\nBEGIN
\nDBMS_AUDIT_MGMT.set_last_archive_timestamp(
\naudit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
\nlast_archive_time => SYSTIMESTAMP-5);
\nEND;
\n\/<\/p>\n
SELECT * FROM dba_audit_mgmt_last_arch_ts;<\/p>\n
AUDIT_TRAIL RAC_INSTANCE LAST_ARCHIVE_TS
\n——————– ———— —————————————-
\nSTANDARD AUDIT TRAIL 0 13-DEC-09 01.57.54.000000 PM +00:00<\/p>\n
SQL><\/p>\n
SELECT COUNT(*) FROM aud$;<\/p>\n
COUNT(*)
\n———-
\n2438<\/p>\n
SQL>
\nBEGIN
\nDBMS_AUDIT_MGMT.clean_audit_trail(
\naudit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
\nuse_last_arch_timestamp => TRUE);
\nEND;
\n\/<\/p>\n
PL\/SQL procedure successfully completed.<\/p>\n
SELECT COUNT(*) FROM aud$;<\/p>\n
COUNT(*)
\n———-
\n76
\nBEGIN
\nDBMS_AUDIT_MGMT.create_purge_job(
\naudit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,
\naudit_trail_purge_interval => 24 \/* hours *\/,
\naudit_trail_purge_name => ‘PURGE_ALL_AUDIT_TRAILS’,
\nuse_last_arch_timestamp => TRUE);
\nEND;
\n\/<\/p>\n
PL\/SQL procedure successfully completed.<\/p>\n
SQL><\/p>\n
SELECT job_action
\nFROM dba_scheduler_jobs
\nWHERE job_name = ‘PURGE_ALL_AUDIT_TRAILS’;<\/p>\n
JOB_ACTION
\n——————————————————————————–
\nBEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(15, TRUE); END;<\/p>\n
SQL><\/p>\n
[\/sql]<\/p>\n","protected":false},"excerpt":{"rendered":"
11.2.0.1\u7248\u672c\u5ba1\u8ba1\u8868\u5b58\u653e\u5728SYSTEM 11.2.0. …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[2],"tags":[],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7zRbQ-3w","_links":{"self":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=218"}],"version-history":[{"count":3,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":221,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions\/221"}],"wp:attachment":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}