Oracle数据库备份

将下面的语句保存为批处理文件，即backup.dat，双击即可实现数据库备份。

1.数据库导出，保存格式为“年月日日期时分秒.dmp”，带有日志

exp 用户名/密码@数据库实例名 file=%date:~0,4%%date:~5,2%%date:~8,2%%date:~11,3%%time:~0,2%%time:~3,2%%time:~6,2%.dmp log=%date:~11,3%导出.log full=n

 

 2.数据库压缩导出，保存格式为 “年月日日期时分秒.rar”

@echo off
set txt1=%date:~0,4%%date:~5,2%%date:~8,2%%date:~11,3%%time:~0,2%%time:~3,2%%time:~6,2%
e:
cd \DB-backup   ::保存文件路径
if exist %txt1%.rar del %txt1%.rar
echo Backup Database……
exp 用户名/密码@数据库实例名 file=%txt1%.dmp owner=用户名
set path=%path%;C:\Program Files\WinRAR  ::WinRAR安装目录
rar a e:\DB-backup\%txt1%.rar e:\DB-backup\%txt1%.dmp
if exist %txt1%.dmp del %txt1%.dmp
echo Done.