19c环境ORA-02002,ORA-01653告警

客户反馈数据库无法登录了，登录告警如下

登录环境查看，发现system也没有满，如下，为啥system表空间还空余430M就无法写入了。自动扩展每次扩展10M。

查看审计数据，确实比较的大了

SQL > select count(*) total from sys.AUD$;
 
     TOTAL
----------
 137957175

查看alert日志，也告警

2024-07-12T10:06:54.743050+08:00
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
2024-07-12T10:06:54.745042+08:00
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
2024-07-12T10:06:54.746293+08:00
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
2024-07-12T10:06:54.748112+08:00
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
2024-07-12T10:06:54.749938+08:00
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
2024-07-12T10:06:54.870302+08:00
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
2024-07-12T10:06:56.358987+08:00
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
2024-07-12T10:06:56.627868+08:00
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
2024-07-12T10:06:56.871082+08:00
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM

因有备份，直接清理了恢复业务，

SQL >  truncate table sys.aud$;

查看数据文件 next增长大小

set pagesize 199 linesize 199;
col FILE_NAME for a50;
SELECT FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE,increment_by*8/1024 "Next(MB)" FROM dba_data_files;

#increment_by 默认自增1个数据块，即8K字节