Backup Oracle Batch method on Windows (with scheduled tasks or third-party timing software that can be automatically backed up)

@echo Start backing up Oracle data

@echo off
Set
set curdir= "D:\backup"
Echo%curdir%
Set t1=%time:~0,1%
if "%t1%" = = "" Set t1=0
Set td=%date:~0,4%%date:~5,2%%date:~8,2%%t1:~0,1%%time:~1,1%%time:~3,2%%time:~6,2%

ExpNaricom/[email protected]owner= (MW_APP,MW_SYS,STATDBA,DICTDBA) file=%curdir%\Sgtms_%td%.dmp log=%curdir%\Sgtms_%td%. Log buffer=800000

echo Create a compressed file and delete the source backup file log file
Zip%curdir%\Sgtms_%td%.zip%curdir%\Sgtms_%td%.dmp%curdir%\Sgtms_%td%. Log
del%curdir%\*.dmp
del%curdir%\*. Log
echo Complete file compression

@echo on
@echo Backup Oracle data End

Backup Oracle Batch method on Windows (with scheduled tasks or third-party timing software that can be automatically backed up)