参考:https://blog.csdn.net/yucdsn/article/details/81449676
今天rman还原失败 ,删掉重做,发现空间不能回收
[root@histest his]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 772G 668G 66G 92% /
/dev/sda1 477M 55M 397M 13% /boot
tmpfs 15G 224K 15G 1% /dev/shm
/opt/OracleLinux-R6-U5-Server-x86_64-dvd.iso 3.7G 3.7G 0 100% /opt/cdrom
查看哪些进程没有释放。
[root@histest his]# lsof |grep deleted
sshd 705 root txt REG 8,3 2373136 34620971 /usr/sbin/sshd (deleted)
Xorg 3774 root txt REG 8,3 2274240 34619319 /usr/bin/Xorg (deleted)
gdm-sessi 3921 root txt REG 8,3 108680 34616357 /usr/libexec/gdm-session-worker.#prelink#.aKOnMa (deleted)
sleep 6223 oracle cwd DIR 8,3 0 50334178 /home/oracle/backup/oswbb (deleted)
sleep 6223 oracle 1w REG 8,3 1735808283 50334205 /home/oracle/backup/oswbb/nohup.out (deleted)
sleep 6223 oracle 2w REG 8,3 1735808283 50334205 /home/oracle/backup/oswbb/nohup.out (deleted)
sleep 6263 oracle cwd DIR 8,3 0 50334178 /home/oracle/backup/oswbb (deleted)
sleep 6263 oracle 1w REG 8,3 1735808283 50334205 /home/oracle/backup/oswbb/nohup.out (deleted)
sleep 6263 oracle 2w REG 8,3 1735808283 50334205 /home/oracle/backup/oswbb/nohup.out (deleted)
gnome-ter 9669 oracle 22u REG 8,3 6226 29884425 /tmp/vteY5OBOZ (deleted)
gnome-ter 9669 oracle 23u REG 8,3 2576 29884428 /tmp/vteU3OBOZ (deleted)
gnome-ter 9669 oracle 24u REG 8,3 80 29884429 /tmp/vteJ6XQOZ (deleted)
oracle 10408 oracle 258u REG 8,3 1342185472 40241354 /ora/u00/oracle/oradata/his/system.256.898847481 (deleted)
oracle 10408 oracle 259u REG 8,3 20782784512 40241337 /ora/u00/oracle/oradata/his/sysaux.257.898847483 (deleted)
oracle 10408 oracle 260u REG 8,3 702554112 40241341 /ora/u00/oracle/oradata/his/undotbs1.258.898847483 (deleted)
oracle 10408 oracle 261u REG 8,3 6442459136 40241353 /ora/u00/oracle/oradata/his/users.259.898847483 (deleted)
oracle 10408 oracle 262u REG 8,3 734011392 40241340 /ora/u00/oracle/oradata/his/undotbs2.264.898847675 (deleted)
oracle 10408 oracle 263u REG 8,3 34330386432 40241328 /ora/u00/oracle/oradata/his/hisdata.dbf (deleted)
oracle 10408 oracle 264u REG 8,3 21453873152 40241351 /ora/u00/oracle/oradata/his/hisindex.dbf (deleted)
oracle 10408 oracle 265u REG 8,3 1048584192 40241355 /ora/u00/oracle/oradata/his/histemp.dbf (deleted)
oracle 10408 oracle 266u REG 8,3 34330386432 40241342 /ora/u00/oracle/oradata/his/hisdata02.dbf (deleted)
oracle 10408 oracle 267u REG 8,3 16106135552 40241338 /ora/u00/oracle/oradata/his/hisindex02.dbf (deleted)
oracle 10408 oracle 268u REG 8,3 5242888192 40241339 /ora/u00/oracle/oradata/his/hisdata03.dbf (deleted)
oracle 10408 oracle 269u REG 8,3 33554440192 40241346 /ora/u00/oracle/oradata/his/hisdata04.dbf (deleted)
oracle 10408 oracle 270u REG 8,3 33554440192 40241332 /ora/u00/oracle/oradata/his/hisdata05.dbf (deleted)
oracle 10408 oracle 271u REG 8,3 33554440192 40241347 /ora/u00/oracle/oradata/his/hisdata06.dbf (deleted)
oracle 10408 oracle 272u REG 8,3 33554440192 40241333 /ora/u00/oracle/oradata/his/hisdata07.dbf (deleted)
oracle 10408 oracle 273u REG 8,3 34162614272 40241329 /ora/u00/oracle/oradata/his/hisdata08.dbf (deleted)
oracle 10408 oracle 274u REG 8,3 34162614272 40241343 /ora/u00/oracle/oradata/his/hisdata09.dbf (deleted)
oracle 10408 oracle 275u REG 8,3 34162614272 40241330 /ora/u00/oracle/oradata/his/hisdata10.dbf (deleted)
oracle 10408 oracle 276u REG 8,3 34162614272 40241344 /ora/u00/oracle/oradata/his/hisdata11.dbf (deleted)
oracle 10408 oracle 277u REG 8,3 34162614272 40241331 /ora/u00/oracle/oradata/his/hisdata12.dbf (deleted)
oracle 10408 oracle 278u REG 8,3 34057756672 40241345 /ora/u00/oracle/oradata/his/hisdata13.dbf (deleted)
oracle 10408 oracle 279u REG 8,3 11140079616 40241352 /ora/u00/oracle/oradata/his/hisdata14.dbf (deleted)
oracle 10408 oracle 280u REG 8,3 32212262912 40241348 /ora/u00/oracle/oradata/his/hisdata.288.993566695 (deleted)
oracle 10408 oracle 281u REG 8,3 32212262912 40241334 /ora/u00/oracle/oradata/his/hisdata.289.993566833 (deleted)
oracle 10408 oracle 282u REG 8,3 32212262912 40241349 /ora/u00/oracle/oradata/his/hisdata.290.995987633 (deleted)
oracle 10408 oracle 283u REG 8,3 32212262912 40241335 /ora/u00/oracle/oradata/his/hisdata.291.995987759 (deleted)
oracle 10408 oracle 284u REG 8,3 32212262912 40241350 /ora/u00/oracle/oradata/his/hisdata.292.995987955 (deleted)
oracle 10408 oracle 285u REG 8,3 32212262912 40241336 /ora/u00/oracle/oradata/his/hisdata.293.995988233 (deleted)
oracle 10410 oracle 256u REG 8,3 33554440192 40241333 /ora/u00/oracle/oradata/his/hisdata07.dbf (deleted)
oracle 10410 oracle 257u REG 8,3 33554440192 40241347 /ora/u00/oracle/oradata/his/hisdata06.dbf (deleted)
oracle 10410 oracle 258u REG 8,3 34057756672 40241345 /ora/u00/oracle/oradata/his/hisdata13.dbf (deleted)
oracle 10410 oracle 259u REG 8,3 32212262912 40241349 /ora/u00/oracle/oradata/his/hisdata.290.995987633 (deleted)
oracle 10410 oracle 260u REG 8,3 32212262912 40241334 /ora/u00/oracle/oradata/his/hisdata.289.993566833 (deleted)
oracle 10410 oracle 261u REG 8,3 32212262912 40241348 /ora/u00/oracle/oradata/his/hisdata.288.993566695 (deleted)
oracle 10410 oracle 262u REG 8,3 34162614272 40241331 /ora/u00/oracle/oradata/his/hisdata12.dbf (deleted)
oracle 10410 oracle 263u REG 8,3 33554440192 40241332 /ora/u00/oracle/oradata/his/hisdata05.dbf (deleted)
oracle 10410 oracle 264u REG 8,3 33554440192 40241346 /ora/u00/oracle/oradata/his/hisdata04.dbf (deleted)
oracle 10410 oracle 265u REG 8,3 34162614272 40241344 /ora/u00/oracle/oradata/his/hisdata11.dbf (deleted)
oracle 10410 oracle 266u REG 8,3 34162614272 40241343 /ora/u00/oracle/oradata/his/hisdata09.dbf (deleted)
oracle 10410 oracle 267u REG 8,3 34162614272 40241329 /ora/u00/oracle/oradata/his/hisdata08.dbf (deleted)
oracle 10410 oracle 268u REG 8,3 34162614272 40241330 /ora/u00/oracle/oradata/his/hisdata10.dbf (deleted)
oracle 10410 oracle 269u REG 8,3 32212262912 40241335 /ora/u00/oracle/oradata/his/hisdata.291.995987759 (deleted)
oracle 10410 oracle 270u REG 8,3 734011392 40241340 /ora/u00/oracle/oradata/his/undotbs2.264.898847675 (deleted)
oracle 10410 oracle 271u REG 8,3 11140079616 40241352 /ora/u00/oracle/oradata/his/hisdata14.dbf (deleted)
oracle 10410 oracle 272u REG 8,3 34330386432 40241342 /ora/u00/oracle/oradata/his/hisdata02.dbf (deleted)
oracle 10410 oracle 273u REG 8,3 20782784512 40241337 /ora/u00/oracle/oradata/his/sysaux.257.898847483 (deleted)
oracle 10410 oracle 274u REG 8,3 21453873152 40241351 /ora/u00/oracle/oradata/his/hisindex.dbf (deleted)
oracle 10410 oracle 275u REG 8,3 34330386432 40241328 /ora/u00/oracle/oradata/his/hisdata.dbf (deleted)
oracle 10410 oracle 276u REG 8,3 32212262912 40241336 /ora/u00/oracle/oradata/his/hisdata.293.995988233 (deleted)
oracle 10410 oracle 277u REG 8,3 32212262912 40241350 /ora/u00/oracle/oradata/his/hisdata.292.995987955 (deleted)
oracle 10410 oracle 278u REG 8,3 702554112 40241341 /ora/u00/oracle/oradata/his/undotbs1.258.898847483 (deleted)
oracle 10410 oracle 279u REG 8,3 16106135552 40241338 /ora/u00/oracle/oradata/his/hisindex02.dbf (deleted)
oracle 10410 oracle 280u REG 8,3 1342185472 40241354 /ora/u00/oracle/oradata/his/system.256.898847481 (deleted)
OSWatcher 14146 oracle cwd DIR 8,3 0 50334178 /home/oracle/backup/oswbb (deleted)
OSWatcher 14146 oracle 1w REG 8,3 1735808283 50334205 /home/oracle/backup/oswbb/nohup.out (deleted)
OSWatcher 14146 oracle 2w REG 8,3 1735808283 50334205 /home/oracle/backup/oswbb/nohup.out (deleted)
OSWatcher 14146 oracle 255r REG 8,3 35108 50334190 /home/oracle/backup/oswbb/OSWatcher.sh (deleted)
OSWatcher 14196 oracle cwd DIR 8,3 0 50334178 /home/oracle/backup/oswbb (deleted)
OSWatcher 14196 oracle 1w REG 8,3 1735808283 50334205 /home/oracle/backup/oswbb/nohup.out (deleted)
OSWatcher 14196 oracle 2w REG 8,3 1735808283 50334205 /home/oracle/backup/oswbb/nohup.out (deleted)
OSWatcher 14196 oracle 255r REG 8,3 5062 50334197 /home/oracle/backup/oswbb/OSWatcherFM.sh (deleted)
运行以下命令后解决
kill -9 10410
kill -9 10408