bat文件，定时备份oracle数据

1、bat文件，定时备份oracle数据

 

 

set a=%date:~0,4%%date:~5,2%%date:~8,2%

exp gxjhpt/gxjhpt@orcl  file=E:\oracle_beifen\%a%.dmp


forfiles /p "E:\oracle_beifen" /s /m *.* /d -5 /c "cmd /c del @path"

 

 

2、或者用一下常用案例

 

set filename=sdwljg%date:~0,4%%date:~5,2%%date:~8,2%

 

exp sdwljg/sdwljg@orcl  file=E:\oracle\oraclebackup\data\%filename%.dmp log=E:\oracle\oraclebackup\log\%filename%.log

 

 

forfiles /p "E:\oracle\oraclebackup\data" /s /m *.* /d -7 /c "cmd /c del @path"

 

forfiles /p "E:\oracle\oraclebackup\log" /s /m *.* /d -7 /c "cmd /c del @path" 

 

 

 

 

3、金仓数据库备份

sys_dump -h localhost -p 54321 -U SYSTEM -W gentle -f d:\dbbak\sxmjcms%date:~0,4%%date:~5,2%%date:~8,2%%date:~11,3%.dmp SXMJCMS