@echo off
Echo ================================================
Automated backup scripts for Oracle databases in the Echo Windows environment
Echo 1. Use the current date to name the backup file.
Echo 2. Automatically delete backups up to 7 days ago.
Echo ================================================
:: Remove the current time in "YYYYMMDD" format.
Set backupdate=%date:~0,4%%date:~5,2%%date:~8,2%
:: Set the user name, password, and database to be backed up.
Set User=xxx
Set password=123456
Set Database=dbtest
:: Create a backup directory.
If not exist "D:\backup\data" mkdir D:\backup\data
If not exist "D:\backup\log" mkdir D:\backup\log
Set Datadir=d:\backup\data
Set Logdir=d:\backup\log
Exp%user%/%password%@%database% file=%datadir%\data_%backupdate%.dmp Log=%logdir%\log_%backupdate%.log
:: Delete the backup 7 days ago.
forfiles/p "%datadir%"/s/m * */d-7/C "cmd/c del @path"
forfiles/p "%logdir%"/s/m * */d-7/C "cmd/c del @path"
Exit
Copy from http://blog.csdn.net/iw1210/article/details/39312783
Automated backup scripts for Oracle databases in Windows environments
Batch file (. bat)
Reproduced Oracle automatically backs up under Windows and deletes today's scripts: