一、现象
从告警日志中爆出大量ora-01688错误,发现aud$unifie表在sysaux表无法扩展。
二、处理步骤
1、先停止审计
alter system set audit_trail=none scope=spfile;
重启数据库生效
2、查看审计数据所占空间,发现占用了41.4G
select owner,segment_name,sum(bytes)/1024/1024/1024
from dba_segments
where tablespace_name=‘SYSAUX‘
group by owner,segment_name
order by 3
;
3、清空审计表:
truncate table audsys.aud$unified
*
ERROR at line 1:
ORA-46385: DML and DDL operations are not allowed on table "AUDSYS"."AUD$UNIFIED".
4、用以下办法成功
BEGIN
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
container => DBMS_AUDIT_MGMT.CONTAINER_CURRENT,
use_last_arch_timestamp => FALSE);
END;
/
5、验证表空间已经释放