求一份oracle自动备份脚本

Question

1.window下
2.每个月一号0点备份一次就行

Answer 1

新建一个文件，保存.bat批处理
if "%time:~0,1%"==" " (set backup_file=%date:~0,10%-0%time:~1,1%) else (set backup_file=%date:~0,10%-%time:~0,2%)
exp apps/pwd@192.168.1.206/orcl file=%backup_file%.dmp log=%backup_file%.log owner=(apps)
rar a %backup_file%.rar *.dmp *.log
del *.dmp
del *.log

需要配置环境变量:
PATH
C:\Program Files\WinRAR