Oracle 自动备份

最新推荐文章于 2024-10-01 14:04:29 发布

losgou

最新推荐文章于 2024-10-01 14:04:29 发布

阅读量405

点赞数

文章标签： oracle date path buffer wap linux

本文链接：https://blog.csdn.net/crsit/article/details/6154240

版权

linux 自动备份脚本

#Backup script writen by liyong
#2006.05.22
#version 1.2
#!/bin/sh
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin

#Set variable for this script.
dateStr=`/bin/date +%Y%m%d`
dmpFileName=$dateStr'_svm.dmp'
dmpLogName=$dateStr'_svm.log'
dmpLocation='/oracle/backup/svm/'$dmpFileName
logLocation='/oracle/backup/log/'$dmpLogName

#Begin to dump.
echo $(date +"%y-%m-%d %H:%M:%S") >>$logLocation
echo "----------Begin to dump wap's data.-----------" >>$logLocation
exp svm/svm owner=username file=$dmpLocation log=$logLocation rows=y FEEDBACK=100000 buffer=100000000
gzip $dmpLocation
rm -rf $dmpLocation
echo "----------End to dump wap's data.-----------" >>$logLocation
echo $(date +"%y-%m-%d %H:%M:%S") >>$logLocation

用oracle 用户加入定时执行crontab -e

30 1 * * 6 /oracle/backup/backup.sh
50 2 * * * find /oracle/backup/svm -type f -mtime +30 -exec rm -f {} /;
50 2 * * * find /oracle/backup/log -type f -mtime +30 -exec rm -f {} /;