广东省建设工程规范文件网站网站案例

昨晚正在外滩玩，有个客户发过来一段报错，已经影响到业务了。一看就是12C以后版本才有的问题，，赶紧在手机中收到临时解决办法

报错如下

ORA-1688: unable to extend table AUDSYS.AUD$UNIFIED partition SYS_P42549 by 1024 in tablespace SYSAUX
Unified Audit record write to audit trail table failed due to ORA-1688. Writing the record to OS spillover file.
2023-04-17T21:32:21.671716+08:00
ORA-1688: unable to extend table AUDSYS.AUD$UNIFIED partition SYS_P42549 by 1024 in tablespace SYSAUX
Unified Audit record write to audit trail table failed due to ORA-1688. Writing the record to OS spillover file.
2023-04-17T21:32:21.754257+08:00
ORA-1688: unable to extend table AUDSYS.AUD$UNIFIED partition SYS_P42549 by 1024 in tablespace SYSAUX
Unified Audit record write to audit trail table failed due to ORA-1688. Writing the record to OS spillover file.
2023-04-17T21:32:21.853321+08:00
ORA-1688: unable to extend table AUDSYS.AUD$UNIFIED partition SYS_P42549 by 1024 in tablespace SYSAUX
Unified Audit record write to audit trail table failed due to ORA-1688. Writing the record to OS spillover file.
 

临时处理：

SQL >  select count(*) from unified_audit_trail;

SQL >  exec dbms_audit_mgmt.clean_audit_trail(audit_trail_type=>dbms_audit_mgmt.audit_trail_unified,use_last_arch_timestamp  =>  FALSE);

SQL >  select count(*) from unified_audit_trail;

彻底解决：How To Purge The UNIFIED AUDIT TRAIL (Doc ID 1582627.1)