oracle数据库备份和导入 bat 脚本
if "%time:~0,2%" lss "10" (set HH=0%time:~1,1%) else (set HH=%time:~0,2%) exp wqpm/wqpm@170.18.10.109:1521/orcl buffer=64000 file=F:\test\WQPM_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%HH%%TIME:~3,2%%TIME:~6,2%_srv12.dmp log=F:\test\WQPM_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%HH%%TIME:~3,2%%TIME:~6,2%_srv12_exp.log owner=wqpm compress=N forfiles /p F:\test /d -30 /s /m
备份脚本
170.18.10.109:1521 为内网oracle地址和端口
orcl 为oracle库
file=F:\test\WQPM_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%HH%%TIME:~3,2%%TIME:~6,2%_srv12.dmp 为dmp导出文件 按时间设置文件名字,以及文件放置位置F盘。。。
等等
imp wqpm/wqpm@170.18.10.109:1521/orcl full=y file=F:\xxx.dmp
导入脚本