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

linux Inodes满导致数据库宕机

news 2025/6/27 10:44:46

项目经理反馈集群环境中有个节点无法使用了需要支援下，同时发过来截图说明磁盘还是有空的。

登录系统后直接发现问题

orcl2:/home/oracle@db2> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 29 13:59:21 2024

ERROR:
0RA-09925:Unable to create audit trail file
Linux-x86 64 Error: 28:No space left on device
Additional information: 9925
ORA-01075:you are currently logged on

该类问题还是较为容易看到问题点，肯定是*.aud文件太多导致的问题

[root@db2 ~]# df -i
Filesystem       Inodes   IUsed    IFree IUse% Mounted on
/dev/sda5      41164800 102451 41062349    1% /
tmpfs          33050646    1635 33049011    1% /dev/shm
/dev/sda1         51200      39    51161    1% /boot
/dev/sda2       9601024 9601024        0 100% /u01

处理办法：

# find /u01/app/grid/product/11.2.0/grid_1/rdbms/audit/ -name "*.aud" -mmin +0 | xargs rm -rf "*.aud"
# find /u01/app/oracle/admin/orcl/adump/ -name "*.aud" -mmin +0 | xargs rm -rf "*.aud"

查看全文

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