backup.sh

database Backup Script.
#Back up of Entire Database
#############################################################################
set -x
#/bin/bash
export ORACLE_UNQNAME=payprodb;
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1;
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/local/bin:/bin;
export DD=`date +%Y%m%d%H%M`;
export EXP_PUMP_DR=/u01/app/oracle/admin/payprodb/dpdump/;
export VDATE=`date +%c`;
#############################################################################

sqlplus "sys/Spice_123@payprodb as sysdba" <<EOF
alter system set undo_retention=30000;
exit;
EOF
expdp  system/Spice_123@payprodb directory=DATA_PUMP_DIR full=y parallel=8 filesize=15G dumpfile=expdp_full_${ORACLE_UNQNAME}_`date +"%d_%B_%Y_%H.%M"`_%u.dmp  logfile=full_log_${ORACLE_UNQNAME}_expdp_`date +"%d_%B_%Y_%H.%M"`.log CLUSTER=N

sqlplus "sys/Spice_123@payprodb as sysdba" <<EOF
alter system set undo_retention=1500;
exit;
EOF


chmod -R 777 /u01/app/oracle/admin/payprodb/dpdump/*

chown -R oracle:oinstall /u01/app/oracle/admin/payprodb/dpdump/*

find ${EXP_PUMP_DR}/pumpgzdel/*.gz      -mtime +1 -type f -exec rm -f {} \;

find ${EXP_PUMP_DR}/dmpdel/*.dmp      -mtime +1 -type f -exec rm -f {} \;


if [ "`tail -10 ${EXP_PUMP_DR}/*.log |grep -E 'successfully completed' `" ]
then
    echo " Removing all files older than 1 days"

	fi