oracle导出mysqldump脚本

#!/bin/sh

FILE_DATE=`date '+%Y%m%d-%H%M%S'`
DUMP_DIR=/u01/backup
SAVED_DAY=7
SAVED_DAY2=2
DUMP_FILE=$DUMP_DIR/AAA_$FILE_DATE.dmp
DUMP_FILElog=$DUMP_DIR/AAA_$FILE_DATE.log
ZIP_FILE=$DUMP_DIR/AAA_$FILE_DATE.dmp.gz

expdp system/system  directory=dump_dir SCHEMAS=AAA dumpfile=AAA_`date +%Y%m%d-%H%M%S`.dmp logfile=AAA_`date +%Y%m%d-%H%M%S`.log exclude=statistics

gzip -c $DUMP_FILE > $ZIP_FILE

#rm -f $DUMP_FILE

fcount=`ls /ncfile/nc_dump/AAA*.dmp | wc -l`
while [ $fcount -gt $SAVED_DAY2 ]
do
        delfile=`ls -lt $DUMP_DIR/AAA*.dmp | awk '{line = $9} END {print line}'`
        rm -f $delfile
        fcount=`expr $fcount - 1`
        echo fcount=$fcount
        echo saved_day=$SAVED_DAY2
done

#rm -f $DUMP_FILElog

fcount=`ls /ncfile/nc_dump/AAA*.log | wc -l`
while [ $fcount -gt $SAVED_DAY2 ]
do
        delfile=`ls -lt $DUMP_DIR/AAA*.log | awk '{line = $9} END {print line}'`
        rm -f $delfile
        fcount=`expr $fcount - 1`
        echo fcount=$fcount
        echo saved_day=$SAVED_DAY2
done

#rm -f $ZIP_FILE

fcount=`ls /ncfile/nc_dump/AAA*.gz | wc -l`
while [ $fcount -gt $SAVED_DAY ]
do
        delfile=`ls -lt $DUMP_DIR/AAA*.gz | awk '{line = $9} END {print line}'`
        rm -f $delfile
        fcount=`expr $fcount - 1`
        echo fcount=$fcount
        echo saved_day=$SAVED_DAY
done