当前位置：首页 > news >正文

ORA-1688: unable to extend table AUDSYS.AUD$UNIFIED

news 2025/9/10 22:54:08

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

查看全文

http://www.lryc.cn/news/61059.html