export job auto

00 22 * * * /home/oracle/DBATOOLS/exp/exp.ksh > /home/oracle/DBATOOLS/exp.log
iqcbdbpmdashora1:/home/oracle>>cat /home/oracle/DBATOOLS/exp/exp.ksh
#!/bin/sh
. /home/oracle/.setup_QCRBD20.ksh
cd
cd /backup/oracle/BKP
rm CED_SCHEMA_*.dmp* CED_SCHEMA*.log
cd /backup/oracle/BKP
find  -mtime +2 -type f -exec rm -rf {} \;
expdate=`date '+%d%m%h%Y'`
dat=`date '+%m%d%y_%H%M%S'`
echo "Backup started..." $dat;
expdp  \"/ as sysdba\"  DIRECTORY=BKPCED DUMPFILE=CED_SCHEMA_%U.dmp LOGFILE=CED_SCHEMA_exp.log schemas=CED,GLOBALSEARCH parallel=10
echo "Backup Completed." $dat;
echo "Zipping files Started." $dat;
gzip /backup/oracle/BKP/CED_SCHEMA_*.dmp
echo "Zipping files completed." $dat;