export backup daily full

datapump: scripts: export backup daily full.sh

#********************************************************************************
#                            DATA PUMP EXPORTS
#********************************************************************************
#********************************************************************************
#  DAILY BACKUP
#********************************************************************************
00 21 * * 1-6 /usr/bin/ksh /oracle/u06/exports/MRORM1/scripts/backup_daily_full.ksh MRORM1
#********************************************************************************
#  DELETE BACKUP
#********************************************************************************
00 22 * * * /usr/bin/ksh /oracle/u06/exports/MRORM1/scripts/delete_backup.ksh 





$ cat /oracle/u01/app/orabase/admin/MRORM1/dpdump/scripts/backup_daily_full.ksh


#!/bin/ksh
set -x
INSTANCIA=$1
export ORACLE_SID=$INSTANCIA
export DATA_PUMP_DIR=/oracle/u01/app/orabase/admin/MROTEST1/dpdump/
export ORACLE_HOME=/oracle/u01/app/orabase/product/11.2.0/dbhome_2
export PATH=$PATH:$ORACLE_HOME/bin
export EXPORT=full
export FECHA=`date '+%d%m%Y_%H%M%S'`
export NOMBRE_ARCHIVO=expdp_${EXPORT}_${INSTANCIA}_${FECHA}.dmp
export LOG=expdp_${EXPORT}_${INSTANCIA}_${FECHA}.log
expdp USERID=\'/ as sysdba\' Full=Y DUMPFILE=$NOMBRE_ARCHIVO DIRECTORY=$DATA_PUMP_DIR LOGFILE=$LOG EXCLUDE=statistics 
sleep 10
echo 'Comprimiendo archivo '$BACKUP/$NOMBRE_ARCHIVO
echo $(date)
/usr/bin/gzip $DATA_PUMP_DIR/$NOMBRE_ARCHIVO
if [ $? -ne 0 ]; then
echo "Falla al comprimir el archivo";
exit 1;
fi

echo  " Begin backup of controlfile " 
${ORACLE_HOME}/bin/sqlplus -s <<EOF
/ as sysdba
set heading off   feedback off
alter database backup controlfile to trace as '${BACKUP}/backup_control_${ORACLE_SID}_${FECHA}.ctl';
exit
EOF

echo 'Comprimiendo Controlfile'
/usr/bin/gzip ${BACKUP}/backup_control_${ORACLE_SID}_${FECHA}.ctl

/usr/bin/find $BACKUP/*.log -atime +14 -exec rm {} \;
/usr/bin/find $BACKUP/*.dmp.gz -atime +14 -exec rm {} \;
/usr/bin/find $BACKUP/*.ctl.gz -atime +14 -exec rm {} \;

#!/bin/sh

find /oracle/u01/app/orabase/admin/MRORM1/dpdump/*.* -mtime +7 -exec rm {} \;