@echo 开始备份....
@echo 本程序使用zip压缩,备份后的文件可使用rar或者zip解压。
set /p username=用户名:
set /p password=密码:
set /p extname=备份后的文件扩展名:
set /p path=文件保存路径:
mkdir "%path%"
set filename=d:\backup\oracle\oracle%date:~0,10%-%time:~0,2%
@echo %filename%
exp %username%/%password% file=%filename%.dmp owner=%username% log=%filename%.log
zip -r %filename%.%extname% %filename%.dmp %filename%.log
del %filename%.dmp
del %filename%.log
@echo 备份完毕!
@echo 备份文件为:%filename%.%extname%
pause
@echo 本程序使用zip压缩,备份后的文件可使用rar或者zip解压。
set /p username=用户名:
set /p password=密码:
set /p extname=备份后的文件扩展名:
set /p path=文件保存路径:
mkdir "%path%"
set filename=d:\backup\oracle\oracle%date:~0,10%-%time:~0,2%
@echo %filename%
exp %username%/%password% file=%filename%.dmp owner=%username% log=%filename%.log
zip -r %filename%.%extname% %filename%.dmp %filename%.log
del %filename%.dmp
del %filename%.log
@echo 备份完毕!
@echo 备份文件为:%filename%.%extname%
pause