昨晚正在外滩玩,有个客户发过来一段报错,已经影响到业务了。一看就是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)