Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DUMP FILES UNABLE TO DELETE IN LINUX

991805Feb 19 2013 — edited Feb 20 2013
Hi

Our company currently runs the databases on RAC (Oracle 11gR2). We generally take the backup of SCHEMAS everyday using the datapump. My issues here is I am unable to delete the dump files older that 3 days using the below script

00 14 * * * find /nbds2/orabkp/*.dmp.gz -mtime +3 -exec rm -f {} \;

but I am able to delete the files using the below command

rm -f abcb.dmp.gz . I verified the file permissions etc on the dump file that is generated everything looks fine.

Even I tried using the below script

#################cut here - rmdumpfiles #############
#!/bin/bash

echo "starting at `date`"
for i in `find /nbds2/orabkp -mtime +3 -name "*.dmp.gz" `
do
echo "deleting $i "
rm -f $i
done
echo "done at `date` "

#################################################
chmod 750 rmdumpfiles

Crontab entry:
00 14 * * * /home/oracle/rmdumpfiles >> /home/oracle/rmdump.log

But the files didn't get deleted and below is the information I got from the log file

"starting at Mon Feb 18 17:59:01 PST 2013
done at Mon Feb 18 17:59:01 PST 2013"

Can someone help me please

Thank you

Karren
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2013
Added on Feb 19 2013
14 comments
1,400 views