1.建立一个名为backup.sh的脚本文件
2.保存文件内容如下所示:(具体内容,请视自已情况而定)
#setup backup directory and backup file format
export backup_dir=/tmp
export expfile=newemos.`date '+%Y_%m_%d_%H_%M'`.dmp
export backup_dir=/tmp
export expfile=newemos.`date '+%Y_%m_%d_%H_%M'`.dmp
find /oracle/backupdb/*.Z -mtime +7 -exec rm -f {} \;
#remove old files,keep 10 copys
exp cent/cent file=$backup_dir/$expfile compress=y log=n
compress $backup_dir/$expfile
compress $backup_dir/$expfile
3.将上面的backup.sh加入到crontab中(例如下面的例子)
1 2 * * * su oracle "/home/oracle/backupdb.sh"
转载于:https://blog.51cto.com/dbpath/82811