oracle 定期備份

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
echo off
 
SETLOCAL
 
for /F "tokens=1-4 delims=/ " %%i in ('date /t') do (
 
set Year=%%i
 
set Month=%%j
 
set Day=%%k
 
set DayOfWeek=%%l
 
)
 
@echo Date:%DayOfWeek%
 
set NLS_LANG=TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950
 
 
 
EXP sedb/sedb0000 file=D:\oracle\sedbBackup_%Year%%Month%%Day% log=d:\oracle\sedbBackup.log owner=sedb

把上面這些存成bat檔,用windows排程去執行就可以了

Be the first to comment on "oracle 定期備份"

Leave a comment

Your email address will not be published.


*