Oracle自动备份脚本(Windows和Linux)

rem windows环境下Oracle数据库的自动备份脚本。
rem 可以将本批处理设成windows任务计划下自动执行。
 
@echo off
@echo ================================================
@echo  windows环境下Oracle数据库的自动备份脚本
@echo ================================================
 
rem 以下变量需要根据实际情况配置
rem 备份存放的目录
set BACKUP_DIR=D:\DataBaseBackUp
 
rem 配置
rem 备份的数据库
set USER=data_center
rem 数据库密码
set PASSWORD=123456
rem 备份
for /f "tokens=1,2" %%a in ('date/t') do set TODAY=%%a
set BACK_NAME=%USER%_%TODAY%(%time:~0,2%时%time:~3,2%分)
set BACK_FULL_NAME=%BACKUP_DIR%\%BACK_NAME%
exp %USER%/%PASSWORD%@orcl owner=%USER% file="%BACK_FULL_NAME%.dmp" log="%BACK_FULL_NAME%.log"

#!/bin/sh
#根据情况需要配置
#数据库备份存放目录
BACKUP_DIR=/opt/backup/oracle
#进行备份
#备份数据库名
BACKUP_USER=exam
#数据库密码
BACKUP_PASSWORD=123456
su - oracle -c "exp $BACKUP_USER/$BACKUP_PASSWORD owner=$BACKUP_USER file=$BACKUP_DIR/$BACKUP_USER.dmp log=$BACKUP_DIR/$BACKUP_USER.log"
#将备份进行压缩存档
cd $BACKUP_DIR
tar -zcvf  ./zip/$BACKUP_USER-`date +%y%m%d%H%M`.tar.gz  $BACKUP_USER.dmp $BACKUP_USER.log