1)Windows客户端环境下exp备份导出方式一
echo 开始导出数据库!
if not exist E:\Data_Backup\A++ mkdir E:\Data_Backup\A++
exp qycw/qycw@10.106.125.59/qygk file=E:\Data_Backup\A++\qycw_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.dmp log=E:\Data_Backup\A++\qycw_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.log
"C:\Program Files (x86)\WinRAR\rar.exe" a -r E:\Data_Backup\A++\qycw_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.rar E:\Data_Backup\A++\qycw_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.dmp
del E:\Data_Backup\A++\qycw_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.dmp
echo 导出数据库完毕!
Forfiles /p E:\Data_Backup\A++\ /s /d -28 /m *.* /c "cmd /c del @file"
exit
2)Windows客户端环境下exp备份导出方式二
Set ExpUser=username ##自定义##
Set ExpPass=password ##自定义##
Set OrclSid=ORACLE_SID ##自定义##
Set FileDir=E:\Data_Backup\A++\ ##自定义##
Set SysDate=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%
Set FileName=%ExpUser%_%SysDate%
@echo * * * * * * * * * * * * * * * * * * * * * * * * * *
@echo * * * * * * * ORACLE数据库备份 * * * * * * * * *
@echo * * * * * * * * * * * * * * * * * * * * * * * * * *
@echo 开始导出数据库
if not exist %FileDir% mkdir %FileDir%
exp %ExpUser%/%ExpPass%@%OrclSid% file=%FileDir%\%FileName%.dmp log=%FileDir%\%FileName%.log
@echo 数据库备份完成
@echo 开始压缩数据库备份文件
"C:\Program Files (x86)\WinRAR\rar.exe" a -r %FileDir%\%FileName%.rar %FileDir%\%FileName%.dmp
##压缩程序所在位置自定义##
@echo 数据库备份压缩完成!
del %FileDir%\%FileName%.dmp
Forfiles /p %FileDir% /s /d -28 /m *.* /c "cmd /c del @file" ##文件保留数量自定义##
3)Windows客户端环境下expdp方式备份导出
在数据库中创建目录
sqlplus / as sysdba
SQL> CREATE OR REPLACE DIRECTORY dump_path AS 'F:\DBBACKUP\dump';
备份脚本
rem CREATE OR REPLACE DIRECTORY dump_path AS 'F:\DBBACKUP\dump';
Set FileDir=F:\DBBACKUP\dump
Set SysDate=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%
Set FileName=WCCZBT_%SysDate%
@echo 开始导出数据库
if not exist %FileDir% mkdir %FileDir%
E:\app\Oracle\product\11.2.0\dbhome_1\BIN\expdp.exe '/ as sysdba ' full=y DIRECTORY=dump_path DUMPFILE=%FileName%.dmp LOGFILE=%FileName%.log
@echo 数据库备份完成
@echo 开始压缩数据库备份文件
"C:\Program Files\WinRAR\rar.exe" a -r %FileDir%\%FileName%.rar %FileDir%\%FileName%.dmp
@echo 数据库备份压缩完成!
del %FileDir%\%FileName%.dmp
Forfiles /p %FileDir% /s /d -28 /m *.* /c "cmd /c del @file"
rem 备注,不执行