oracle备份压缩删除上传脚本

+++++++++++++++++++++++++++++++++++++++数据库备份压缩删除脚本++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
set vcoodate=%date:~0,4%%date:~5,2%%date:~8,2%
set ORACLE_SID=orcl
rem set NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8
expdp expuser/expuser schemas=goods directory=dpdata1 dumpfile=goods_%vcoodate%.dmp logfile=goods_%vcoodate%.log
expdp expuser/expuser schemas=trans directory=dpdata1 dumpfile=trans_%vcoodate%.dmp logfile=trans_%vcoodate%.log


rem --设置指定路径为D:\dbback
set "pt=D:\dbback" 


rem --获取指定路径下所有文件和文件夹的名称 
for /f %%i in ('dir /b D:\dbback') do ( 


rem --这里做为显示的命令参数
"C:\Program Files\WinRAR\rar.exe" a -df D:\dbback\%%i.rar D:\dbback\%%i
) 
echo 压缩完成！


copy D:\dbback\*%vcoodate%*.rar z:\


forfiles /p "D:\dbback" /s /m *.rar /d -5 /c "cmd /c del /f @path" 
+++++++++++++++++++++++++++++++++++++++创建导出用户的SQL++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
create directory dpdata1 as 'D:\dbback';


create user expuser identified by expuser
default tablespace users
temporary tablespace temp
account unlock;


grant connect,resource to expuser;
grant exp_full_database to expuser;
grant read,write on directory dpdata1 to expuser;
++++++++++++++++++++++++++++++++++++++++应用服务器自动删除脚本+++++++++++++++++++++++++++++++++++++++++++++++++++++++


forfiles /p "D:\dbback" /s /m *.rar /d -30 /c "cmd /c del /f @path"