Oracle 备份导出脚本

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 备注，不执行