@echo off set BACKUP_DIR=G:\backup set db=orcl G: cd %BACKUP_DIR% C:\oracle\product\10.2.0\db_1\BIN\expdp.exe system/*****@%db% dumpfile=%db%.dmp schemas=(user1) logfile=export_log_%db%.txt %BACKUP_DIR%\rar a -m5 -df %BACKUP_DIR%\%db%.rar C:\oracle\product\10.2.0/admin/orcl/dpdump/%db%.dmp if exist %BACKUP_DIR%\%db%_%date:~0,2%.rar del /F /Q %BACKUP_DIR%\%db%_%date:~0,2%.rar move %backup_dir%\%db%.rar %backup_dir%\%db%_%date:~0,2%.rar move C:\oracle\product\10.2.0\admin\orcl\dpdump\export_log_%db%.txt %backup_dir%\export_log_%db%.txt