oracle11g自动备份批处理

oracle11g自动备份批处理

 

rem先用sys账号到pl/sql或toad里执行
rem 建立目录变量路径
rem create or replace directory backdir as 'f:\orclBak\expdp';
rem 注意,磁盘上有要相应的目录路径
rem 赋于读写权限给zjgl5用户
rem grant read,write on directory backdir to zjgl5;
rem 查看目录变量
rem select*from dba_directories;
rem modify by huys 2012/3/22
rem ##########################################################

@echo off
@echo start backup...

@For /F "tokens=1,2,3 delims=/" %%A in ('Date /t') do @(
Set Day=%%A
Set Month=%%B
Set Yeah=%%C
)

rem设置备份目录
set backpath=f:\orclBak\expdp

rem设置当前日期
set todaydate=%Day%%Month%%Yeah%
rem echo %todaydate:~0,8% 从第1位取,取出8个字符,即年月日

rem设置访问数据库用户名
set userName=huzhou

rem设置访问数据库密码
set userPass=huzhou

rem设置服务名
set serviceName=orcl

@echo导出数据库
expdp %userName%/%userPass%@%serviceName% DIRECTORY=BACKDIR DUMPFILE='jiax_%todaydate:~0,8%.dmp' logfile='jiax_%todaydate:~0,8%.log' schemas=%userName%
rem 导入数据库脚本 impdp %userName%/%userPass% DIRECTORY=BACKDIR DUMPFILE=JIAX_20120323.DMP

@echo start zip...
rem -j参数是不会有目录结构
zip  -j "%backpath%"\jiax_%todaydate:~0,8%.zip "%backpath%"\jiax_%todaydate:~0,8%.dmp "%backpath%"\jiax_%todaydate:~0,8%.log

@echo压缩后,把dmp文件删除
del "%backpath%"\jiax_%todaydate:~0,8%.dmp
del "%backpath%"\jiax_%todaydate:~0,8%.log

rem删除7天前的备份,注意不是看文件名日期,而是文件的创建日期
forfiles /p "%backpath%" /m *.zip -d -7 /c "cmd /c del /f @path"
exit

 

把上面这段代码另存为一个bat文件，修改相应信息改成你的，然后用windows的计划任务，就可以实现每天自动备份