juin
05
2009

Oracle backup export script (cron job)

Here is script that I’ve created to make a logical backup of the entire database every day

######################### START OF SCRIPT #########################

#!/bin/bash
#Backup script by Cédric Sougné.
ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/product/db10g
ORACLE_SID=<yoursid>
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME PATH ORACLE_SID

ADMIN_EMAIL= »<yourdbamail> »
LOGFILE=$ORACLE_BASE/admin/$ORACLE_SID/backup_logs/expdp-`date +%d%m%y%H%M%S`.log

EXPORT_PATH=/opt/oracle/export_backup
DMP_FILE= »expdp-`date + »%d%m%Y_%H%M%S »`.dmp »
LOG_FILE= »expdp-`date + »%d%m%Y_%H%M%S »`.log »

echo « Starting … » > $LOGFILE
expdp \’sys/<yousyspassword> as sysdba\’ FULL=y DIRECTORY=EXPORT_BACKUP_DIR DUMPFILE=$DMP_FILE LOGFILE=$LOG_FILE
#expdp mrmrs/mrmrs TABLES=resident,sejour DIRECTORY=EXPORT_BACKUP_DIR DUMPFILE=$DMP_FILE LOGFILE=$LOG_FILE
cat $EXPORT_PATH/$LOG_FILE >> $LOGFILE
echo « Backup Completed. » >> $LOGFILE

echo « gzipping … » >> $LOGFILE
gzip $EXPORT_PATH/$DMP_FILE >> $LOGFILE
echo « gzipping Completed. » >> $LOGFILE

echo « Deleting old files » >> $LOGFILE
find $EXPORT_PATH -type f -mtime +31 | xargs rm >> $LOGFILE
echo « Delete Completed » >> $LOGFILE

cat $LOGFILE | mail -s « expdp-`date + »%d%m%Y_%T »` » $ADMIN_EMAIL

######################### END OF SCRIPT #########################

here is for the cron tab:

00 22 * * * /opt/oracle/admin/acisora1/scripts/export_backup.sh >> /dev/null

the script will be executed avery at 10 pm

Written by in: bash,linux,oracle | Mots-clefs :, , , ,

5 commentaires »

  • NiCLoAy dit :
    18 juin 2009 à 15 h 44 min

    Hi, thank you for script.
    But you have the error, you declare EXPORT_PATH but then use EXPORT_BACKUP_DIR

  • admin dit :
    23 juin 2009 à 10 h 11 min

    Hi NiCLoAy,
    Sorry I’ve forgotten to make a var with EXPORT_BACKUP_DIR. In fact,
    EXPORT_BACKUP_DIR is the name of a directory in oracle created with these sql:

    CREATE DIRECTORY EXPORT_BACKUP_DIR AS ‘/opt/oracle/export_backup’;

    Thanks for the comment I will update that soon.

  • Anita dit :
    29 septembre 2009 à 11 h 05 min

    Very useful. I tried this and working properly.

    Thanks a lot.

  • christian dit :
    16 octobre 2009 à 15 h 43 min

    thank you, very nice script.
    but i had to edit every line, because there some very strange chars in there.

    this : »
    should be:  »

    dont know, perhaps its an encoding problem.
    woudl recommend you supply a download link.

    greetings

  • NN REDDY dit :
    22 décembre 2011 à 6 h 46 min

    Thank u very much this is very usefull.

RSS feed for comments on this post. TrackBack URL

Leave a Reply