今天接到报警短信 说 /oracle/目录空间不足
查看发现 sysaux 数据文件很大,怀疑是默认的审计没关,查看aud$ 果真很大
是从dg主库同步过来的数据。
清空:
sys@test>begin
2 dbms_audit_mgmt.init_cleanup(
3 audit_trail_type => dbms_audit_mgmt.audit_trail_db_std,
4 default_cleanup_interval => 24 );
5 end;
6
7 /
执行报错
ERROR at line 1:
ORA-46267: Insufficient space in 'SYSAUX' tablespace, cannot complete operation
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1087
ORA-06512: at line 2
直接truncate table sys.aud$ reuse storage;
alter table sys.aud$ deallocate unused keep 8640m;
alter table sys.aud$ deallocate unused keep 7000m;
alter table sys.aud$ deallocate unused keep 6000m;
...
alter table sys.aud$ deallocate unused keep 10m;
truncate过程1-2分钟之内结束,最后sys.aud$变成10M。