Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How keep only one copy .dmp?
Remove the -mtime option and delete the file if it exists
The downside is that if the export fails you have no previous version
The other option would be to do a ls for compressed dumpfiles and rename them and then delete those after the export has worked
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex
Sent: 17 July 2007 15:51
To: oracle-l_at_freelists.org
Subject: How keep only one copy .dmp?
How can I set my script to only keep one copy of a dump file? On Linux, I have the following line in the script (which is run nightly by cron). Yet I always seem to end up with 2 days worth of dmp files which are using up too much space. I only want for there to be one copy that stays on the server.
find $DMPDIR -name "*" -mtime +0 -exec rm {} \;
Rest of script that follows that line:
DT=`date +%Y%m%d%H%M`
gzip < $EXPPIPE > $DMPDIR/${ORACLE_SID}_full.dmp.${DT}.gz &
$ORACLE_HOME/bin/exp system/$exppass full=y file=$EXPPIPE log=$DMPDIR/${ORACLE_SID}_full_1db_exp_${DT}.log consistent=y compress=y
#Check log for errors below
cd $DMPDIR
grep -c "EXP-" ${ORACLE_SID}_full_1db_exp_${DT}.log > /dev/null
if [ $? = 0 ]
then
echo "failed export" | mail -s "export of $ORACLE_SID FAILED CHECK LOG FOR
DETAILS" `cat $MAIL/dba`
exit 1
fi
exit
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 17 2007 - 10:29:28 CDT
![]() |
![]() |