oracle数据备份(只备份最近两天的数据),还需要修改什么地方?很多地方看不懂,如果有详细的解释最好了。在下新手,多多包涵,谢谢!
@echo off
set CURRENT_PATH=%cd%
set CURRENT_DISK=%CURRENT_PATH:~0,2%
set SHELL_DISK=%~d0
set SHELL_PATH=%~d0%~p0
set SHELL_NAME=%~n0%~x0
echo current path %CURRENT_PATH%
echo shell path %SHELL_PATH%set "back_users=COGNOS,COGNOSAUDIT,COGNOSNOTE"
set path=%path%;D:\soft\oracle\dbhome_1
set SYS_DMP_DIR="F:\oracle\dmp\day"
set DMP_DIR=WORK_DIR
set V_DATE=%date:~0,4%%date:~5,2%%date:~8,2%rem expdp 'sys/oracle@orcl as sysdba' DIRECTORY=%DMP_DIR% DUMPFILE=%V_DATE%_USERS.dmp SCHEMAS=%back_users% LOGFILE=%V_DATE%_EXPDP_USERS.log