数据库备份批处理

@echo off
color 0A

echo 开始oracle数据库备份.......

rem 使用for语句取到当前日期 生成含日期的dmp文件


for /F %%i in ('date /T') do exp

userid=username/password@188.188.188.9:1521/orcl owner=username

compress=yes grants=yes file=db_%%i.dmp log=db_%%i.log


rem for /F %%i in ('time /T') do exp userid=nc5011/1@oracle

owner=nc5011 compress=yes grants=yes file=nc_%%i.dmp
echo 完成oracle数据库备份.......

rem pack

rem 打包

rem @echo off
rem set CMD_RAR="C:\Program Files\7-Zip\7zFM.exe"
rem set CMD_RAR=echo
rem color 0A
echo 压缩数据文件.......
rem for /F %%i in ('dir /b *.dmp') do %CMD_RAR% a -df %%~ni %%i