Oracle Scheduled backups

The first step, bat script:

@echo off
echo Delete the spare files and logs from 10 days ago

forfiles/p "Z:/back"/M *.dmp/d -10/c "cmd/c del @path"
forfiles/p "Z:/back"/M *.log/d -10/c "cmd/c del @path"

Echo is backing up the Oracle database, please wait a moment ...
Exp Sxybyj/[email protected] file=z:/back/mdb%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=z:/back/mdb%date:~0,4%%date : ~5,2%%date:~8,2%.log
The echo task is complete!

Step two, create a new Windows scheduled task

Go to the Windows Control Panel, open the schedule and tasks, create a new task, click Browse, select the Oraclebackup.bat file under the new D-Disk Oraclebackup directory. Then choose 22:00 every night to execute, and then enter the local administrator password can be.

Oracle Scheduled backups