ora_backup.sh

一个程序和数据库备份脚本

#/bin/bash

#set Variable
MONTH=`date +"%Y%m"`
logFile=/backup/.script/ntpms/log/backup_"$MONTH".log
backDir=/backup/data/
dest_backDir=/backup/data/
ora_user=ntpms
ora_passwd=netsky
ftp_dest=132.233.33.99
ftp_user=oracle
ftp_passwd=netsky
DATE=`date +"%Y%m%d"`

#set env
ORACLE_BASE=/oradata/data
ORACLE_HOME=/home/oracle/10.2.0.1
ORACLE_SID=ntpms
NLS_LANG=american_america.ZHS16GBK
PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_HOME ORACLE_BASE ORACLE_SID NLS_LANG PATH;

#export the oracle backup
date >> $logFile
echo start backup file="$backDir"ntpms_"$DATE".dmp >> $logFile
exp ntpms/netsky file="$backDir"ntpms_"$DATE".dmp owner="$ora_user"
echo end backup >>$logFile
date >> $logFile

#if [today is Friday] copy the file to archive directory
echo start archive file ntpms_"$DATE".dmp >> $logFile
WEEK=`date +%u`
if [ ! -z "$WEEK" ]
then
	if [ "$WEEK" -eq 5 ]&&[ ! -f "$backDir"archive/ntpms_"$DATE".dmp ]
	then
		cp "$backDir"ntpms_"$DATE".dmp "$backDir"archive/
	fi	 
fi

#leave the last four days data,delete other
FOUR_DAYS_BEFORE=`date -d "4 days ago" +%Y%m%d`
echo start delete the file before four days ntpms_"$FOUR_DAYS_BEFORE".dmp >> $logFile
if [ -f "$backDir"ntpms_"$FOUR_DAYS_BEFORE".dmp ]
then
	rm -rf "$backDir"ntpms_"$FOUR_DAYS_BEFORE".dmp
fi

#transfer file to remote host 
echo start transfer file <ntpms_"$DATE".dmp> to $ftp_dest >> $logFile
ftp -n <<!
open $ftp_dest
user $ftp_user $ftp_passwd
binary
prompt off
cd $dest_backDir
lcd $backDir
put "$dest_backDir"ntpms_"$DATE".dmp
bye
!
echo end transfer >> $logFile
date >> $logFile	
exit