1.9.1 Audit Data Management Simplify themanagement of audit data created by the Oracle Database to facilitatecompliance with various privacy and compliance mandates such as SOX, HIPAA, andPCI. (1) Audit Trail Cleanup 1.9.2 EncryptionKey Management Encryption keymanagement provides the ability to cha...
-extra '<folder>':<days> Purge only files in user specified folders (Default 30 days) -aud Purge Audit logs based on '-orcl <days>' option -lsnr It will force the cleanup of listeners log independently by the age -dryrun It will show the purge commands w/o execute them -automigrate ...
audit_trail_type=>sys.DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL, default_cleanup_interval=>168);END;/ (6)确认清除Audit功能是否开启,yes为开启 SQL>SETSERVEROUTPUTONBEGINIFsys.DBMS_AUDIT_MGMT.is_cleanup_initialized(sys.DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD)THENDBMS_OUTPUT.put_line('YES');ELSEDBMS_OUTPUT....
(3)用Oracle自带的包DBMS_AUDIT_MGMT中的存储过程INIT_CLEANUP设置审计数据保留的天数,该存储过程接受2个参数,顺序依次是AUDIT_TRAIL_TYPE和DEFAULT_CLEANUP_INTERVAL。见官方文档的说明,其中参数DEFAULT_CLEANUP_INTERVAL的取值为1至999,单位为小时。 用Oracle自带的包DBMS_AUDIT_MGMT中的存储过程SET_LAST_ARCHIVE_TIMES...
2、创建audit tablespace create tablespace ts_audit datafile '/oradata/ora10g/audit01.dbf' size 4000M autoextend off; 3、设置清理频率 BEGIN DBMS_AUDIT_MGMT.INIT_CLEANUP( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, default_cleanup_interval => 12 /hours/); ...
以上脚本通过自定义job来定期清理7天前的数据,可以访问清理Audit数据帮助理解各个步骤的意思。 也可以手工清理数据: setserveroutputonprompt First Step: init cleanup (ifnotalready)BEGINIFNOTDBMS_AUDIT_MGMT.IS_CLEANUP_INITIALIZED(DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD)THENdbms_output.put_line('Calling DBMS_AU...
audit_trail_type => dbms_audit_mgmt.audit_trail_all, default_cleanup_interval => 7*24 ); end; / 接下来,为了执行实际的清除,您必须执行一个打包的过程 dbms_audit_mgmt.clean_audit_trail()。 begin dbms_audit_mgmt.clean_audit_trail(
TheDBMS_AUDIT_MGMTpackage enables you to perform audit trail cleanup tasks such as scheduling purge jobs, moving the audit trail to a different tablespace, setting archive timestamps in the audit trail, and so on. You must have theEXECUTEprivilege forDBMS_AUDIT_MGMTbefore you can use it. ...
Checks include: • Audit trail is SYSTEM • Audit trail is SYSAUX • Tablespace is non-autoextensible & 80% or more full (MEDIUM) • Tablespace is non-autoextensible & 90% or more full (HIGH) Audit Trail Cleanup AUDIT.CLE Lists enabled jobs that cleanup audit trails and check...
SQL>BEGIN2DBMS_AUDIT_MGMT.init_cleanup(3audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,4default_cleanup_interval =>120/* hours */);5END;6/ PL/SQLproceduresuccessfully completed.-- 下面严验证审计日志清除是否已开启SQL> SET SERVEROUTPUTONSQL>BEGIN2IFDBMS_AUDIT_MGMT.is_cleanup_initialized...