Hello,
OS version is Red Hat Enterprise Linux Server release 6.5 (Santiago).
In one of the filesystem some old files post clone are not getting removed even with 'rm'
# ls -ltr | grep meagpd_62.dbf
-rw-rw---- 1 oracle oinstall 34358697984 Sep 1 08:46 meagpd_62.dbf
# rm meagpd_62.dbf
rm: cannot remove `meagpd_62.dbf': No such file or directory
lsof | grep deleted
Also doesn't show any OPEN files.
We even tried rebooting the server, but the files still remain.
Please let me know, how should I proceed.
Thanks
RudiC
September 2, 2015, 6:35am
2
Does it possibly contain unprintable chars like <0x0D> (=^M)?
it is a Oracle Database Datafile... If I try to view the file, view treats it as a new file.
Hello saharookiedba,
I am pretty much sure it is because file name is not exactly what we are seeing on screen seems some extra non-printable characters added to file names, could you please try either ls -b
OR ls -q
and see if that helps you, let us know what happens after these commands execution.
EDIT: Just adding about commands details.
Thanks,
R. Singh
1 Like
Bingo,
Thanks a lot Ravinder.
# ls -ltrb
total 425979768
drwxr-xr-x 2 root root 96 Nov 10 2013 lost+found
-rw-rw---- 1 oracle oinstall 58310656 Sep 23 2014 control_2.ctl.23092014
-rw-rw---- 1 oracle oinstall 58310656 Sep 24 2014 control_2.ctl.24092014
drwxrwxr-x 2 oracle oinstall 8192 May 7 05:41 arch
-rw-rw---- 1 oracle oinstall 34358697984 Sep 1 08:45 meagpd_58.dbf\
-rw-rw---- 1 oracle oinstall 34358697984 Sep 1 08:46 meagpd_59.dbf\
-rw-rw---- 1 oracle oinstall 34358697984 Sep 1 08:46 meagpd_62.dbf\
-rw-rw---- 1 oracle oinstall 34358697984 Sep 1 08:46 meagpd_61.dbf\
-rw-rw---- 1 oracle oinstall 34358697984 Sep 1 08:46 meagpd_60.dbf\
-rw-rw---- 1 oracle oinstall 34358697984 Sep 1 08:47 meagpd_57.dbf\
Now, how should I delete them?
# rm "meagpd_62.dbf\"
>
Hello saharookiedba,
Happy to help you, you can hit Thank you button at the left corner of each post to thank any person here.
Also following are the steps for same.
1st: Get inum value for files by doing:
ls -il {file-name}
2nd: You can do following command to delete file with their inum value:
find . -inum [inode-number] -exec rm -i {} \;
Hope above helps, will be happy if that helps.
Thanks,
R. Singh
1 Like
RudiC
September 2, 2015, 8:27am
7
Why not just rm meagpd_62.dbf*
1 Like
Done..
Alert log showed that the file were added with suffix as space 'filename '. Therefore we were able to remove it with rm 'filename '.
Thanks a lot