合 Oracle adump目录爆满的解决方法

2022年1月13日  

0    1201    1

Tags： Oracle故障处理adump

👉 本文共约701个字，系统预计阅读时间或需3分钟。

显示/隐藏全文目录

目录

• 问题及解决
• 有关adump目录

问题及解决

Oracle 11.2.0.4环境，迁移到华为云，使用华为云的SMS工具迁移，

但是每次增量迁移都需要10小时左右，按理来说，增量没有这么大，

提工单，经过华为方查询，发现源端文件很多，导致比对时间太长，

我第一想到的就是adump文件或告警日志目录文件过多，

经过查询，告警目录文件不多，但是adump目录文件很多，小文件有30万个，大概1.2G左右

果断删除这些日志，然后进行SMS增量同步。

以下为操作过程：

[root@lhrdbs ~]# df -i Filesystem Inodes IUsed IFree IUse% Mounted on /dev/mapper/vg_lhrdbs-lv_root 82886656 469414 82417242 1% / tmpfs 8263266 3 8263263 1% /dev/shm /dev/sda1 128016 40 127976 1% /boot [oracle@lhrdbs orcl]$ ll total 22888 drwxr-x---. 2 oracle oinstall 23420928 Jan 13 09:00 adump drwxr-x---. 2 oracle oinstall 4096 Apr 6 2020 dpdump drwxr-x---. 2 oracle oinstall 4096 Apr 6 2020 pfile drwxr-x---. 2 oracle oinstall 4096 Apr 6 2020 scripts [oracle@lhrdbs orcl]$ [oracle@lhrdbs orcl]$ [oracle@lhrdbs orcl]$ ls -lR | grep "^-"| wc -l ^C [oracle@lhrdbs orcl]$ du -sh . 1.2G . [oracle@lhrdbs orcl]$ cd adump/ [oracle@lhrdbs adump]$ ll ^C [oracle@lhrdbs adump]$ ls -l total 1177976 -rw-r----- 1 oracle oinstall 798 Jan 6 2021 orcl_ora_10000_20210106074501859244143795.aud -rw-r----- 1 oracle oinstall 798 Feb 8 2021 orcl_ora_10000_20210208084502462747143795.aud -rw-r----- 1 oracle oinstall 799 Mar 5 2021 orcl_ora_10000_20210305014502553171143795.aud 。。。。。。。。。。 -rw-r----- 1 oracle oinstall 799 Sep 7 01:45 orcl_ora_10438_20210907014502508249143795.aud -rw-r----- 1 oracle oinstall 799 Nov 5 01:45 orcl_ora_10438_20211105014502519626143795.aud -rw-r----- 1 oracle oinstall 799 Nov 16 23:45 orcl_ora_10438_20211116234502875367143795.aud -rw-r----- 1 oracle oinstall 798 Dec 8 05:45 orcl_ora_10438_20211208054503072252143795.aud ^C-rw-r----- 1 oracle oinstall 799 Jan 8 02:45 orcl_ora_10438_20220108024501336869143795.aud [oracle@lhrdbs adump]$ ls -l | wc -l 294472 [oracle@lhrdbs adump]$ rm -rf orcl_ora_*.aud -bash: /bin/rm: Argument list too long [oracle@lhrdbs adump]$ rm -rf orcl_ora_10438_20211* [oracle@lhrdbs adump]$ rm -rf orcl_ora_10438_2021* [oracle@lhrdbs adump]$ rm -rf orcl_ora_10438_2020* [oracle@lhrdbs adump]$ ls -l | wc -l 294460 [oracle@lhrdbs adump]$ rm -rf orcl_ora_10* [oracle@lhrdbs adump]$ [oracle@lhrdbs adump]$ rm -rf orcl_ora_1* -bash: /bin/rm: Argument list too long [oracle@lhrdbs adump]$ rm -rf orcl_ora_12* [oracle@lhrdbs adump]$ find ./ -name "*" | xargs rm -rf '*' [oracle@lhrdbs adump]$ [oracle@lhrdbs adump]$ [oracle@lhrdbs adump]$ [oracle@lhrdbs adump]$ ll total 0 [oracle@lhrdbs adump]$ df -i Filesystem Inodes IUsed IFree IUse% Mounted on /dev/mapper/vg_lhrdbs-lv_root 82886656 163354 82723302 1% / tmpfs 8263266 3 8263263 1% /dev/shm /dev/sda1 128016 40 127976 1% /boot [oracle@lhrdbs adump]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 13 09:15:39 2022 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@lhrdbs adump]$ ll total 4 -rw-r----- 1 oracle oinstall 804 Jan 13 09:15 orcl_ora_21385_20220113091539101577143795.aud [oracle@lhrdbs adump]$ more orcl_ora_21385_20220113091539101577143795.aud Audit file /u01/app/oracle/admin/orcl/adump/orcl_ora_21385_20220113091539101577143795.aud Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1 System name: Linux Node name: lhrdbs Release: 2.6.32-431.el6.x86_64 Version: #1 SMP Sun Nov 10 22:19:54 EST 2013 Machine: x86_64 VM name: VMWare Version: 6 Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 118 Unix process pid: 21385, image: oracle@lhrdbs (TNS V1-V3) Thu Jan 13 09:15:39 2022 +08:00 LENGTH : '160' ACTION :[7] 'CONNECT' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[6] 'oracle' CLIENT TERMINAL:[5] 'pts/0' STATUS:[1] '0' DBID:[10] '1564813603' [oracle@lhrdbs adump]$ ll total 4 -rw-r----- 1 oracle oinstall 804 Jan 13 09:15 orcl_ora_21385_20220113091539101577143795.aud

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106

[root@lhrdbs ~]# df -i Filesystem                      Inodes  IUsed    IFree IUse% Mounted on /dev/mapper/vg_lhrdbs-lv_root 82886656 469414 82417242    1% / tmpfs                          8263266      3  8263263    1% /dev/shm /dev/sda1                       128016     40   127976    1% /boot   [oracle@lhrdbs orcl]$ ll total 22888 drwxr-x---. 2 oracle oinstall 23420928 Jan 13 09:00 adump drwxr-x---. 2 oracle oinstall     4096 Apr  6  2020 dpdump drwxr-x---. 2 oracle oinstall     4096 Apr  6  2020 pfile drwxr-x---. 2 oracle oinstall     4096 Apr  6  2020 scripts [oracle@lhrdbs orcl]$ [oracle@lhrdbs orcl]$ [oracle@lhrdbs orcl]$ ls -lR | grep "^-"| wc -l ^C [oracle@lhrdbs orcl]$ du -sh . 1.2G    . [oracle@lhrdbs orcl]$ cd adump/ [oracle@lhrdbs adump]$ ll ^C [oracle@lhrdbs adump]$ ls -l total 1177976 -rw-r-----  1 oracle oinstall   798 Jan  6  2021 orcl_ora_10000_20210106074501859244143795.aud -rw-r-----  1 oracle oinstall   798 Feb  8  2021 orcl_ora_10000_20210208084502462747143795.aud -rw-r-----  1 oracle oinstall   799 Mar  5  2021 orcl_ora_10000_20210305014502553171143795.aud   。。。。。。。。。。 -rw-r-----  1 oracle oinstall   799 Sep  7 01:45 orcl_ora_10438_20210907014502508249143795.aud -rw-r-----  1 oracle oinstall   799 Nov  5 01:45 orcl_ora_10438_20211105014502519626143795.aud -rw-r-----  1 oracle oinstall   799 Nov 16 23:45 orcl_ora_10438_20211116234502875367143795.aud -rw-r-----  1 oracle oinstall   798 Dec  8 05:45 orcl_ora_10438_20211208054503072252143795.aud ^C-rw-r-----  1 oracle oinstall   799 Jan  8 02:45 orcl_ora_10438_20220108024501336869143795.aud   [oracle@lhrdbs adump]$ ls -l | wc -l 294472 [oracle@lhrdbs adump]$ rm -rf orcl_ora_*.aud -bash: /bin/rm: Argument list too long [oracle@lhrdbs adump]$ rm -rf orcl_ora_10438_20211* [oracle@lhrdbs adump]$ rm -rf orcl_ora_10438_2021* [oracle@lhrdbs adump]$ rm -rf orcl_ora_10438_2020* [oracle@lhrdbs adump]$ ls -l | wc -l               294460 [oracle@lhrdbs adump]$ rm -rf orcl_ora_10* [oracle@lhrdbs adump]$ [oracle@lhrdbs adump]$ rm -rf orcl_ora_1* -bash: /bin/rm: Argument list too long [oracle@lhrdbs adump]$ rm -rf orcl_ora_12* [oracle@lhrdbs adump]$ find ./ -name "*" | xargs rm -rf '*' [oracle@lhrdbs adump]$ [oracle@lhrdbs adump]$ [oracle@lhrdbs adump]$ [oracle@lhrdbs adump]$ ll total 0 [oracle@lhrdbs adump]$ df -i Filesystem                      Inodes  IUsed    IFree IUse% Mounted on /dev/mapper/vg_lhrdbs-lv_root 82886656 163354 82723302    1% / tmpfs                          8263266      3  8263263    1% /dev/shm /dev/sda1                       128016     40   127976    1% /boot   [oracle@lhrdbs adump]$ sqlplus / as sysdba   SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 13 09:15:39 2022   Copyright (c) 1982, 2013, Oracle.  All rights reserved.   Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options   SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@lhrdbs adump]$ ll total 4 -rw-r----- 1 oracle oinstall 804 Jan 13 09:15 orcl_ora_21385_20220113091539101577143795.aud [oracle@lhrdbs adump]$ more orcl_ora_21385_20220113091539101577143795.aud Audit file /u01/app/oracle/admin/orcl/adump/orcl_ora_21385_20220113091539101577143795.aud Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1 System name:    Linux Node name:      lhrdbs Release:        2.6.32-431.el6.x86_64 Version:        #1 SMP Sun Nov 10 22:19:54 EST 2013 Machine:        x86_64 VM name:        VMWare Version: 6 Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 118 Unix process pid: 21385, image: oracle@lhrdbs (TNS V1-V3)   Thu Jan 13 09:15:39 2022 +08:00 LENGTH : '160' ACTION :[7] 'CONNECT' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[6] 'oracle' CLIENT TERMINAL:[5] 'pts/0' STATUS:[1] '0' DBID:[10] '1564813603'   [oracle@lhrdbs adump]$ ll total 4 -rw-r----- 1 oracle oinstall 804 Jan 13 09:15 orcl_ora_21385_20220113091539101577143795.aud

Inode参考：https://www.dbaup.com/linux-inodejieshao.html?hilite=IUsed

报错“Argument list too long”的解决办法：https://www.dbaup.com/baocuoargument-list-too-longdejiejuebanfa.html

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。

相关文章

• Oracle环境中报错TNS-00511、TNS-12541、No listener，其实监听已启动
• 客户某套Oracle rac业务库出现严重的library cache等待排查
• Oracle rac排查故障时不生成日志的情况排查(npohasd文件)
• Oracle启动报错terminating the instance due to error 119
• 在Oracle中，错误“ORA-12560 TNS 协议适配器错误 protocol adapter error”的常见原因有哪些？
• 静默安装Oracle软件报错[FATAL] [INS-32035] Unable to create a new central inventory at the specified location
• [INS-32104] Specified Oracle Home user is not the owner of the specified Oracle Base
• 启动Oracle数据库报错ORA-48173、ORA-48187、OSD-00002、O/S-Error: (OS 5) Access is denied
• Oracle rac不能监听public ip
• 在Oracle中，“ORA-01017: invalid username/password; logon denied”的常见原因有哪些？
• [FATAL] [INS-06006] Passwordless SSH connectivity not set up between the following node(s): [rac2]
• Oracle 11.2.0.4数据泵expdp导出报DBMS_AW_EXP等信息
• Oracle DG环境中的gap处理办法总结
• 备库数据文件异常，物理DG如何恢复？
• 如果oracle用户下的$ORACLE_HOME/bin/oracle文件的属主或权限出了问题，那么该如何修复呢？
• 如果$GRID_HOME或$GRID_BASE或/u01目录下的所有文件权限被人为误操作修改了，那么如何来修复该权限问题？
• Oracle rac环境将datafile创建到本地文件系统的处理步骤
• CRS-1153: There was an error setting Oracle Clusterware to rolling patch mode
• ORA-01920: user name 'ASMSNMP' conflicts with another user or role name
• ORA-06502: PL/SQL: numeric or value error: character string buffer too small

打赏赞(1)分享

标签： Oracle故障处理adump

小麦苗

学习或考证，均可联系麦老师，请加微信db_bao或QQ646634621

• 下一篇 Linux搭建ftp服务工具之pure-ftpd
• 上一篇 Linux统计文件夹中文件个数以及目录个数

您可能还喜欢...

• 0

  在Oracle中，什么是物理读和逻辑读？

  2022年8月13日

   由 小麦苗 · Published 2022年8月13日 · Last modified 2022年8月18日

  · 已更新 2022年8月18日  

  0    469    1
• 0

  Oracle11g版本对 SQLPlus错误日志的记录功能--errorlogging参数

  2022年11月8日

   由 小麦苗 · Published 2022年11月8日

   

  0    240    1
• 0

  【DB宝27】在Oracle 19c中创建容器数据库（4）--Duplicating a CDB（从18c开始）

  2021年6月21日

   由 小麦苗 · Published 2021年6月21日 · Last modified 2021年8月6日

  · 已更新 2021年8月6日  

  0    7805    4