Skip to content

Latest commit

 

History

History
71 lines (43 loc) · 1.64 KB

db-backup-script.rst

File metadata and controls

71 lines (43 loc) · 1.64 KB
Raw

Oracle DB Backup Shell Script

This backup script is only valid for Linux server.

File dbdump.sh

#!/bin/sh

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SCHEMA=$2
export ORACLE_SID=$1

EXPORT_FOLDER=/home/sangah/dbdump
ORACLE_USER=<USER>
ORACLE_PASSWORD=<PASSWORD>
DATE=$(date +"%Y%m%d_%H%M")

$ORACLE_HOME/bin/expdp $ORACLE_USER/$ORACLE_PASSWORD \
directory=SANGAH_DUMP_DIR schemas=${ORACLE_SCHEMA} \
dumpfile=$DATE-${ORACLE_SCHEMA}_export.dmp \
logfile=$DATE-${ORACLE_SCHEMA}_export.log rows=y consistent=y feedback=1000

cd $EXPORT_FOLDER
tar cjf $DATE-${ORACLE_SCHEMA}_export.tar.bz2 \
$DATE-${ORACLE_SCHEMA}_export.dmp \
$DATE-${ORACLE_SCHEMA}_export.log

rm $EXPORT_FOLDER/$DATE-${ORACLE_SCHEMA}_export.dmp $EXPORT_FOLDER/$DATE-${ORACLE_SCHEMA}_export.log

find $EXPORT_FOLDER/*${ORACLE_SCHEMA}_export.tar.bz2 -mtime +15 -delete

File dbbackup.sh

Append to this file all the users that you want to backup.
#!/bin/sh

# Add the following line to crontab ( to edit crontab use the command: crontab -e )
# 05 12 * * * sh /home/sangah/script/dbbackup.sh

echo Starting DB backup...
sh /home/sangah/script/dbdump.sh AL32UTF8 YRP
sh /home/sangah/script/dbdump.sh AL32UTF8 LCT
sh /home/sangah/script/dbdump.sh AL32UTF8 DSP
...

Put these files in a folder on the server, then type

> crontab -e

Add the following schedule to the crontab and save

05 12 * * * sh /home/sangah/script/dbbackup.sh

Note

Replace the folder /home/sangah/script/ with your folder.