Backup Oracle database with Windows Batch Script
This simple batch script creates a new folder based on the date and time and then executes a oracle database dump.
REM Backup oracle database
@echo Starting database backup
REM get the current datestamp in the format year-month-day-hour-minute
SET DATESTAMP=%date:~6,4%-%date:~3,2%-%date:~0,2%-%time:~0,2%-%time:~3,2%
REM Create a new directory
md "c:\backup\%DATESTAMP%"
REM backup database
REM Dont forget to change username and password
exp username/password@xe FILE="c:\backup\%DATESTAMP%\databasename.dmp"
@echo Finished backing up database to c:\backup\%DATESTAMP%