oralce定期备份
关键字: db
網上找的bat.在window任務設定
每天備份并rar打包.保留一周的備份
Sql代码 复制代码
1. set oracle_username="
test"
2. set oracle_password="abc12!^"
3. set local_tnsname="225_orcl"
4.
5. set winrar_path="C:\Program Files\WinRAR\"
6.
7. set path=%path%;%winrar_path%
8.
9. for /f "tokens=1-4 delims=/ " %%i in ('date /t') do set day=%%j
10.
11. set url=%oracle_username%/%oracle_password%
12.
13. if not %local_tnsname% == "" set url=%url%@%local_tnsname%
14.
15. exp %url% file=%oracle_username%_%day%.dmp log=%oracle_username%_%day%.log
16.
17. if %errorlevel% == 0 rar a -m5 -df %oracle_username%_%day% %oracle_username%_%day%.dmp %oracle_username%_%day%.log
set oracle_username="test"
set oracle_password="abc12!^"
set local_tnsname="225_orcl"
set winrar_path="C:\Program Files\WinRAR\"
set path=%path%;%winrar_path%
for /f "tokens=1-4 delims=/ " %%i in ('date /t') do set day=%%j
set url=%oracle_username%/%oracle_password%
if not %local_tnsname% == "" set url=%url%@%local_tnsname%
exp %url% file=%oracle_username%_%day%.dmp log=%oracle_username%_%day%.log
if %errorlevel% == 0 rar a -m5 -df %oracle_username%_%day% %oracle_username%_%day%.dmp %oracle_username%_%day%.log
其中
1.
Sql代码 复制代码
1. for /f "tokens=1-4 delims=/ " %%i in ('date /t') do set day=%%j
for /f "tokens=1-4 delims=/ " %%i in ('date /t') do set day=%%j
這個如果是繁體或
其它操作系統可能不一樣最好本機測試一下.是不是產生星期x
繁體試用
Sql代码 复制代码
1. for /f "tokens=1-4 " %%i in ('date /t') do set day=%%j
for /f "tokens=1-4 " %%i in ('date /t') do set day=%%j
2.
Sql代码 复制代码
1. if %errorlevel% == 0 rar a -m5 -df %oracle_username%_%day% %oracle_username%_%day%.dmp %oracle_username%_%day%.log
if %errorlevel% == 0 rar a -m5 -df %oracle_username%_%day% %oracle_username%_%day%.dmp %oracle_username%_%day%.log
這個錯誤等級.有可能會出現警告.這樣就不會rar打包了.可修改為
Sql代码 复制代码
1. rar a -m5 -df %oracle_username%_%day% %oracle_username%_%day%.dmp %oracle_username%_%day%.log
rar a -m5 -df %oracle_username%_%day% %oracle_username%_%day%.dmp %oracle_username%_%day%.log
google_protectAndRun("render_ads.js::google_render_ad", google_handleError, google_render_ad);