ORACLE批量备份。运行后 自动备份->加密压缩->注释->归档

嘿嘿 每次备份要同时备份三个库，这下运行一个就好~爽 

@echo off

@title 数据库备份

@color 4a

@cd D:\WorkFiles\dbbackup\

@d:

@md SC%date:~0,4%%date:~5,2%%date:~8,2%

@exp *****/*****@***** file=D:/WorkFiles/dbbackup/SC%date:~0,4%%date:~5,2%%date:~8,2%/sc_ws_%

date:~0,4%%date:~5,2%%date:~8,2%%RANDOM%.dmp

@rar a -p******* SC%date:~0,4%%date:~5,2%%date:~8,2%.rar  SC%date:~0,4%%date:~5,2%%date:~8,2%

@rar c SC%date:~0,4%%date:~5,2%%date:~8,2%.rar@cd SC%date:~0,4%%date:~5,2%%date:~8,2% 

@del *.* /q

@cd..

@rd SC%date:~0,4%%date:~5,2%%date:~8,2%

@move SC%date:~0,4%%date:~5,2%%date:~8,2%.rar DATA\SC%date:~0,4%%date:~5,2%%date:~8,2%_%RANDOM%.rar

@echo on

第一处 *****/*****@***** 是数据库 用户名/密码@SID

第二处 p******* 是 p+解压密码