window下自动备份数据库oracle11g

• 执行失败1backup.bat：每次提示输入数组提取缓冲区大小: 4096 >
  要手动输完

https://www.cnblogs.com/xqz0618/p/oracle_backup2.html

@echo off
exp doo/doo@TEST
file=E:\Document\Desktop\Test_Backup\name_%date:~0,4%%date:~5,2%%date:~8,2%.dmp
log=E:\Document\Desktop\Test_Backup\name_%date:~0,4%%date:~5,2%%date:~8,2%.log
path C:\Program Files\WinRAR\WinRAR.exe
winrar a -agYYYY-MM-DD -DF -m5 E:\Document\Desktop\Test_Backup\name{Test_Backup}.rar E:\Document\Desktop\Test_Backup\*.dmp E:\Document\Desktop\Test_Backup\*.log
forfiles /p "E:\Document\Desktop\Test_Backup" /s /m *.rar /d -30 /c "cmd /c del @path" 

• 成功
  https://blog.csdn.net/fy_hanxu/article/details/76064334

@echo off

set curdate=%date:~0,4%%date:~5,2%%date:~8,2%

set backuppath=E:\Document\Desktop\Test_Backup
md %backuppath%

exp doo/doo@TEST file=%backuppath%\%curdate%.dmp owner(doo) log=%backuppath%\%curdate%.log
forfiles /p "E:\Document\Desktop\Test_Backup" /s /m *.dmp /d -30 /c "cmd /c del @file"

set curdate设置日期
set backuppath设置路径
exp导出数据库 owner(doo) 属于doo的所有表，（）里可以加别的用户，也可写单表名逗号隔开
log别另起行 空格与前面隔开
forfiles 满30个文件删最旧的，d -30 数字可改 满30个