Wednesday, December 19, 2012

Script for logical backup and compress files using expdp

export ORACLE_SID=vygrdevd
export ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/db_1
echo $ORACLE_HOME
echo $ORACLE_SID
echo ' BACKING UP VYGRDEVD DB FULL LEVEL'
export dumpfilepath=vygrdevd_expdp_full_`date +%d%m%y%H%M`.dmp
export logfilepath=vygrdevd_expdp_full_`date +%d%m%y%H%M`.log
echo 'Creating the dump files...'
echo 'Dump file = $dumpfilepath'
echo 'Log file = $logfilepath'
expdp system/oracle@vygrdevd dumpfile=$dumpfilepath logfile=$logfilepath full=y directory=daily_backup "EXCLUDE=SCHEMA:\"='SYSMAN'\"" parallel=3
echo 'Compressing to save space...'
zip /data/data_dump/daily_backup/$dumpfilepath.gz /data/data_dump/daily_backup/$dumpfilepath
zip /data/data_dump/daily_backup/$logfilepath.gz /data/data_dump/daily_backup/$logfilepath
rm -f /data/data_dump/daily_backup/$dumpfilepath
rm -f /data/data_dump/daily_backup/$logfilepath
echo 'BELOW ARE THE BACKUP FILES CHECK WITH REFRENCE TO DATE'
cd /data/data_dump/daily_backup
ls -l
pwd

No comments: