AllSchemaBackup.sh

#!/bin/bash -x 
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1;
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/local/bin:/bin;


/u01/app/oracle/product/12.1.0/dbhome_1/bin/expdp  system/Spice_123@payprodb schemas=pre_dev,dev,oracleqa,demopp,mfs_dev,mfs_qa,sitpp,mfs_demo,mfs_sit directory=DATA_PUMP_DIR dumpfile=expdp_All_Schema_`date +"%d_%B_%Y"`.dmp  logfile=expdp_All_Schema_`date +"%d_%B_%Y"`.log 


filename=/home/payprodb/datapump/expdp_All_Schema_`date +"%d_%B_%Y"`.log

if grep "successfully completed" $filename
then
	mailx -s "Status for Backup of All DB Schema : Successful" rajesh.mahajan@spicelabs.in harnek.singh@spicelabs.in geetika.sharma@spicelabs.in  pankaj.kumar1@digispice.com < $filename
else
	mailx -s "Status for Backup of All DB Schema : Failure" pankaj.kumar1@digispice.com rajesh.mahajan@spicelabs.in harnek.singh@spicelabs.in geetika.sharma@spicelabs.in < $filename
fi
exit;