windows下 oracle备份脚本

以下是一个简单的Windows下Oracle备份脚本：

@echo off

set ORACLE_SID=ORCL
set ORACLE_HOME=C:\app\oracle\product\11.2.0\dbhome_1

set BACKUP_DIR=C:\backup

set DATE=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%
set TIME=%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%

set LOG_FILE=%BACKUP_DIR%\backup_%DATE%_%TIME%.log

echo Starting backup at %DATE% %TIME% >> %LOG_FILE%

echo Creating backup directory >> %LOG_FILE%
mkdir %BACKUP_DIR%\%DATE%_%TIME%
set BACKUP_PATH=%BACKUP_DIR%\%DATE%_%TIME%

echo Exporting Oracle database schema >> %LOG_FILE%
exp username/password@localhost/file=%BACKUP_PATH%\schema.dmp owner=schema

echo Exporting Oracle database data >> %LOG_FILE%
exp username/password@localhost/file=%BACKUP_PATH%\data.dmp

echo Compressing backup files >> %LOG_FILE%
cd %BACKUP_DIR%
7z a -tzip %BACKUP_PATH%.zip %BACKUP_PATH%

echo Backup completed at %DATE% %TIME% >> %LOG_FILE%

其中，需要根据实际情况修改以下几个变量：

- `ORACLE_SID`：Oracle实例名
- `ORACLE_HOME`：Oracle安装目录
- `BACKUP_DIR`：备份文件存放目录
- `DATE`：备份日期，格式为yyyymmdd
- `TIME`：备份时间，格式为hhmmss

脚本中的备份方式为使用Oracle exp工具进行导出，并使用7zip进行压缩。可以根据需要修改备份方式。