[linux] database or disk is full:排查过程

博主在Linux系统中程序运行失败,经排查发现是磁盘占用问题。了解到Linux垃圾回收与回收站概念不同,删除文件在未清空回收站时可找回。通过指令一级级筛选找到占用最大的文件夹,发现Trash中有曾删除文件,删除后问题解决。

折腾了我两天,还导致程序没能跑成功。而且linux没有垃圾回收,被我认为是没有垃圾回收站了,这个是自己该打。
垃圾回收 != 垃圾回收站,删除了linux文件是可以找回的,只要没有清空垃圾回收站, 这一点和windows是一样的。但是很多博主说linux没有垃圾回收,这一块我还是不太懂,但是解决燃眉之急再说叭,谁知道以后会不会有再说?

一句easy的指令,问题解决,f**k

sudo rm -rf /home/G/.local/share/Trash/files/

分割线---------------------------------------------------------------------------------------------------------------------分割线
分割线---------------------------------------------------以下是排查过程---------------------------------------------分割线
分割线---------------------------------------------------------------------------------------------------------------------分割线

排错的过程

df -h

找到磁盘占用最大的,然后一级一级筛选找到占用最大的。
这里是/home占用最大

Filesystem      Size  Used Avail Use% Mounted on
udev             48G     0   48G   0% /dev
tmpfs           9.5G   67M  9.4G   1% /run
/dev/nvme0n1p6  450G  661M  427G   1% /
/dev/sdb1       1.8T   16G  1.7T   1% /usr
tmpfs            48G  876K   48G   1% /dev/shm
tmpfs           5.0M  4.0K  5.0M   1% /run/lock
tmpfs            48G     0   48G   0% /sys/fs/cgroup
/dev/nvme0n1p1  945M   62M  819M   7% /boot
/dev/sdd1       1.8T   68M  1.7T   1% /opt
/dev/sdf1       9.1T   40M  8.6T   1% /data1
/dev/sde1       9.1T  1.9T  6.7T  23% /data
/dev/sdc1       1.8T  858M  1.7T   1% /var
/dev/sda1       1.8T  1.2T  583G  67% /home
tmpfs           9.5G   68K  9.5G   1% /run/user/1004
tmpfs           9.5G   76K  9.5G   1% /run/user/1003
tmpfs           9.5G   72K  9.5G   1% /run/user/1005
tmpfs           9.5G     0  9.5G   0% /run/user/1008

进入home,在该节点下继续找最大的文件夹,/home下文件按照大小排序输出

cd /home
du -sh *|sort -n 
1.9G    A
2.4G    B
9.6G    C
16K     lost+found
17G     D
45G     E
46G     F
79G     G------------本人目录
230G    H
548G    I

假设最大的是本人的文件夹,进入G目录,详细查看文件大小

cd G
du -h --max-depth=1
6.8G    ./1
217M    ./2
8.0K    ./.keras
110M    ./.cache
965M    ./3
484K    ./.local
80K     ./4
652K    ./5
882M    ./6
3.7G    ./7
4.0K    ./8
16K     ./8
12K     ./10
2.5M    ./11
8.0K    ./12
52G     ./13
79G     .

看着这三个文件夹,和windows好像啊。然后博主最大的是 ./.local,一层一层的进入看目录结构

G@zkyd:~$ cd ./.local
G@zkyd:~/.local$ ls
share
G@zkyd:~/.local$ cd share
G@zkyd:~/.local/share$ ls
jupyter  Trash
G@zkyd:~/.local/share$ cd Trash
G@zkyd:~/.local/share/Trash$ ls
info files
G@zkyd:~/.local/share/Trash$ cd files
G@zkyd:~/.local/share/Trash/files$ ls
xx xx xx xx xx xx

惊喜一:居然有Trash;
惊喜二:files里面居然是我曾经删除过的的文件
接着删除掉就OK了

G@zkyd:~/.local/share/Trash/files$ cd ..
G@zkyd:~/.local/share/Trash$ rm -r files

OK 了,大功告成!

Connect identifier for DB_UNIQUE_NAME orclpri not configured using channel ORA_DISK_1 specification does not match any archived log in the repository backup cancelled because there are no files to backup Finished backup at 14-MAY-25 Starting backup at 14-MAY-25 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 14-MAY-25 channel ORA_DISK_1: finished piece 1 at 14-MAY-25 piece handle=/home/oracle/backup/controlfile/control_ORCL_20250514_153pe9j9_1_1.ctl tag=TAG20250514T113505 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 14-MAY-25 Starting backup at 14-MAY-25 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 14-MAY-25 channel ORA_DISK_1: finished piece 1 at 14-MAY-25 piece handle=/home/oracle/backup/controlfile/spfile_ORCL_20250514_163pe9jb_1_1.sp tag=TAG20250514T113507 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 14-MAY-25 Starting Control File and SPFILE Autobackup at 14-MAY-25 piece handle=/home/oracle/backup/controlfile/cf_c-1728828233-20250514-02 comment=NONE Finished Control File and SPFILE Autobackup at 14-MAY-25 RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 using channel ORA_DISK_1 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 2 14-MAY-25 Backup Piece 2 14-MAY-25 /home/oracle/app/oracle/product/11.2.0/db_1/dbs/0v3pe90t_1_1 Backup Set 5 14-MAY-25 Backup Piece 5 14-MAY-25 /home/oracle/backup/controlfile/cf_c-1728828233-20250514-01 Backup Set 8 14-MAY-25 Backup Piece 8 14-MAY-25 /home/oracle/backup/controlfile/control_ORCL_20250514_153pe9j9_1_1.ctl Backup Set 9 14-MAY-25 Backup Piece 9 14-MAY-25 /home/oracle/backup/controlfile/spfile_ORCL_20250514_163pe9jb_1_1.sp deleted backup piece backup piece handle=/home/oracle/app/oracle/product/11.2.0/db_1/dbs/0v3pe90t_1_1 RECID=2 STAMP=1201087517 deleted backup piece backup piece handle=/home/oracle/backup/controlfile/cf_c-1728828233-20250514-01 RECID=5 STAMP=1201087555 deleted backup piece backup piece handle=/home/oracle/backup/controlfile/control_ORCL_20250514_153pe9j9_1_1.ctl RECID=8 STAMP=1201088106 deleted backup piece backup piece handle=/home/oracle/backup/controlfile/spfile_ORCL_20250514_163pe9jb_1_1.sp RECID=9 STAMP=1201088107 Deleted 4 objects using channel ORA_DISK_1 specification does not match any backup in the repository using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/backup/datafile/full_ORCL_20250514_0u3pe90s_1_1.bkp RECID=1 STAMP=1201087516 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/backup/datafile/full_ORCL_20250514_133pe9ie_1_1.bkp RECID=6 STAMP=1201088078 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/app/oracle/product/11.2.0/db_1/dbs/143pe9if_1_1 RECID=7 STAMP=1201088079 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/backup/controlfile/cf_c-1728828233-20250514-02 RECID=10 STAMP=1201088108 Crosschecked 4 objects released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=146 device type=DISK validation succeeded for archived log archived log file name=/home/oracle/app/arch/1_45_1201047499.dbf RECID=19 STAMP=1201086944 validation succeeded for archived log archived log file name=/home/oracle/app/arch/1_46_1201047499.dbf RECID=20 STAMP=1201086999 Crosschecked 2 objects RMAN>
05-21
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值